Thanks qbn and Allen,

I did a bit research on the issue and found that Named Pipes is the default Network Library for WinNT and above when connecting to SQL server....

I had a read of the article posted by Enthusiast. The security context in my case is not an issue. However the article reminds me that when I ran the...

Thank you site owner and Enthusiast. I will look into the anwser posted, and reschedual the package. Will post what happens later.

Thanks

YQ

Thanks all for your help. I have checked that on each box, the MSSQLServer services are running using a domain account, but different from the other. Both accounts have local admin rights on both...

I always use Jeremy's method, never have problems.

I got the correct answer because I could choose nothing else. However, this answer is not very correct. To fix it, you need to back up databases master, msdb,.. before...

If you are importing data to a table, what does it have to do with deleting?

If you delete the old data for new importing,the problem you have is very likely...

Sorry, I forgot you use SQL7. Try something like this:

bcp "select..." queryout myfile.txt -c -Syourserver -Usa -Ppassword

I would use

bcp "your query" out "yourfile.txt" -c

instead.

Just a thought.

Is this vbs file on the c: of the machine where the SQL server sits, or is it on the client machine, and you run QA on your...

I agree with sismith, and that is the format I use in all my queries. Never has a problem.

Thanks Allen. It's very clear now.

Can this situation be true where you have /PEA switch turned on, but AWE not enabled?

If it can be true, how big RAM SQL2000 can utilise in Maximum?

Thanks Allen.

Can I say that if AWE is not enabled, SQL2000 can only take up to 32GB on Datacenter?

You can right click one of the DTS packages you have and schedule the package. This will add a job under Jobs folder in Enterprise Manager. You then can match...