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

SQL SERVER – Create Database Error in Windows Vista

May 7, 2008

I recently receive question from one of the blog reader that he is having problem creating database in Windows Vista. Read original comment here. I have installed vista ultimate and sql server 2005 developer edition in my computer.I also connect SQL 2005 in window authentication but when I CREATE any…

SQL SERVER 2005 – FIX Error: 18456 : VISTA Windows Authentication

May 6, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Server Security, Vista

In previous post I have mentioned about SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition. There was one simple issue with the installation. I was not able to login using windows authentication method. I was able to successful login using sa username and password. I kept…

SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use – Part 2

March 13, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Scripts

Following error is very generic error and I have previously written SQL SERVER – FIX : Error : 3702 Cannot drop database because it is currently in use. Msg 3702, Level 16, State 3, Line 2 Cannot drop database “DataBaseName” because it is currently in use. One of the reader…

SQL SERVER – 2005 – A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold

March 4, 2008

Pinal Dave

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

SQL Error Messages, SQL Index, SQL Scripts, SQL Server DBCC

Just a day ago, I received email from regular reader Rajiv Kayasthy about a script which demonstrates the A Simple Way To Defragment All Indexes In A Database That Is Fragmented Above A Declared Threshold. He found this script on TechNet BOL and was attempting to run on SQL Server…

SQL SERVER – How to Retrieve TOP and BOTTOM Rows Together using T-SQL

March 2, 2008

Pinal Dave

SQL Tips and Tricks

SQL Error Messages, SQL Function, SQL Joins, SQL Scripts, SQL Server

Just a day ago, while working with some inventory related projects, I faced one interesting situation. I had to find TOP 1 and BOTTOM 1 record together. I right away that I should just do UNION but then I realize that UNION will not work as it will only accept one ORDER BY clause. If you specify more than one ORDER BY clause. It will give an error. Let us see how we can retrieve top and bottom rows together.

SQL SERVER – Dynamic Case Statement – FIX : ERROR 156 : Incorrect syntax near the keyword

February 28, 2008

Pinal Dave

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

SQL Error Messages, SQL Scripts

One of my friend sent me query asking me how to generate dynamic case statements in SQL. Every time he tries to run following query he is getting Error 156 : Incorrect syntax near the keyword. He was frustrated with following two queries. There are two different ways to solve…

SQL SERVER – 2005 – FIX: Error message when you run a query against a table that does not have a clustered index in SQL Server 2005: “A severe error occurred on the current command”

February 19, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Index

In SQL Server 2005 while testing Indexes I had created a table with one non clustered index only. I did not create any clustered index on table. After that I ran SELECT statement, it gave me following error. I was very surprised when I looked at error. It says Msg…