November 2005 - Posts

• VBScript to Display DBCC INPUTBUFFER

  The VBScript code snippet below uses SQLDMO to read the EventInfo column from DBCC INPUTBUFFER for a specified SPID: ie. Read the EventInfo as illustrated below: DBCC INPUTBUFFER(53) EventType Parameters EventInfo -------------- ---------- ---------------------- Read More... Posted Friday, November 25, 2005 9:34 AM by admin | (Comments Off)

• SQL Server 2000 Reporting Services SP Version

  To identify which version of SQL Server 2000 Reporting Services you have installed, type the URL of the report server ie. http://ServerName/reportserver . The version information is located at the bottom of the ReportServer page: RTM: 8.00.743.00 SP1: Read More... Posted Sunday, November 20, 2005 9:54 PM by admin | (Comments Off)

• Reporting Services ASP.NET v1.1 Not Installed

  I have finally had an opportunity this morning to re-build my laptop with the RTM of Visual Studio 2005 and SQL Server 2005. One of the interesting things that I have found along the way when installing SQL Server 2000 Reporting Services, is during the Read More... Posted Sunday, November 20, 2005 11:13 AM by admin | (Comments Off)

• SQLDownUnder Archive

  If you are ever looking for a message that has been posted to the SQLDownUnder mailing list, then the complete archive can be found at http://www.stillhq.com/sqldownunder/archives/ . Read More... Posted Saturday, November 19, 2005 10:37 PM by admin | (Comments Off)

• New Database default locations

  In SQL Server 2000 there are two ways to identify the New Database default locations ie. where the data and log files are created when a database is created without specifying a filespec for the data or log file (CREATE DATABASE blah) . These values are Read More... Posted Thursday, November 10, 2005 1:00 PM by admin | (Comments Off)

• Brisbane Sharepoint User Group (BSPUG)

  The Brisbane Sharepoint User Group had their inaugural meeting Yesterday. The group plan to meet between 12:00-13:30 on the 2nd Wednesday of each month at the Brisbane Microsoft office (Level 9, Waterfront Place, 1 Eagle St, Brisbane). If you would like Read More... Posted Thursday, November 10, 2005 12:34 PM by admin | (Comments Off)

• Microsoft SQL Server Management Studio Express - November 2005 CTP

  Microsoft SQL Server Management Studio Express (SSMSE) provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances. SSMSE can also manage relational engine instances created by any edition of SQL Server 2005. Read More... Posted Tuesday, November 08, 2005 4:39 PM by admin | (Comments Off)

• Steve Ballmer Keynote

  For those that missed the Steve Ballmer Keynote for the release of SQL Server 2005, Visual Studio 2005, and BizTalk Server 2006 it can be viewed from the following link: http://www.microsoft.com/windowsserversystem/applicationplatform/launch2005/keynote.msp Read More... Posted Tuesday, November 08, 2005 4:35 PM by admin | (Comments Off)

• Divide by zero error encountered

  The example below shows a workaround for a Divide by zero error encountered. error by using the NULLIF Function. NULLIF returns the first expression if the two expressions are not equivalent otherwise a NULL is returned. Usage: SELECT NULLIF(col1, 0) Read More... Posted Thursday, November 03, 2005 11:50 AM by admin | (Comments Off)

• October SQL Server Newsletter

  The October 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/oct2005.htm Read More... Posted Thursday, November 03, 2005 11:36 AM by admin | (Comments Off)

• Date for Monday and Friday of Current Week

  The Date for Monday and Friday of the current week can be determined as illustrated below. SELECT GETDATE() + (2 - DATEPART(WEEKDAY, GETDATE())) AS MONDAY, GETDATE() + (6 - DATEPART(WEEKDAY, GETDATE())) AS FRIDAY This assumes that you consider t he first Read More... Posted Wednesday, November 02, 2005 1:25 PM by admin | (Comments Off)

• SQL Server 2005 RTM

  After a long wait the final build of SQL Server 2005 was released to manufacture (RTM) last Friday (28th October 2005). For those that are MSDN subscribers the final builds of the Developer, Enterprise, Express, Standard and Workgroup Editions are available Read More... Posted Tuesday, November 01, 2005 10:31 AM by admin | (Comments Off)