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?

I like automated solutions. As much as I think Sugesh' is the simplest solution, if something doesn't work, then replication gets frustrating to work with.

Or it has in the...

The comments are crazy. You should search it out on Slashdot for some good humor.

I agree with you. Everything is a tool. Heck, I don't even care about the Mac...

If this is 2005, set a DDL trigger on the ALTER STORED PROCEDURE statement and log which stored procedures are changed and by who.

Logins aren't mapped to databases. Logins are mapped to users, which are in each database.

You need to scan the users in each database and relate those back to the login.

My guess is the clustered index is faster, but it's a guess. It provides a more ordered way for the optimizer to find the rows and delete them, but it...

Are you connected to it in the Registered Servers window? How are you connecting?