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....