DBCC DBREINDEX creates new indexes before dropping the old ones.  This is done as one atomic transaction, so a lot of free space may be required.

If it is rebuilding a...

SQL Server doesn't seem to mind orphaned users caused by restoring backups from one server to another server with different logins.  You could take advantage of this by creating a...

If you want to check a large number of packages, it may be worthwhile to use VB.NET with the DTSPackage Object Library.  Enumerate the packages on a server (or package...

"referencing the same table on both the source & destination sides"

As they say on http://www.thedailywtf.com, "My eyes!  The goggles, they do nothing!".  I guess I hadn't considered the possibility...

I realize that there are financial and physical constraints that make this difficult, but your first goal in configuring a SQL Server is to add all the memory in the...

The answer, as in many other cases, is "It depends.".  In general, if you can find a set-based way to do things in T-SQL it will probably the best approach.  On...

Download a free trial version of a monitoring tool like Quest's Spotlight on SQL Server.  It gives you a graphical interface for almost every performance metric you can imagine.  Whatever is...

Once you appreciate that end-of-line is no more significant in T-SQL than space or tab, using multiline string literals will seem a lot clearer than concatenating char(13) everywhere.  The color-coding tells...

When I run it the GO is on a separate line.  The last version you posted works, also.

Are you running this with results to grid or results to text?  It...

SELECT REPLACE(REPLACE('exec my_proc ''XX'',''YY''

','XX',NAME),'YY',LEFT(NAME,2)) + 'GO' FROM MASTER..SYSDATABASES WITH(NOLOCK)

WHERE DBID>5

Even if you don't have previous backups, backup what you have before proceeding.  You could also try to copy whatever you can get out of the the corrupt tables using...

If this is being generated by T-SQL you can use multiline strings.  The problem is that the GO command in a quoted string works just like GO anywhere else, it...

The "Warning: Null value is eliminated by an aggregate or other SET operation." message means you had an aggregate function such as SUM() or AVERAGE() on data that included a null value...

There appear to be several misconceptions in that post.

When you create a package configuration, the current property value is written.  If you later change that value in design mode, the...

The only thing I found related to timing was that if a property or variable was set more than once, the last setting would be in effect when the package...