By default the common language runtime (CLR) integration feature is turned off. If it is turned off, SQL server won’t be able to access the custom assemlies that are part of your database (if the database contains objects that are coded to use CLR integration). CLRmust be enabled in order to use objects that are […]
Category: MSSQL
Check SQL connections
Login to SQL Management Studio, select Master database and click on New Query and paste the below code : CREATE TABLE #sp_who2 (SPID INT, Status VARCHAR(1000) NULL, Login SYSNAME NULL, HostName SYSNAME NULL, BlkBy SYSNAME NULL, DBName SYSNAME NULL, Command VARCHAR(1000) NULL, CPUTime INT NULL, DiskIO INT […]