kumar.sachu08 (9/19/2010)
That's why i am saying microsoft should be work for the same. Provide password facility on backup file, by which no one can execute any command when i set password. Only he can restore database in own SSMS.
If that was possible, how would the administrator be able to do maintenance (backups, index rebuilds, stats updates)?
Even if that were possible, an admin could still extract code from the database caches, use SQL Trace to see what's been run by the application and reset your application's password (or maybe even see what it is, depending how you create it) and gain access that way.
If you think it's such an essential feature, go tell Microsoft: http://connect.microsoft.com/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability