Yes, COLUMN ORDER DOES MATTER in some data layer tier applications. They look to the first column being the primary key and if an ID column was added at the...

I think you are misunderstanding what he is saying. He is saying, he can not SEE the msdb folder after connecting to the SSIS vis management studio.

I do have...

Can I set up a SQL Server 2008 principal to a 2005 mirror? Maybe run the 2008 in backwards compatibility?

Thoughts anyone?

Automate this stuff.... why manually look... but do not have you database server watch itself. That is like an internal investigation. Not much checks and balances there.

You need...

hmmm... I personally hate table variables because they cause the disk queue length (I/O) and CPU to shoot through the roof. They only work on simple small systems with...