Hi

sorry for the delay in getting back, but been away on business...

thanks for the pointers, but nothing works?

when i run these scripts i get the error that the database is in use.

this database was a sql 2005 database that i was updating from another server.

any further ideas of how i get round this?

thanks in advance....