Allow a connection to be specified as "READ ONLY". This would disable functionality akin to TOAD for Oracle's READ ONLY mode.
You may have to do that directly into the SQL Server Management system.
msdn.microsoft.com/.../bb522682.aspx
Toad is just a client to that system.