Books on line: Installing SQL Server / Upgrading Databases from SQL Server 6.5

use upgrade wizard, ...\MSSQL\upgrade\upgrade.exe

As it has been said: History should be managed with different table or you could consider using different dbms product that has a native support for multiversion data.

with sql:

SELECT * INTO XLSImport1 FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0',

'Excel 8.0;Database=C:\xltest.xls', 'SELECT * FROM [Sheet1$]')

I am not sure what you are trying to do but...

During the trigger execution sql server creates temporary tables named inserted & deleted (first for insert & update trigger, sec....