Viewing 15 posts - 36,571 through 36,585 (of 39,720 total)
Use DTS to run this query on all servers and export to a Excel sheet. Run a separate transform in serial for each server.
Or you could use linked servers and...
January 26, 2003 at 6:32 pm
Brian Kelley has a couple good articles on Query Analyzer on this site.
Also, Andy Warren has some good DMO articles which might help.
Steve Jones
January 26, 2003 at 6:30 pm
There isn't a way to easily do this in T-SQL. Yukon will change that, but for now, I'd use DTS and activeX to do it. You could also port your...
January 26, 2003 at 6:29 pm
Similar to Bill here. Except we run full once a week, diffs the other nights. On some servers we run multiple diffs (up to 4) per day. In between we...
January 17, 2003 at 12:34 pm
The Trillian (www.ceruleanstudios.com) client will log the exchange, but not sure it's multi user.
I occassionally answer questions, but not sure I could do this if everyone did it. Wouldn't get...
January 16, 2003 at 10:45 am
IS there are question? are you wondering why this occurs? It's probably some delay between the SAMBA (assuming you are using this) sending back the authentication. This is why I...
January 16, 2003 at 10:42 am
Not that I'm aware of. Brian has done some of this using Distributed Partiitoned views. As long as your app is ok with it, should be ok.
Steve Jones
January 16, 2003 at 10:40 am
Some of this is dependent on the user submitting the information, like the Appname. Not sure if the IP falls into this.
Steve Jones
January 16, 2003 at 10:38 am
Books Online goes into some of the enhancements. Is there a particular area you are looking at?
Steve Jones
January 16, 2003 at 10:37 am
sp_dropserver (old name)
go
sp_addserver (new name), local
Steve Jones
January 16, 2003 at 10:33 am
We are looking at testing SQL-UP at SQL Server Central. We met with the vendor and do like the program. There are some limitations and issues (we need another box...
January 16, 2003 at 10:32 am
Nice high level article and something that I completely agree with. You need a process for managing changes.
Steve Jones
January 16, 2003 at 10:25 am
As long as you have not set any affinity, you should get the use of all 4 CPUs. If you set an affinity, you'd still see all 4 CPUs, but...
January 15, 2003 at 3:04 pm
Interesting idea and something we've considered. We'll kick it around.
Steve Jones
January 15, 2003 at 3:03 pm
I agree with above. Likely the log grew and filled the disk. When the transaction rolled back, the log shrank back. Do you have autoshrink on?
I'd move the table in...
January 15, 2003 at 10:44 am
Viewing 15 posts - 36,571 through 36,585 (of 39,720 total)