We are currently building out a new beast box to upgrade our primary database server.

Replacing a 4 Way IA-2 + 56GB ram with a 4x X7550 (32 cores / 64...

You will only be able to see name of the package in the dtsrun commands, for job steps if they were created unencrypted.

If you see something like DTSRun /~Z0xAEB6B4553DB09E5771B56FD6C06B30B37..........

Personally I used SSIS to generate an if exists drop, pull out the text from sys.syscomments, and write it all out to text files. We scripted out > 2000...

Lets here it for the DBAs who dont use sp_who2...!  I agree with the tricky wording comments.

Try this - I use this to trim the time out of series of datetime fields to group by date only:

cast(substring(cast(Loaddate as binary(8)),1,4) + 0x00000000 as datetime)

set nocount on

set statistics...

Check out the script I submitted: "Compare Parallel Data Streams". It is designed to find the diferences between two parallel data streams, i.e. QA and production to verify...