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
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…
Read MoreSQL SERVER – How to Rename Database Objects to Comply With Naming Conventions
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…
Read MoreSQLAuthority News – Write for SQLAuthority
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…
Read MoreSQL SERVER – Find Table in Every Database of SQL Server – Part 2
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…
Read More
SQL SERVER – Find Table in Every Database of SQL Server
Just a day ago, one of the Jr. Developer requested that if I can help her with finding one particular table in every database on SQL Server. We have many Database Server and on some of the Database Server we have nearly 200 databases on it. The requirement was to…
Read MoreSQL SERVER – Download FAQ Sheet – SQL Server in One Page
One of the most popular request I have received on this blog is to create one page which list all the SQL Server FAQs. SQL Server technology is very broad as well very deep. This is my humble attempt to list few of the daily used details in one page.…
Read More