Yup. You can also go from florida to antartica then to the north pole and back to Fort Lauderdale to get some milk.

Or you can save the file on...

Select Name from [DbName.]dbo.SysObjects where XType = 'U' order by Name

Is there any change in the execution plan?

You have to make some sort of audit tool that takes snapshots of the sysobjects table and extract that info yourself. There's no history kept for the objects.

Here's my choice in order (for any operation, not just delete).

Exists and join (test each to see the fastest for that query)

in.

You do what you want with that. But...

I'll show you how.. but DON'T DO THIS IN PRODUCTION DATABASE

Declare @sql as varchar(8000)

set @sql = 'Select col1, col2 into dbo.' + @tblName + ' from dbo.YourTable ...'

exec...

Vote won't change.. I know you too well.

Those views are special. They are located in master, but they can be queried from any database whitout specifying the dbname.

Ex :

use pubs

select * from information_schema.tables

use northwind

select *...

I think I'd still take a day or two to really consider the real upgrade. You can use wizards to ship the data on the server then you could...

If you want to compare results, I assume that you need to compare results for different queries on the same table so I'd just use query analyser for this and...

My vote goes to : "Liar Liar pants on fire".

Correcting my post... You have to be in the db to grant permissions in it.

I vote for exists .

Can you post the image on the net.. we can't see squat if it's on your HD.

Also what is that message supposed to mean?

Those views are only located in master, but they can be queried from any database :

grant select on master.information_schema.tables to [a_db_user]