I was referring to SQL Server Backup, am sure others also meant SQL backups.

Detach / attach is quicker than backup / restore since it avoids the backup step and restore...

You need to use EXEC dbname.schema.Sprocname from your 1st database.

As already mentioned, take a FULL backup as a precautionary measure. Once you attach the files to SQL Server 2005, those files cannot be detached and attached back in SQL...

You are welcome!

If it is a different server you need to...

If both the databases are on the same server (SQL Instance) then use 3 part notation as

SELECT COL1,COL2,COL3 FROM LRB.dbo.Table

My guess is you should have them on each of the databases in that Server

These should help you..

http://www.sql-server-performance.com/articles/audit/ddl_triggers_p1.aspx

http://www.developer.com/db/article.php/3552096/Using-DDL-Triggers-to-Manage-SQL-Server-2005.htm

There migh be any kind of issue, it's hard to predict one..

Have you made sure, you are able to connect to the SQL 2000 Instance locally on the server? Just...

Thanks for that, even a wild guess is a better than no guess.

I shall try that when I return to work on Monday..

Thanks for your time.

Gift Peddie (4/2/2010)

You have two options create SSIS package and automate it so it runs for a long time to move your data, the other option is create an ADO.NET...

Hi thanks again for that.

I am using OLE DB Destination and I do not have table or fast load option for data access mode. The property you mentioned is only...

It does not do any transformations, all it does is to move these 40 odd Million records from one table in SQL Server to a table in Oracle. Since the...

SSIS

Still waiting for any expert opinions..

What do you mean the Full backup of a Database (which is 600 Gb) to be 100 GB..

It should normally not that low unless you are compressing the backup with...