May 2005 - Posts

• SQL Server 2000 Build Chart

  If you are ever trying to work out what hotfix a SQL Server 2000 build equates to, the Build Chart on the ASPFAQ web sit e will certainly come in very handy. Not only does it list all the build numbers and the related hotfix es but also provide d is a Read More... Posted Friday, May 27, 2005 1:04 AM by admin | (Comments Off)

• May SQL Server Newsletter

  The May edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list. For those not on the distribution list you can view the newsletter using the following URL http://www.wardyit.com/newsletters/may2005.htm . To Read More... Posted Friday, May 27, 2005 1:02 AM by admin | (Comments Off)

• Set SQL Server Login Mode

  Many of you may be aware that the Login Mode for SQL Server is stored in the Registry key HKLM\SOFTWARE\Microsoft\MSSQLServer\MSSQLServer (another good reason to ensure that the Registry is secured). Where 1 = Windows Only Authentication and 2 = SQL Server Read More... Posted Tuesday, May 24, 2005 4:58 PM by admin | (Comments Off)

• SQL Server SP4 and AWE - KB Article

  There was a post last week regarding a bug with SQL Server 2000 SP4 and not all memory being available when AWE is enabled. For those looking for the KB Article it is 899761 . Read More... Posted Tuesday, May 17, 2005 9:09 AM by admin | (Comments Off)

• Script Operators using SQLDMO

  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 to assist in migrating from one instance to another: Const SQLDMOScript_Drops = 1 Const SQLDMOScript_Default = 4 Const Read More... Posted Monday, May 16, 2005 1:33 PM by admin | (Comments Off)

• Read E-mail from Outlook Mail Profile

  Recently a client of ours had the need to run a DTS Package on a scheduled basis to read an Outlook Mail Profile and perform some transformations on the mail messages before inserting them into a SQL Server t able. Below is a VBScript code sample illistarting Read More... Posted Sunday, May 15, 2005 8:14 PM by admin | (Comments Off)

• Itzik Ben-Gan Australian Sessions

  For those in Australia who are not aware Itzik Ben-Gan from Solid Quality Learning is in Australia promoting the launch of Solid Quality Learning's trainingg services in Australia. If you are interested in attending any of Itzik's one day or User Group Read More... Posted Saturday, May 14, 2005 7:06 PM by admin | (Comments Off)

• SQL Server SP4 and AWE

  Microsoft has found an issue with the final build of SQL Server 2000 SP4 that impacts customers who are running SQL Server 2000 with Address Windowing Extensions (AWE) support enabled. If you are utilising this configuration, you should not install SP4 Read More... Posted Friday, May 13, 2005 9:46 AM by admin | (Comments Off)

• SQL Server and IT Whitepapers

  SQL Server Central has partnered with BitPipe and TechTarget to Provide access to a variety of IT white papers on every imaginable subject for free. To access this library go to http://itresearch.sqlservercentral.com/ Read More... Posted Thursday, May 12, 2005 6:23 PM by admin | (Comments Off)

• SQL Server 2005 Performance

  SQL Junkies has a interesting article by Rob Garrison regarding the performance difference between a script run on SQL Server 2000 and 2005 using identical hardware http://www.sqljunkies.com/Tutorial/077C7BEB-EB31-4A07-923D-BE309F59D0F8.scuk Read More... Posted Tuesday, May 10, 2005 7:05 PM by admin | (Comments Off)

• SQL Server 2000 SP4 Released

  SQL Server Service Pack 4 has been released and can be downloaded from http://www.microsoft.com/sql/downloads/2000/sp4.asp Read More... Posted Saturday, May 07, 2005 1:46 PM by admin | (Comments Off)

• SQL CLR Team Blog

  The SQL Server CLR Team have begun a Blog which can be found at http://blogs.msdn.com/sqlclr/default.aspx Read More... Posted Friday, May 06, 2005 7:27 PM by admin | (Comments Off)