We are in the process of backing up server objects, databases, logins, DTS packages, SQL Jobs, etc., for Disaster Recovery. Here's the Activex script we used to backup the jobs as...

Great article! Will put some of the suggestions into place today.

I have never done this, but if I were to do it, I would write the result to a text file then read the text file in an Activex task...

If you Save As your package to a Visual Basic file (in SQL 2000, DTS Designer, select the Package.Save As menu item), you can then modify the result and reload...

If there are no complexity metrics for DTS packages you might consider Googling for "complexity metrics" with "SQL Server", etc. I doubt if there are any. You might be a...

Great article! I will keep it as a reference.

In a future article, you could say something about the views in the master database, such as tables, columns, etc.

Would an Execute Package Task help? It is in the 3rd row, 2nd column of the Task Toolbox in the SQL2K DTS Designer. You may have to assign Global Variables...

I am in favor of No personal internet at work, but it is imperative to have unlimited access to Google and other engines in order to research problems. I could not do...

Here's a simple one; it won't run because I've removed some stuff and you need the include, which is the connection string, but it will give you an idea:

<!--#Include File="sqldef.asp"-->

<%

FirstLogID...

You are on the right track.

Store the name of the package, servers, databases and tables in tables and then develop...

If you were to test the 10,000 updates on an empty table, would it still take 20 minutes? What I suspect that it is not the string functions that are...

I had to do something similar, except that I executed the dynamic sql. Actually I generated a stored proc,  captured the sql in a table, then used the following snippet...

I put the destination server/database names in a table; then a stored procedure reads the table in a cursor and for each loop iteration uses the OLE stored procedures sp_OACreate,...

Thanks Stuart, for sharing this secret with the rest of us.

Whenever I've had this problem it has ALWAYS been a permission issue. Somewhere, by some unsuspecting person, something got changed. One server's SQL Agent permission may have been revoked on...