SQL Server 2000 Reporting Services Service Pack 2 in now available http://www.microsoft.com/downloads/
Author Archives: WARDY IT Solutions
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.
If you are looking to get a head start on SQL Server 2005 then the SQL Server 2005 Get Ready Webcast series will help bring you up to speed.
If you are looking to try SQL Server 2005 and do not have a spare computer and do not want to install Virtual PC then the SQL Server 2005 Virtual Labs are for you.