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 MoreSQL SERVER – 2008 – Download Copy of Developer Edition for Free Is Myth
It is quite common myth that SQL Server 2008 Developer Edition is FREE. SQL Server 2008 developer edition has same code base and same features which are available in SQL Server 2008 enterprise edition. Only difference between them is licensing terms. Developer Edition can not be used in production environment…
Read More
SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL
I often receive a good question on the blog, however, I do not always receive a good answer for the questions. Recently someone asked on a blog about Finding next run time for Schedule Job using T-SQL. My friend came up with a nice script. I have modified it a bit to adjust needs. This blog post is about finding the next running time of scheduled job using T-SQL.Â
SQLAuthority News – SQL Server Related Downloads from Microsoft
Feature Pack for SQL Server 2005 December 2008 Download the December 2008 Feature Pack for Microsoft SQL Server 2005, a collection of standalone install packages that provide additional value for SQL Server 2005. Microsoft SQL Server Protocol Documentation The Microsoft SQL Server protocol documentation provides technical specifications for Microsoft proprietary…
Read More