Make SQL Server database read only except for one stored procedure -
i have stored procedure migrate data database another. exclude error, want make database read every transaction except mine. use sqlconnection , sqlcommand run script. there way this?
set database single-user mode
. when put in single-user mode, have connection available. long don't relinquish connection, no 1 else can connect.
be warned, close existing connections other users. prevent other connections being made.
more information: https://msdn.microsoft.com/en-us/library/ms345598.aspx
Comments
Post a Comment