As a compromise, you might prefix things with sp only, as in spMyProc. This doesn't cause the performance issues.

Or you could do uspMyProc, which is something I've seen. A short...

You can monitor fragmentation with dbcc showcontig and then based on the results, decide which indexes you want to rebuild. Lots of scripts here on the site.

Other than that, SQL...

You need to create a connection on Server A, then perform the backup using this connection.

An ActiveX task is needed to perform the copy. The FileSystemObject in VBScript is probably...

The IP doesn't matter. SQL Server will bind to the host's ip.

The name does matter. You need to run

sp_dropserver

sp_addserver , local

and then restart SQL server.

Good points.

Either book is fine. I'm partial to Brian's book, but he's a business partner of mine, so I tend to use his resources.

I'd also look at sqlis.com

The way to do this is call the stored procedure from the ActiveX script. Then you can get an output variable or result set.

http://www.thescripts.com/forum/thread498718.html

DTS doesn't do a great job of...

What is the function doing? I tend to agree with the advice above, but I'm curious why you have two databases. Also, hard to tell if there is a performance...

I'd use a single database, create a table, and then populate it with the names of the databases from master.dbo.sysdatabases. I'd then run a loop through this table and execute...

Take the code out of the stored procedure and you should be able to use one of those. There aren't many ways to do this, so I'd use that code.

Is...

Target servers are typically remote servers sharing the plan, not the local server. The server you are connected to is the local server.

Don't know, but I'll pass it along.

First, you don't want to shrink as a general rule. Keep that in mind and try to avoid it.

Second, in your case, it makes sense, but SHRINKFILE doesn't move data.

You...

I wonder. Will let you know. I talked to a few owners that were in the high tens (80-90k) and no issues so far. Hadn't noticed issues with less power/charging.

We'll...

Very strange. If you manually run a full backup and then a log backup immediately afterwards, does that work?