No that does not work either as sp_executesql executes with the permissions of the user not the permissions of the compiler.

Regards

Ok I have added the following to my attach Stored procedure.

@param1 is the database name and sectest is the user I am playing with.

declare @nText Nvarchar(1024)

select @nText = N'use '...

Their clients send them thousands of databases every year for analysis.

The business is Re-Insurance and the databases are thier clients portfolio's

We do not own any of the software so we...