The SQLDMO Script below will list all of the SQL Server configuration options and their config_value and run_value just as per the sp_configure Stored Procedure:

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

SQL Server 2000 Reporting Services Service Pack 2 in now available http://www.microsoft.com/downloads/

The SQL Server 2005 April CTP is now available for download for MSDN Subscribers.

The VBScript extract below will determine the members of each SQL Server ServerRole for a list of servers provided in an input file.

It looks like that the April CTP of SQL Server 2005 is very close. According to Mark Bower, a Microsoft consultant in the UK Visual Studio Beta 2 and SQL Server 2005 April CTP are being prepped for download.

Something that I have identified recently at several sites is clients being prompted for password confirmation after changing a standard SQL Server login.

If you have ever had the need to return random records from a table such a sample data for test cases then the following T-SQL statement may come in handy.

A commonly asked question is how to identify the SQL Server Service Pack that is installed. It is possible to identify what version is being run based on the build number returned from the @@VERSION

Microsoft has recently announced their purchase of DBBest a leading provider of database migration tools. The DBBest tools will be incorporated into SSMA.