Microsoft Certification are very important for any developer’s career. I personally have acquired MS certification before and while practicing for MS Certification I learned a lot personally. Developers who are interesting in upgrading themselves with Microsoft Certification must download certification path PDF.
SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
I got following error when I was trying to delete user ‘test’ with ‘SA’ login. I was little surprised but then I tried to delete with the windows authenticated systemadmin account. Once again I got the same error. Msg 15151, Level 16, State 1, Line 3 Cannot drop the login…
Read More
SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles
The reason I like blogging is follow up questions. I have wrote following two articles earlier this week. I just received question based on both of them. Before I go on questions, I recommend to read both of the article first. Both of them are very small article so they are quick to read.
SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not have permission
Few days ago, I have wrote about SQL SERVER – DISABLE and ENABLE user SA I received following email from one of the user who received following error. Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not…
Read MoreSQLAuthority Author Visit – Valsad, Daman, Silvassa, Vapi – Tech Meetings
I am currently traveling to South Gujarat doing Tech Meetings with leading organizations. Following is my tour schedule. Valsad – December 25, 2008 Daman – December 26, 2008 Silvassa – December 27, 2008 Vapi – December 28, 2008 I will be visiting some of the local IT industries and User…
Read MoreSQLAuthority News – Merry Christmas – Search SQLAuthority
Merry Christmas and a prosperous New Year. Thanks for the love and support you give me. I pray to the god that recession will be over soon around the world and everybody is happy. I have been receiving increasing emails for asking question about where is the Search on SQLAuthority.com…
Read MoreSQL SERVER – DISABLE and ENABLE user SA
Just a day ago, I received question from blog reader Mike McDonald. “How can I modify permissions for SA user? I tried to modify dbo users permission but now I am having problems.” First of all, there may be no relation between dbo user and SA user. They are different…
Read More