SQL SERVER – Download SQL Server 2005 Books Online (February 2007) | Journey to SQL Authority with Pinal Dave

Download an updated version of Books Online for Microsoft SQL Server 2005. Books Online is the primary documentation for SQL Server 2005. The February 2007 update to Books Online contains new material and fixes to documentation problems reported by customers after SQL Server 2005 was released. Refer to "New and Updated Books Online Topics" for… Continue Reading...

Source: SQL SERVER – Download SQL Server 2005 Books Online (February 2007) | Journey to SQL Authority with Pinal Dave

SQL SERVER – Restore Database Backup using SQL Script (T-SQL) | Journey to SQL Authority with Pinal Dave

Database YourDB has full backup YourBaackUpFile.bak. It can be restored using following two steps. Step 1: Retrive the Logical file name of the database from backup. RESTORE FILELISTONLY FROM DISK = 'D:BackUpYourBaackUpFile.bak' GO Step 2: Use the values in the LogicalName Column in following Step. ----Make Database to single user Mode ALTER DATABASE YourDB SET… Continue Reading...

Source: SQL SERVER – Restore Database Backup using SQL Script (T-SQL) | Journey to SQL Authority with Pinal Dave

SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005 | Journey to SQL Authority with Pinal Dave

I came across this interesting and detailed article 'What's New in SQL Server Agent for Microsoft SQL Server 2005' on Microsoft TechNet. This article describes Security Improvements, New Roles in the msdb Database, Multiple Proxy Accounts, Performance Improvements, Performance Counters, New SQL Server Agent Subsystems, Shared Schedules, WMI Event Alerts, SQL Server Agent Sessions, Database… Continue Reading...

Source: SQL SERVER – What is New in SQL Server Agent for Microsoft SQL Server 2005 | Journey to SQL Authority with Pinal Dave

SQL SERVER – T-SQL Script to find the CD key from Registry | Journey to SQL Authority with Pinal Dave

Here is the way to find SQL Server CD key, which was used to install it on machine. If user do not have permission on the SP, please login using SA username. Expended stored procedure xp_regread can read any registry values. I have used this XP to read CD_KEY. This is undocumented Stroed Procedure and… Continue Reading...

Source: SQL SERVER – T-SQL Script to find the CD key from Registry | Journey to SQL Authority with Pinal Dave

SQL SERVER – Delete Duplicate Records – Rows | Journey to SQL Authority with Pinal Dave

Following code is useful to delete duplicate records. The table must have identity column, which will be used to identify the duplicate records. Table in example is has ID as Identity Column and Columns which have duplicate data are DuplicateColumn1, DuplicateColumn2 and DuplicateColumn3. DELETE FROM MyTable WHERE ID NOT IN ( SELECT MAX(ID) FROM MyTable… Continue Reading...

Source: SQL SERVER – Delete Duplicate Records – Rows | Journey to SQL Authority with Pinal Dave

SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation | Journey to SQL Authority with Pinal Dave

When create or alter SQL object like Stored Procedure, User Defined Function in Query Analyzer, it is created with following SQL commands prefixed and suffixed. What are these - QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF? SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO--SQL PROCEDURE, SQL FUNCTIONS, SQL OBJECTGO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO… Continue Reading...

Source: SQL SERVER – QUOTED_IDENTIFIER ON/OFF and ANSI_NULL ON/OFF Explanation | Journey to SQL Authority with Pinal Dave

SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running | Journey to SQL Authority with Pinal Dave

To determine which version of SQL Server 2000/2005 is running, connect to SQL Server 2000/2005 by using Query Analyzer, and then run the following code: SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition') The results are: The product version (for example, 8.00.534). The product level (for example, "RTM" or "SP2"). The edition (for example, "Standard Edition"). For… Continue Reading...

Source: SQL SERVER – Script to Determine Which Version of SQL Server 2000-2005 is Running | Journey to SQL Authority with Pinal Dave