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
Author Archives: WARDY IT Solutions
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
There was a post last week regarding a bug with SQL Server 2000 SP4 and not all memory being available when AWE is enabled.
Below is a VBScript code sample illustrating how to use SQLDMO to generate a SQL script of all of the operators on a SQL Server instance.