April 2005 - Posts

• O/S Configurations from SQL Server

  The T-SQL code snippet belows returns details regarding the Operating System using the NETSH utility. The details returned range from the Windows Directory to the Service Pack Version and everything in between. CREATE TABLE #os ( token NVARCHAR(100) NULL Read More... Posted Wednesday, April 27, 2005 3:24 PM by admin | (Comments Off)

• SQLDMO to List SQL Server Configs

  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: Dim oSQLServer Dim cv Set oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.LoginSecure Read More... Posted Wednesday, April 27, 2005 10:00 AM by admin | (Comments Off)

• April SQL Server Newsletter

  The April 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/apr2005.htm . To subscribe to Read More... Posted Wednesday, April 27, 2005 8:07 AM by admin | (Comments Off)

• Reporting Services SP2 now Available

  SQL Server 2000 Reporting Services Service Pack 2 in now available http://www.microsoft.com/downloads/details.aspx?FamilyId=502C0D89-1308-4662-8F58-CEC55EF1235B&displaylang=en Read More... Posted Saturday, April 23, 2005 7:29 PM by admin | (Comments Off)

• SQL Server 2005 April CTP

  The SQL Server 2005 April CTP is now available for download for MSDN Subscribers. Read More... Posted Tuesday, April 19, 2005 1:30 PM by admin | (Comments Off)

• Determine the Members of Each ServerRole

  The VBScript extract below will determine the members of each SQL Server ServerRole for a list of servers provided in an input file. Option Explicit ' File containing list of servers to check Const SERVER_LIST = "c:\serverlist.txt" ' File to write the Read More... Posted Monday, April 18, 2005 2:23 PM by admin | (Comments Off)

• SQL Server 2005 April CTP on its way

  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. http://blogs.msdn.com/bowerm/archive/2005/04/15/408450.asp Read More... Posted Sunday, April 17, 2005 12:50 PM by admin | (Comments Off)

• Password Prompt When Changing Standard SQL Server Login

  Something that I have identified recently at several sites is clients being prompted for password confirmation after changing a standard SQL Server login. This has been identified as a bug and can be corrected with the fix in the following KB article Read More... Posted Wednesday, April 13, 2005 2:46 PM by admin | (Comments Off)

• Random Records from a Table

  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 s tatement may come in handy. SELECT TOP 10 * FROM northwind.dbo.orders ORDER BY NEWID() This query will return ten random records Read More... Posted Tuesday, April 12, 2005 10:38 PM by admin | (Comments Off)

• What Service Pack is That

  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 configuration function. ie. SELECT @@VERSION Retruns: Read More... Posted Monday, April 11, 2005 9:16 PM by admin | (Comments Off)

• SQL Server Migration Assistant (SSMA)

  Microsoft has recently announced their purchase of DBBest a leading provider of database migration tools. The DBBest tools will be incorporated into SQL Server Migration Assistant (SSMA) to allow for one-click conversion of all schema and data from Oracle Read More... Posted Sunday, April 10, 2005 6:54 PM by admin | (Comments Off)

• SQL Server 2005 Webcasts

  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. http://www.microsoft.com/events/series/technetsqlserver2005.mspx To download the On-Demand webcasts so you can Read More... Posted Wednesday, April 06, 2005 3:58 PM by admin | (Comments Off)

• SQL Server 2005 Virtual Labs

  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. The labs allow you to experience many of the new features in SQL Server 2005 including Read More... Posted Tuesday, April 05, 2005 10:13 AM by admin | (Comments Off)

• Display only Databases that a user has access to

  It has always been an issue that when there are multiple databases in an environment that all of the databases can be viewed in Enterprise Manager as well as in the Query Analyser Database selection. If a user knows a database exists then they tend to Read More... Posted Monday, April 04, 2005 3:43 PM by admin | (Comments Off)

• Welcome to the WARDY IT Solutions SQL Server Blog

  There has been continued interest in the monthly WARDY IT Solutions newsletters and one of the most common pieces of feedback has been for the newsletter to be published on a more frequent basis. Instead of doing this we have gone one step further and Read More... Posted Sunday, April 03, 2005 9:11 AM by admin | (Comments Off)