We have a great deal of ETL here and we are using a single, central SSIS server to simply store all of our packages in the MSDB database.  The job...

I don't agree with someone slamming SSIS when they have an agenda - such as having their own ETL product in development.  I really get a kick out of the...

If you use VSS at your company, it works fine for this as well.  Script all of the procedures into two different folders and use VSS to compare the folders...

One more thing to add.  If you intend to have your SSIS packages run Analysis Services 2000 cube or dimension processing, you will need to install the AS 2000 tools...

It depends on what you are doing with the client tools.  If you intend to execute or edit DTS packages, you will need to.  If not, you may not need...

You can also SQL command to the SQL 2005 server and xp_cmdshell, remote command line, etc.  These options do not require the SQL 2005 tools to be installed on the...

A bit more clarification.

With the client tools, you will be able to open, edit, and run the package through the designer (Visual Studio).  You will not be able to simply...

How is this:

SET NOCOUNT ON

DECLARE @Schema VARCHAR(100), @Table VARCHAR(100), @Column VARCHAR(100), @Value VARCHAR(100), @sql VARCHAR(1000)

SET @Column = 'CountryName'

SET @Value = 'United States of America'

DECLARE ColCur CURSOR FOR

 SELECT Table_Schema,...

Other than the licensing cost, the upgrade is pretty painless and comes with a lot of nice new features.  You can continue to run SQL 2000 for the report server...

It is nothing complicated - just update the Name field in the Catalog table.

Still, I would make sure you have a good backup before starting this endeavor.

Not necessarily a suggestion, but an interesting trick.  If you look at the partitioning views in SQL you will find that if you create two tables that have all of...

Quest Software has a free schema / data comparison tool that makes a script that is SQL 2000 compatible.  So, if you compare a SQL 2005 database to a SQL...

This is a pretty open-ended post so you will probably find lots of answers coming at you soon.

One possibility is to use group by and the MAX aggregate.  Because any...

Just when you think it is impossible, Microsoft comes up with a new way to make the licensing more complicated.

I have been wrong in the past, but I do not think there is a way to get the report to not run immediately if there are defaults for all...