That's all well and good, however, by replacing DTS with SSIS Microsoft destroyed the most important feature of any database; the ability to quickly and easily get data into and...

Importing / Exporting data, especially to / from text files, was vastly superior in SQL Server 2000. Since this is probably 90% of what I use DTS packages for, I...

The following undocumented command will do the trick.

DBCC log ( {dbid|dbname}, [, type={0|1|2|3|4}] )

PARAMETERS:

Dbid or dbname - Enter either the dbid or the name of...