What you want to do looks to be similar to the first step SQL takes when creating a full-text index on a RTF document. When SQL builds a FT...

All your jobs are stored in msdb, so a backup of msdb will contain all your jobs.

As other people have said, it is a good idea to also have scripts...

Dio you have 8.3 filename creation disabled? SQL Server 2005 install requires that 8.3 filename creation is switched on, as the path names used to create the service entries...

SQL Server components are split across 2 install folders. The Server folder on the DVD (CD1 on CD media) contains only the server components. The Tools folder on...

SQL Server 2008 will support the same DTS Designer component as SQL Server 2005. There are some blog postings...

Windows compressed folders do not compress files over 2GB. What may be happening is that as you write the log backup, Windows is compressing the data. When the...

I think SSAS needs enough memory to hold all the dimemsions of all the cubes. Therefore the more cubes you have, the more memory you need.

Steve,

Sounds reasonable. Hopefully you can update the what is displayed on old postings to show the new name the person uses.

However, I think you should stay as 'Steve...

The critical time for synchronising backups is not the start time, not the end time, but the time in the middle when the actual full backup ends and the built-in...

As Steve said, some blocking is normal.

After you install SQL 2000 SP4, you may well see blocking happening when nothing was reported in SP3. The blocking is not anything...

We make extensive use of free text searching where I work. John is right, you need to construct a dynamic SQL query using the data supplied by the user....

As people have said, SSIS is the favoured tool for developing DTS-like functionality on SQL 2005 and onwards.

However, you can still use all the SQL 2000 functionality in SQL 2005,...

You simply cannot synchronise backups in this way. All it needs is a few milliseconds difference in the backup completion time and you have committed data on machine A...

If your main server is 64-bit and your DR server is 32-bit, then you should test that all your application code works in both environments.

Also test that the...

I gave the limit of 1 MB for the type of reasons given by Dave and Grant.

On small tables the optimiser will often find it is cheaper to...