SQL Tips and Tricks Archives - Page 433 of 536 - SQL Authority with Pinal Dave

SQLAuthority News – Happy New Year – 5 SQL New Year Resolutions

January 1, 2009

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

Happy New Year to All of YOU! Let us start year 2009 with word of wisdom from Albert Einstein. I feel that you are justified in looking into the future with true assurance, because you have a mode of living in which we find the joy of life and the…

SQLAuthority News – Recap Year 2008 – Two Most Important Event of My Life

December 31, 2008

Pinal Dave

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

Database, MVP, Openday, Wedding

Year 2008 is about to complete in next few hours. It was one of the most interesting year for me in my life. There were so many things happened and fortunately all of them are good. If I have to list events special to me in year 2008 there can…

SQL SERVER – 2008 – Certification Path Complete Download PDF

December 29, 2008

Pinal Dave

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

Microsoft Certifications, SQL Download, SQL Server

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

December 28, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

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…