SQL Error Messages « SQL Server Journey with SQL Authority

Archive for the ‘SQL Error Messages’ Category

SQL SERVER – Installation Log Summary File Location – 2012 – 2008 R2

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on February 7, 2012 | 8 Comments »

Here is email received from user: “Pinal, I am new DBA in my organization and I have to manage SQL Server 2005, 2008 and 2008 R2. Today is my first day at job and my manager has asked me to install all these different edition on our test environment. I have finished installing them. Later [...]

Read Full Post »

SQL SERVER – ERROR: FIX – Database diagram support objects cannot be installed because this database does not have a valid owner

Posted in PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL on February 6, 2012 | Leave a Comment »

Recently one of my friend sent me email that he is having some problem with his very small database. We talked for few minutes and we agreed that to further investigation I will need access to the whole database. As the database was very big he dropped it in common location (you can use livemesh [...]

Read Full Post »

SQLAuthority News – To Err is Human; to Forgive, Divine – Errata of SQL Server Interview Book

Posted in About Me, Pinal Dave, PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, SQLAuthority Book Review, SQLServer, T SQL, Technology on January 4, 2012 | 1 Comment »

Regular readers of my blog will know that I have written three books this year. We are currently reviewing readers comments about SQL Server Interview Questions and Answers. I am sorry to announce that we made a mistake but happy to add that we have corrected it. We will pay closer attention to the error [...]

Read Full Post »

SQL SERVER – Fix: Error: 15138 – The database principal owns a schema in the database, and cannot be dropped

Posted in PostADay, SQL, SQL Authority, SQL Error Messages, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology on December 26, 2011 | 4 Comments »

Last day I had excellent fun asking puzzle on SQL Server Login SQL SERVER – Merry Christmas and Happy Holidays – Database Properties – Number of Users. One of the user sent me email asking urgent question about how to resolve following error. Reader was trying to remove the login from database but every single time [...]

Read Full Post »

SQL SERVER – FIX – ERROR : Msg 3201, Level 16 Cannot open backup device.Operating system error 3 (The system cannot find the path specified.)

Posted in Pinal Dave, PostADay, SQL, SQL Authority, SQL Backup and Restore, SQL Error Messages, SQL Query, SQL Server, SQL Server Management Studio, SQL Tips and Tricks, T SQL, Technology on December 17, 2011 | 7 Comments »

I had very interesting and frustrating experience. Recently I was attempting to backup one of my database and I end up on following error. Msg 3201, Level 16, State 1, Line 1 Cannot open backup device ‘D:\Backup\SQLAuthority.bak’. Operating system error 3(The system cannot find the path specified.). Msg 3013, Level 16, State 1, Line 1 [...]

Read Full Post »

Older Posts »