All Articles - SQL Authority with Pinal Dave

SQL SERVER – FIX : Error 7311 – You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server or to a linked SQL Server 7.0 server

May 9, 2008

Following email is received from SQL Server Expert Roy Cheung. He faced issue of creating and running distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server. He has found solution and would like to share with SQLAuthority Blog Readers. Hi Pinal, Recently,…

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database – Part 2

May 8, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL System Table

What I love most about this blog is active readers participation. If readers are becoming contributor is the true success for any blog or online community. Recently many readers have contributed their suggestions and script to this blog. Joffery has provided nice script which is modification to previous article of…

SQL SERVER – Create Database Error in Windows Vista

May 7, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Error Messages, SQL Utility, Vista

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 – Find Table in Every Database of SQL Server – Part 2 Extension

May 5, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, undocumented SQL

Long time blog reader and SQL Server Expert Simon Worth has suggested two additional method to achieve same results as described in article SQL SERVER – Find Table in Every Database of SQL Server. Method 1 sp_msforeachdb "SELECT '?' DatabaseName, Name FROM ?.sys.Tables WHERE Name LIKE '%address%'" Method 2 CREATE…

SQL SERVER – 2000 – SQL SERVER – Delete Duplicate Records – Rows – Readers Contribution

May 4, 2008

Pinal Dave

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

SQL Joins, SQL Scripts, SQL Server

I am proud on readers of this blog. One of the reader asked asked question on article SQL SERVER – Delete Duplicate Records – Rows and another reader followed up with nice quick answer. Let us read them both together.

SQL SERVER 2005 – Vista Ultimate and SQL Server 2005 DEV Edition

May 3, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

Database, Software Development, Vista

I have been asked many times before “Does SQL Server Dev edition can be installed on Vista operating system?” I decided to find out the answer of this myself. I have just got new system which has Vista Ultimate Installed on it. I installed SQL Server 2005 dev edition on…

SQL SERVER – How to Rename Database Objects to Comply With Naming Conventions

May 2, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure

Christopher Miller read article of SQL SERVER Database Coding Standards and Guidelines Complete List Download and came up with wonderful SQL Server Script to rename all their database constraint with more organized constraint names, which helps to easily identify the constraint database exist on. Christopher Miller – “When we submit…

SQLAuthority News – Write for SQLAuthority

May 1, 2008

Pinal Dave

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

Database, DBA, Software Development

I always enjoy writing for my readers. Many times, I receive very good note, comments or article from my great experts of SQL Server. I really enjoy learning from my reader. If you are reader of SQLAuthority and you think you have knowledge, script or concept which benefit other readers…

SQL SERVER – Find Table in Every Database of SQL Server – Part 2

April 30, 2008

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Scripts, SQL System Table

Yesterday I wrote about SQL SERVER – Find Table in Every Database of SQL Server. Today we will see another method how we can achieve the same result using Information_Schema view. Refer my previous article here for additional information. CREATE PROCEDURE usp_FindTableNameInAllDatabase @TableName VARCHAR(256) AS DECLARE @DBName VARCHAR(256) DECLARE @varSQL…