October 2005 - Posts

• Suppress SQL Server Backup Messages

  Everytime a SQL Server Backup (or restore) is performed SQL Server writes a message both to the SQL Server Errorlog and the Windows Eventlog. In order to reduce the noice in these logs where there is a large number of databases the messages can be suppressed Read More... Posted Tuesday, October 25, 2005 4:29 PM by admin | (Comments Off)

• SQL Server Installation Path

  The installation path for SQL Server 2000 can be determined using the undocumented sp_msget_setup_paths Stored Procedure. This procedure performs a Reg Read for the particular SQL Server instance to determine the install path from HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\MSSQLServer\Setup Read More... Posted Thursday, October 13, 2005 2:23 PM by admin | (Comments Off)

• Audting a Table using a Trigger

  Below is an example of how to use a Trigger to audit who updated, deleted or inserted data. The trigger also captures the old an d new values when an update is performed: CREATE TABLE dbo.tblProducts ( ProductId INT IDENTITY(1, 1) CONSTRAINT PK_tblProducts Read More... Posted Tuesday, October 11, 2005 3:19 PM by admin | (Comments Off)

• September SQL Server Newsletter

  The September 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/sep2005.htm Read More... Posted Sunday, October 09, 2005 9:52 PM by admin | (Comments Off)