Get random color code generation using sql server

 SELECT CONCAT(RIGHT(CONVERT(VARCHAR(100),CAST((ABS(CHECKSUM(NEWID()) % 135) + 120) AS VARBINARY),2),2),RIGHT(CONVERT(VARCHAR(100),CAST((ABS...

Read More

How find out number of active SQL Server connections?

  SELECT      DB_NAME ( dbid )   as  DBName ,      COUNT ( dbid )   as  NumberOfConnections ,     loginame  as  LoginName  FROM   sys . sysp...

Read More