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

SQL SERVER – Fix Error 7202 Could not find server in sys.servers. Verify that the correct server name was specified

August 26, 2014

The other day I received following error when I tried to restore a database from one server to another server. Msg 7202, Level 11, State 2, Line 1 Could not find server ‘MyLinkedServer’ in sys.servers. Verify that the correct server name was specified. Well, this is quite a popular error…

SQL SERVER – Convert Old Syntax of RAISEERROR to THROW

August 16, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

I have been quite a few comments on my Facebook page and here is one of the questions which instantly caught my attention. “We have a legacy application and it has been a long time since we are using SQL Server. Recently we have upgraded to the latest version of…

SQL SERVER – Fix Error – Package ‘Microsoft SQL Management Studio Package’ failed to load in SQL Server Management Studio

June 21, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server Management Studio

I recently formatted my computer and reinstalled my machine and I end up on following error: Package ‘Microsoft SQL Management Studio Package’ failed to load I was able to fix the error quickly, but while I was searching online, I noticed quite a few of the people have similar error…

SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server

May 27, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts, SQL Server Agent

SQL Server Agent fails to start because of the error 15281 is a very common error. When you start to restart SQL Agent sometimes it will give following error. SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the…

SQL SERVER – Fix: Error: Compatibility Level Drop Down is Empty

May 23, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server

I currently have SQL Server 2012 and SQL Server 2014 both installed on the same machine. My job requires me to travel a lot and I like to travel light. Hence, I have only one computer with all the software installed on it. I can install Virtual Machines but as I was able to install SQL Server 2012 and SQL Server 2014 side by side, I just went ahead with that option. Now one day when I opened up my SQL Server 2014 and went to the properties of my database, I realized that the dropdown box for Compatibility level is empty.

Now one day when I opened up my SQL Server 2014 and went to the properties of the my database, I realized that the dropdown box for Compatibility level is empty.

SQL SERVER – Fix – Error 1759 Computed column in table is not allowed to be used in another computed-column definition

April 6, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

This is a very common error with beginning developers when they start working with computed columns. When a new developer finds a joy of computed column, it is very natural to use the same computed column for other columns. However, a computed column cannot be used in another computed column…

SQL SERVER – Error – Resolution – Could not allocate space for object in database because the filegroup is full

March 14, 2014

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages

Just a day ago on my local box I received following error. Could not allocate space for object ‘<object_name>’ in database ‘<database_name>’ because the ‘PRIMARY’ filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on…