Close

disable

CLR – Check if enabled, enable it.. etc – SQL Server

“The common language runtime (CLR) integration feature is off by default, and must be enabled in order to use objects that are implemented using CLR integration. To enable CLR integration, use the clr enabled option of the sp_configure stored procedure in SQL Server Management Studio:” ¬†…. ¬†Microsoft Essential commands: –check SELECT * FROM sys.configurations WHERE […]

Read More

Windows Server 2008 R2 – Disable UAC

Steps to disable UAC on Windows Server 2008 R2. In some situations, UAC hinders full functionality of some SQL Server components such as SSIS 2008/2012/2014 Click on Start button Control Panel User Accounts Change UAC Settings Slide down to Never notify Select OK Select Yes Restart Computer/Server  

Read More