Enable Agent XPS using T SQL

EXEC sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO

EXEC SP_CONFIGURE 'Agent XPs', 1;
GO
RECONFIGURE;
GO

 

Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Latin1_General_CI_AS" in the equal to operation

How to change SQL Server to Mixed Mode Authentication using t sql

EXEC xp_instance_regwrite

    N'HKEY_LOCAL_MACHINE'

    , N'Software\Microsoft\MSSQLServer\MSSQLServer'

    , N'LoginMode'

    , REG_DWORD, 2

go

restart sql server

How to Get DATABASE OUT OF SUSPECT MODE MS SQL SERVER

ALTER DATABASE DBName  SET  EMERGENCY
 
DBCC CHECKDB('DBName')
 
ALTER DATABASE DBName SET SINGLE_USER WITH ROLLBACK IMMEDIATE
 
DBCC CHECKDB('DBName', REPAIR_ALLOW_DATA_LOSS)
 
ALTER DATABASE DBName SET MULTI_USER

Error message “Explorer.exe - No such interface supported” in Windows 7

1. Click Start. In the Search box, type CMD. At the top of the window, right-click the cmd icon and choose Run as Administrator.
2. At the prompt, type in FOR /R C:\ %G IN (*.dll) DO "%systemroot%\system32\regsvr32.exe" /s "%G" and press.

This will take several minutes to complete. There will be several C+ Runtime errors that will appear, as well as the system slowing down. Once complete, restart the system and test.