June 2005 - Posts

• Run a SQL Seript againt Multiple SQL Server Instances

  The VBScript below can be used to read a list of SQL Server instances from a text file and execute a SQL Script againt each of the instances: Const SERVERLIST = "c:\serverlist.txt" Const SCRIPT = "c:\errlog.sql" Const ForReading = 1 Dim sCmd Dim sLine Read More... Posted Thursday, June 30, 2005 8:30 PM by admin | (Comments Off)

• A DBA's Guide to SQLDMO

  WARDY IT Solutions will be presenting a course titled 'A DBA's Guide to SQLDMO' in Brisbane on the 31st September 2005. The course outline for this course can be found at http://www.wardyit.com/courses/ADBAsGuidetoSQLDMOCourseOutline.pdf . Read More... Posted Monday, June 13, 2005 1:29 PM by admin | (Comments Off)

• SQL Server 2005 June CTP

  The feature-complete SQL Server 2005 June CTP is the first prerelease version of SQL Server 2005 available to the public and is available for download at http://www.microsoft.com/sql/2005/productinfo/ctp.mspx Read More... Posted Sunday, June 12, 2005 3:56 PM by admin | (Comments Off)

• SQL Server 2005 Release Date

  The release date for SQL Server 2005 along with Visual Studio 2005 and BizTalk 2006 has been announced as 7th November: http://msdn.microsoft.com/launch2005/ Read More... Posted Wednesday, June 08, 2005 10:27 AM by admin | (Comments Off)

• Script to Enable SQL Server Auditing

  The following script can be executed to programmatically enable SQL Server Auditing: EXEC xp_instance_regwrite N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\MSSQLServer\MSSQLServer', N'AuditLevel', REG_DWORD, AuditLevel Where AuditLevel equals 0 = None Read More... Posted Tuesday, June 07, 2005 12:10 PM by admin | (Comments Off)

• Compare two Identical Tables

  The script below illistrates how to compare two tables that are indentical in order to verify if the values are really the same in both tables: USE NORTHWIND GO SELECT * INTO dbo.shippers_test FROM dbo.shippers UPDATE dbo.shippers_test SET companyname Read More... Posted Tuesday, June 07, 2005 12:03 AM by admin | (Comments Off)

• Tables Without a Primary Key

  The following TSQL script will identify all tables in a databases that do not have a Primary Key: EXEC sp_MSforeachtable 'SELECT CASE WHEN OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasPrimaryKey'') = 0 THEN ''?'' + '' - Missing PK'' ELSE ''?'' END' Read More... Posted Wednesday, June 01, 2005 9:57 PM by admin | (Comments Off)