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.
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.
Itzik Ben-Gan from Solid Quality Learning is in Australia promoting the launch of Solid Quality Learning’s training services in Australia.
Microsoft has found an issue with the final build of SQL Server 2000 SP4 that impacts customers who are running SQL Server 2000.
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.
SQL Junkies has a interesting article by Rob Garrison regarding the performance difference between a script run on SQL Server 2000 and 2005.
SQL Server Service Pack 4 has been released and can be downloaded from http://www.microsoft.com/sql/downloads/2000/sp4.asp
The SQL Server CLR Team have begun a Blog which can be found at http://blogs.msdn.com/sqlclr/default.aspx
The T-SQL code snippet belows returns details regarding the Operating System using the NETSH utility.