Viewing 15 posts - 36,691 through 36,705 (of 39,944 total)
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
Why can you not use an identity?
Also, does the number need to be generated in the select?
Steve Jones
March 3, 2003 at 5:11 pm
Viewing 15 posts - 36,691 through 36,705 (of 39,944 total)