Viewing 15 posts - 1 through 15 (of 20 total)
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....
November 25, 2004 at 12:43 am
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...
October 12, 2004 at 5:57 pm
Thank you site owner and Enthusiast. I will look into the anwser posted, and reschedual the package. Will post what happens later.
Thanks
YQ
October 11, 2004 at 10:07 pm
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...
September 9, 2004 at 8:49 pm
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...
October 3, 2003 at 1:47 am
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...
September 28, 2003 at 5:59 pm
Sorry, I forgot you use SQL7. Try something like this:
bcp "select..." queryout myfile.txt -c -Syourserver -Usa -Ppassword
September 25, 2003 at 11:23 pm
I would use
bcp "your query" out "yourfile.txt" -c
instead.
September 25, 2003 at 11:14 pm
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...
September 25, 2003 at 7:40 pm
I agree with sismith, and that is the format I use in all my queries. Never has a problem.
September 24, 2003 at 7:34 pm
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?
September 21, 2003 at 10:41 pm
Thanks Allen.
Can I say that if AWE is not enabled, SQL2000 can only take up to 32GB on Datacenter?
September 18, 2003 at 6:27 pm
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...
September 11, 2003 at 10:10 pm
Viewing 15 posts - 1 through 15 (of 20 total)