Software And Architecture

This shows the number of connections per each DB: SELECT DB_NAME(dbid) as DBName, COUNT(dbid) as NumberOfConnections, loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid, loginame And this gives the total: SELECT COUNT(dbid) as TotalConnections FROM sys.sysprocesses WHERE dbid > 0 If you need more detail, run: sp_who2 'Active'

In order to find a decimal number has fractional part in it,we can use the following check. decimal price=1.2334; if(price %1==0) // a whole number else // a fraction. A cute little piece of code that does the trick.