Thanks

There is security as to which developer is allowed to do what (from which server he is allowed to copy and to where).

Still like 20 devs will be able to...

Yes, at the time I was bored with restoring databases for developers at my company and decided to create this app at home and learn some C# MVC. I am...

And how about this free open source tool :

https://github.com/TomaszM81/SandboxDatabaseManager

Alright did some testing this morning and here is what I have established:
The update stats on the inses does not work and ends with error claiming is is not...

Actually I got this working by changing the linked server option:

EXEC master.dbo.sp_serveroption @server=N'LOOPBACK', @optname=N'remote proc transaction promotion', @optvalue=N'false'

and using the "EXEC() at" syntax:

exec ('update top(1) db_name.schema.table

set col =...