Search results for query: *

Hi, I was wondering if it is possible to connect to SQL server 2008 using DTS in SQL server 2000. I need to pull data from the server running SQL server 2008. I was told it is not and need to validate. Is there anything that needs to be installed on either side for this to work. Any help is...

Hi, Is there a way to stop a DTS package if it takes too long. I want it to stop after 25 minutes. I was hoping there is a time limit option on the packages. Any help is appreciated. Thanks,

Hello JayKusch, Thanks for the reply. Where do you go to specify how the text fields are enclosed. I right click on the cells, go to format cells, and use text category but I do not see an option for how the data is enclosed. Where should I see this option? Thanks,

Hello, I am using a DTS to pump data to excel and am having problems with data that is of varchar datatype. The data goes into excel with a single quote in front of it. For example, 'name. How to I get rid of these single quotes? I am using SQL server 2000 and am dropping a table and...

Hello, I am administrating a server for many developers and DLLhost.exe seems to be going up and down slowing the system. I have tested for viruses and this does not seem to be the issue. I believe this is a memory leak. Is there any possible way to check which web site is causing the...

Hello, I am building a record locking script that uses a store procedure to lock records in a table. I would like to know if store procedures get executed one request at a time. This is important because I cannot have two users accessing the same record at the same time. I need to make sure...

Hello, I am submitting a form to itself and would like to know if there is a method for the form to know its been submitted more then once. In ASP you can you can write request.form.count > 1 Is there anything similar in PHP. I have been looking but cannot seem to find anything. Any help...

Hello, I am using asp and SQL Server 2000 and have a question concerning locking records. Let me explain: There are 26 orders showing and users click to get the next order so they can process it. What happens when two users click at the same time, I need one user to get order 26 and the...

I just found another thread that has the answer. Look at the properties of inetinfo.exe. Sorry about that. I'll take a closer look next time.

Hello, I need to determine which versions of IIS are running on certain servers. The operating systems are WINNT server and Windows 2000 server. I also need to know if there have been any service packs installed for IIS. Any help is appreciated. Thanks,

Hi, I'm new to using DTS and was wondering if its possible to create a text file dynamically. I know how to connect to a text and pump data into it but the problem is the text file will be used and deleted. Everything I've read so far requires you need a data source to pump data into. If...

Thanks for the help SQLBill. I found what I needed.

Sorry, does this mean I can still retrieve the data by restoring the database to how it was before the information was deleted or is it gone. If I can retrieve the data, how do I go about doing so. Thanks for your help.

Hi, A delete was just performed on one of our tables deleting all data for a specific day. Is there any way to restore the data from the transaction log. We are using SQL server 7 on WINNT server. Please let me know if you have any suggestions. Thanks,

Hello, I am trying to write a script in VB6 that will read a registry value and send it to a database. I was hoping someone could lead me in the right direction as to how to go about writing a script like this. If someone has sample code or knows were there is good info, please let me know...

You guys are awesome. I pieced together both your codes and it works perfectly. Thanks for all your help.

Hello, I am pulling shift codes for employees and I need to get all the information on one line. Each employee can have one to a maximum of three shift codes per day. I need to get the employees info and all their shift codes for each day on one line. I have the following: P01111 L9...

Hello All, I am having a problem grouping data within a report. My problem is as follows: For every ticket created within are system, a ticket has a series of status's. The status of ticket follow a sequential order: Pending Dispatch, Dispatch, Assigned, Pending Close, Closed. I need to...