Viewing 15 posts - 38,911 through 38,925 (of 39,456 total)
I ran a quick trace on sql 2000 and didn't see what EM is running? Why not use EM?
I am sure you can script something using the system tables, but...
November 19, 2001 at 9:54 am
For msdb, try removing the user.
For model, not sure. Can you change it as "sa"?
Steve Jones
November 19, 2001 at 9:37 am
Haven't seen anything like this. Can you provide more information? What was the server doing? What happens if you select * from Quary Analyzer?
Steve Jones
November 19, 2001 at 9:35 am
November 17, 2001 at 7:53 am
You have to change the address at the mail server (for all mails).
Alternatively, you can use CDO/CDONTS to generate the mail.
Steve Jones
November 16, 2001 at 4:12 pm
Not that I know of. I thought MSDE was licensed in a similar manner to Access runtime.
Steve Jones
November 16, 2001 at 9:22 am
November 16, 2001 at 9:20 am
November 15, 2001 at 3:27 pm
Be sure it is a "good query" (no cross joins, etc). If you are truly building such a huge query, you may run out of resources.
Steve Jones
November 15, 2001 at 2:50 pm
The query plan will only be reused if it is in memory. These have a much lower priority than stored procedures and get phaased out relatively quickly.
Steve Jones
November 15, 2001 at 12:19 pm
November 15, 2001 at 7:11 am
shut down the Anti Virus before installing. It probably does not like you updating the MDAC files. That is a place where someone would place a virus or a backdoor.
Steve...
November 14, 2001 at 10:08 am
November 14, 2001 at 9:43 am
Should be no issue. Is this an install of the SQL Server or the Service Pack.
Steve Jones
November 14, 2001 at 9:43 am
I've got a series on this very subject that should be starting soon. Hopefully it will give you some ideas about keeping your production and development in synch.
Steve Jones
November 14, 2001 at 9:30 am
Viewing 15 posts - 38,911 through 38,925 (of 39,456 total)