Yes EXEC sp_attach_single_file_db and sp_attach_db .Quite useful

Can you post the text of the error message when you try this ?

Oops sorry - too fast with the Enter ! EXEC sp_attach_single_file_db @dbname = 'dbname', and in sql 200 you'll get an error like Device activation error. The physical file name...

Both of these work

Hi

Thanks for your help . I'll be patient and break it down as you suggest.

Hi

I've run this but ECHO %DBNAME% just returns

%DBNAME%.

Can you help?

Thanks

Thank you very much McCork . I'll have fun

with this ! I'll let you know how I get on