This is one of the question asked by my friend and it seems very simple. I had a discussion with him and said that whatever the transaction it has started it will succeeded, however what I told him is not correct. I told him I’ll test it out and the answer which I gave it to him is partially correct. If the transaction gets completed with in begin tran (before commit or rollback) you can close the transaction even if the permission is revoked however if the transaction is not completed within begin tran then it will fail stating that the user don’t have access. Read more »
Category Archives: Security
Change \ Transfer Schema for all Objects
Posted by Vidhya Sagar
on December 21, 2009
No comments
In my working environment we will be using different schema for production and development environments. Our development apps are configured to Dev schema and Production apps are configured to Prod schema, so when we restore the db from production to development environment, all our dev apps stopped working since the objects \ securable will be using prod schema. Here I need to change the schema to dev from prod, so the syntax will be like below
IP Address Blocking or Restriction in SQL Server
Posted by Vidhya Sagar
on December 3, 2009
19 comments
I have seen some questions in forums asking for the answer “is it possible to block connections to SQL Server based on IP address”. As far as now there is no official way in SQL Server to block the connections in SQL Server based on IP address. However this can be done from the OS end, we have the following three options available, refer HERE for more.