Viewing 15 posts - 36,466 through 36,480 (of 39,720 total)
You might have to run a sniffer for this. SQL Server responds when someone attempts to connect with the login informaiton. Not sure that Profiler traps this since the user...
March 7, 2003 at 9:35 am
Not sure how it can be changed, but this should be no impact to the use. Are they still owned by dbo?
It should be sysadmin only. I suspect that someone...
March 7, 2003 at 9:30 am
March 6, 2003 at 11:11 am
Not sure this is supported in DTS. Have you tried a linked server?
Steve Jones
March 6, 2003 at 10:57 am
Not a DMO guru, but it appears script is for dbs (existing) and generate is for other objects.
Is definitely poorly written.
Steve Jones
March 6, 2003 at 10:43 am
sp_helpdb, etc. There are numerous stored procedures the produce the information you seein Enterprise Manager.
Steve Jones
March 6, 2003 at 10:26 am
I added an alert with Buffer Cache Hit Ratio, falls below, 0.97 and it worked. I tried .97 and got an error. 97 worked just as you mentioned.
This is SQL...
March 6, 2003 at 10:20 am
Does the stop screen in services just hang? Does it report an error? Have you checked the SQLAgent log and the Event Log? It might be rolling back. Check sp_who2...
March 6, 2003 at 9:59 am
Don't think you can. I think the per seat to cpu is the only conversion.
The uninstall/reinstall isn't that painful. detach the dbs, uninstall, then install and attach. If you've got...
March 5, 2003 at 11:32 am
I agree that 2mil isn't a huge number, especially when you're probably querying for a single row most of the time for products. If not, then you should have some...
March 5, 2003 at 10:48 am
I think the optimizations rebuilds all indexes and marks them as "changed". Therefore they will be included in a differential backup.
Steve Jones
March 5, 2003 at 10:44 am
Create the stored procedure on the remote server and call it from your local server.
Steve Jones
March 5, 2003 at 10:42 am
I agree with Antares. You need another 4 licenses. Is this a web server backend? If so, why do you need another instance?
Steve Jones
March 5, 2003 at 10:37 am
Thanks. Never had a db with no owner, though that procedure makes sense.
Steve Jones
March 5, 2003 at 10:19 am
March 3, 2003 at 5:12 pm
Viewing 15 posts - 36,466 through 36,480 (of 39,720 total)