Thursday, April 28, 2011


After really spending two hours of time learned that impersonation will work only within same server and will not work across the servers.

Here is the guy neatly explained the scenario I went thru.

1 comment:

  1. Hey Thats exactly the same I tried explaining to you isn't it? By the way, that guy is a MGSI employee and you can meet him here in our campus only to learn more on this. Once you do that, please share your knowledge with me as well. I am also interested to know more about this.


Managing SQL Role

Recently, we had a scenario, where we need a simple SQL Role which gets read access to bunch of views.  While it was easy to create the vie...