All Articles - SQL Authority with Pinal Dave

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

December 28, 2008

SQL Error Messages, SQL Scripts, SQL Server Security

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…

SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles

December 27, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server, SQL Server Security

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

December 26, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Security

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…

SQLAuthority Author Visit – Valsad, Daman, Silvassa, Vapi – Tech Meetings

December 25, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

SQL User Group, SQLAuthority Author Visit

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…

SQLAuthority News – Merry Christmas – Search SQLAuthority

December 25, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

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…

SQL SERVER – DISABLE and ENABLE user SA

December 24, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL Server Security

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…

SQL SERVER – 2008 – Download Copy of Developer Edition for Free Is Myth

December 23, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, SQL Download

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…

SQL SERVER – Find Next Running Time of Scheduled Job Using T-SQL

December 22, 2008

Pinal Dave

SQL Tips and Tricks

SQL Scripts, SQL Server, SQL Server Agent

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

December 21, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks, SQLAuthority News

Database, SQL Download

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…

SQL SERVER – Change Collation of Database Column – T-SQL Script

December 20, 2008

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Collation, SQL Scripts, SQL Server Security, SQL Utility

Just a day before I wrote about SQL SERVER – Find Collation of Database and Table Column Using T-SQL and I have received some good comments and one particular question was about how to change collation of database. It is quite simple do so. Let us see following example. USE…