The VBScript code snippet below uses SQLDMO to read the EventInfo column from DBCC INPUTBUFFER for a specified SPID:
Monthly Archives: November 2005
I have finally had an opportunity this morning to re-build my laptop with the RTM of Visual Studio 2005 and SQL Server 2005.
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/
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
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.
Microsoft SQL Server Management Studio Express provides a graphical management tool for SQL Server 2005 Express Edition (SQL Server Express) instances.
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:
The example below shows a workaround for a Divide by zero error encountered. error by using the NULLIF Function.
The October edition of the WARDY IT SQL Server Newsletter has been e-mailed to everyone on the distribution list.
The Date for Monday and Friday of the current week can be determined as illustrated below.
SELECT GETDATE() + (2 – DATEPART(WEEKDAY, GETDATE())) AS MONDAY,
- 1
- 2