SQL Server 2008 R2, Daily Programming Issue

Database, SQL Server 2008 R2

List down all the database name in your server

Query: EXEC sp_databases Execute on master database

Mos
December 9, 2012

SQL Server 2008 R2

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…

Mos
January 30, 2012