Viewing 15 posts - 39,511 through 39,525 (of 39,720 total)
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
This is corect. All the changes in SQL are considered a single transaction if this is one statement. This would be an implicit transaction.
Steve Jones
October 1, 2001 at 10:15 pm
Viewing 15 posts - 39,511 through 39,525 (of 39,720 total)