How to get total number of open/active connections in MS SQL Server 2005? SELECT DB_NAME(dbid) as 'Database Name' , COUNT (dbid) as 'Total Connections' FROM master.dbo.sysprocesses WITH (nolock) WHERE dbid > 0 GROUP BY dbid SELECT @@MAX_CONNECTIONS AS 'Max Allowed Connections' This shows the no of...

Continue reading "Number of open/active connections in ms sql server 2005"

I found that the best free database contains data about countries, cities and languages is in MYSQL called World and you can download it from this URL Also I created a MS SQL script to create the db in sql server, and attached you will find the data in CSV files. USE [World] GO /****** Object: Table...

Continue reading "List of countries, cities, languages"