Viewing 15 posts - 1 through 15 (of 15 total)
Say I've got a hundred databases, with all data files on one disk and all log files on another. How could I allocate a disk for every log file...
September 7, 2005 at 1:38 pm
i was doing it by session. i'm going to try it by server (changing the startup parameter).
August 12, 2005 at 3:13 pm
Thanks very much folks for your responses. I did argue the case and it wasn't at all difficult to convince them in this particular case. They found the problem elsewhere. ...
July 5, 2005 at 11:49 am
it's sa now for exactly those reasons. but i'm told that the vendor is insisting that the dbo be this other generic account. however, all of the objects...
June 30, 2005 at 12:49 pm
Check out the post on this forum (a few messages down) named "RE: Help! Can't restart SQL Server after detaching msdb" before you make the same mistake I did when...
June 14, 2005 at 8:32 am
I'm trying to centralize reporting against as many as six SQL Servers. My intention was to avoid duplicating code on each server. I'd have one reporting database on...
June 14, 2005 at 8:02 am
thanks very much! i'll give it a try.
in your opinion, would the solution proposed here be better or worse, in terms of maintenance, compared to creating the procedure locally...
June 13, 2005 at 1:08 pm
Turns out it's best not to detach msdb and model at the same time. Started SQL in single user mode to get past this problem.
June 13, 2005 at 11:55 am
I wouldn't say no to examples if you have the time Thanks very much for your response.
June 13, 2005 at 11:20 am
Hey, thanks for the response. When I take DTS out of the picture and just execute the stored procedure from SQL Query Analyzer on ServerB, I can see that...
June 13, 2005 at 9:07 am
thanks very much. i'm attempting to build a case against modifying the permissions and wanted to make sure i understood the scope. i appreciate your response!
November 3, 2004 at 3:25 pm
Viewing 15 posts - 1 through 15 (of 15 total)