The Microsoft SQL Server 2005 Upgrade Advisor is a tool that can be used to analyze a SQL Server 7.0 or 2000 database servers.
Category Archives: SQL Server
If you have been unable to attend one of the Australian SQL Server User Group meetings, or are interested in one of the topics that have been presented
The following Microsoft Knowledge Base article describes the process to Shrink the SQL Server TEMPDB database
The following Knowledge Base article describes the process to manually uninstall SQL Server when ADD/Remove Programs will not uninstall SQL Server.
The June edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
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: