Viewing 15 posts - 39,256 through 39,270 (of 39,466 total)
In EM, the properties for SQLAgnet include a "restart SQL Agent" if stoppped. Try that.
Steve Jones
October 5, 2001 at 2:10 pm
On a cluster, the clustered server has only one copy of the db. It is shared between teh servers but only availabel through the virtual server. If you have other...
October 5, 2001 at 2:07 pm
Save this as the DTS package and examine it. It may be including the collate option in the query to v6.5
Steve Jones
October 5, 2001 at 2:00 pm
October 5, 2001 at 1:58 pm
Thanks for the complements.
Nice solution. I wish I'd included this one :).
Steve Jones
October 5, 2001 at 1:57 pm
You could also do an spDropserver <servername> then an sp_addserver <newname>, local .
Steve Jones
October 5, 2001 at 10:09 am
They used to have them here:
http://msdn.microsoft.com/msdnnews/archive.asp
You might email the MSDN folks and ask. (and post back here).
Steve Jones
October 5, 2001 at 10:07 am
This is a good document:
I have my web servers dual homed (actually triple). It looks something like this:
...
October 3, 2001 at 10:15 am
October 3, 2001 at 9:59 am
Can you try starting with minimal config (-m I think) and check your sp_configure settings?
Steve Jones
October 3, 2001 at 9:57 am
I understand trying to remove connections if there are licensing issues, but otherwise, I agree with Andy. Why kill an idle connection. They use tens of kb of memory and...
October 3, 2001 at 9:53 am
OK, OK, I'm awake. BTW, I'm not that lazy, I just live in Denver.
OK, I think that a UDf would be great for calculations. they really make things easier to...
October 3, 2001 at 9:49 am
October 2, 2001 at 10:23 am
This is an interesting thread. My 2cents:
I think the production dba will continue to exist in larger shops. Even with the advances and ease of administering SQL Server 2000, quality...
October 2, 2001 at 10:18 am
there are a bunch of ways. is this a scheduled job? Add a step before that uses a CommandExec and a "del filename". you could also add a step to...
October 2, 2001 at 9:46 am
Viewing 15 posts - 39,256 through 39,270 (of 39,466 total)