Database

How to: Increment the Counter Registry Key for Setup in SQL Server 2005

click Start, click Run, type regedit.exe in Open, and then click OK. Navigate to the following registry key:[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Perflib] Right-click on the Counter key in 009 and select “Modfify” See the last counter number there. Reset the Last Counter key in Perflib to that number. Right-click on the Help key in 009 and select “Modfify” …

How to: Increment the Counter Registry Key for Setup in SQL Server 2005 Read More »

Consistency validation for SQL server registry keys

  Stop all SQL Server Services Remove all SQL Server Services Control Panel – Add/Remove Programs – Select and Remove all Microsoft SQL Server programs Open regedit and remove all SQL Server folders in this registry key: HKEY_LOCAL_MACHINE/ SOFTWARE/MICROSOFT Remove SQL Server folders from Program Files directory Reboot To remove all SQL server Service you …

Consistency validation for SQL server registry keys Read More »

Handling Database Engine Errors SQL Server 2008 R2

Database error contains an error number, message string, severity, state, and procedure name and line number.  Error can be handled in the database by adding error-handling code to translate-sql, batches, procedure, trigger or function. Each application use to access database, provide mechanisms for passing the error to application. Error Number Each error message has a …

Handling Database Engine Errors SQL Server 2008 R2 Read More »