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:

WARDY IT Solutions will be presenting a course titled ‘A DBA’s Guide to SQLDMO’ in Brisbane on the 31st September 2005.

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

The release date for SQL Server 2005 along with Visual Studio 2005 and BizTalk 2006 has been announced as 7th November.

The following script can be executed to programmatically enable SQL Server Auditing:

Learn how to use a script to compare two tables that are identical in order to verify if the values are really the same in both tables.

Here’s an example of how a TSQL script will identify all tables in a databases that do not have a Primary Key.

If you are ever trying to work out what hotfix a SQL Server 2000 build equates to, the Build Chart on the ASPFAQ website will certainly come in very handy.

The May edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.

Many of you may be aware that the Login Mode for SQL Server is stored in the Registry key HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer