SQL Error Messages Archives - Page 82 of 114 - SQL Authority with Pinal Dave

SQL SERVER – Evaluation Period Has Expired – How to Activate SQL Server?

June 22, 2015

Sometimes we are in a hurry that we forget activities that are pending. A typical example would be like walking into a room and we keep thinking about why we were there in the first place. Isn’t that common? Or I think age is catching on me for sure. Some…

SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1

June 15, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

MySQL, SQL Error Messages

I have been monitoring some of the error messages that SQL Server has been throwing in the recent versions and they are self-explanatory. If we understand the English, then half the problem is solved. It becomes easier and quicker for an administrator if they ever encounter such errors. This blog…

SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG

June 13, 2015

Pinal Dave

SQL

SQL Error Messages, SQL Log, SQL Server, SQL Server Security

Errors related to logins are one of the most searched in this blog. Many of the blogs that talk about these errors are the ones that get viewed often too. This is one of the interesting errors, which you might see in your environments. One of my blog reader contacted me and told that their event log and ERRORLOG is full of below the messages:

SQL SERVER – FIX: Msg 3102, Level 16, State 1 – RESTORE cannot process database ‘Name’ because it is in use by this session

June 6, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Some of the simple learnings can come from unexpected places and this blog post is a classic example to that statement. Recently I got an email from one of my readers about the below error message: Msg 3102, Level 16, State 1, Line 2 RESTORE cannot process database 'DBProductDevelopment' because…

SQL SERVER – FIX – Error 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use

June 5, 2015

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server

We learn from mistakes and we improvise with experience. I couldn’t think of a better example than the one below for this. I have been watching many sessions by various speakers and found that many times they have struggled to get rid of Error 3702.

SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server

June 2, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SPARSE Columns, SQL Error Messages

I make a visit to the local user group whenever I get and keeping the community juices up and running for me. I get an opportunity to share some of the learnings and meet tons of new people. In our recent meetup at the SQLBangalore UG, I met a lot…

SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)

June 1, 2015

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

As I always say, Errors are a great source of learning and I am fortunate to have you as my readers. Because one of my blog reader reported an interesting issue which is worth blogging. This is his initial email: Hi Pinal, Your blogs have been very helpful to me…