Monthly Archives: June 2011

Moving to SQL-Articles.com

Posted by on June 22, 2011 No comments

After a long I have decided to move to SQL-Articles.com main website itself instead of having another blog for me. Main website is also owned by me however Sugesh, Deepak , Lexx will also be posting their article.  I posted my articles in SQL-Articles.com main website and also in this blog. Right now I decided not to duplicate my efforts in both the websites, so I planned to start posting my articles only in main website. You can subscribe to that RSS feed there which will also provide you the articles posted by my friends which will help you to learn much more. Read more »

VN:F [1.9.17_1161]
Rating: 3.0/5 (2 votes cast)
VN:F [1.9.17_1161]
Rating: +1 (from 3 votes)

What happens when permission is revoked in middle of work?

Posted by on June 15, 2011 2 comments

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 »

VN:F [1.9.17_1161]
Rating: 5.0/5 (1 vote cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)

What’s happening in Chennai this June?

Posted by on June 8, 2011 No comments

Does the title make you to think what’s gonna happen. It’s all related to technical so don’t go out of scope :-) . Coming 18th we have Community Tech days going to happen in Chennai. This time we have 5 sessions and all the 5 sessions are taken by Microsoft speakers itself. Read more »

VN:F [1.9.17_1161]
Rating: 0.0/5 (0 votes cast)
VN:F [1.9.17_1161]
Rating: 0 (from 0 votes)