That is correct. But like Frank asked, what is your goal?

Split your tabels then load the old data values first for the base info. Then take the pay and run each item set and populate into the new table for...

This is because the largest daterange date SQL can handle is 12/31/9999. But when you add the time in it can only reach :998 which will float to :997, when...

Did you test the package on the machine the job is executing it from?

Are there any other processes running on the box to collect these backups to another location? Do you have any other maintainece jobs that might be interfering? The fact it...

No definently will be a job for DTS or a cutom application to read the contents of the remote page.

Don't know for sure. I usually just test a few options to see which gives best performance for the data in question, just make sure you run several times for...

It depedns on the size of your data. You cannot deffer the index updates in any way. You could however drop the indexes (non-clustered first then clustered as drop the...

Just for the sake of another option

where right(convert(char(8),mytable.datefield,112),4) = right(convert(char(8),getdate(),112),4)

If the name changes then it is a search and replace. You might go thru on your first build and create template tags for variable replacement to make this simpler.

But GUIDs are alphanumeric. The key for speed is the fixed length and size of data. Ultimately they are compared at the binary level.

Other than space in master to track their location it only matters if these Databases will not be needed for long with long times between use and are not set...

That is actually found in the sysobjects table like so.

select object_name(o.parent_obj) [Parent Name], o.[name] [Index_Name], o.xtype Type, o.* from sysobjects o

where o.xtype in ('PK','UQ')

Using the Export Wizard. Right click on a particular DB and under All Tasks you will find it.

I tried that and it didn't work. DId you test?