kumar.sachu08 (9/19/2010)
Other Person (Client) not give me permission to access own server for the security point of view.
No, I don't imagine he would.
he is self sql administrator. So, we can't do any such activity. we only give .bak file nothing more.
What I'm saying is if you want to completely control the SQL database, you must host the SQL server, put the SQL database on there and only let the client access it, not administer it.
Your server.
Your database.
If you can't do that, and are giving someone else the backup file, you are giving them complete and total control over that database.
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