Get data from multiple databases into single store procedure

Question

I want count the users of three databases into a single store procedure?How it possible?

Midhun T P · Answer

Hi You can try like below - SELECT * FROM DB1 . dbo . MyTable UNION ALL SELECT * FROM DB2 . dbo . MyTable

Ananth G · Answer

SELECT * FROM [MyDatabaseOnDB1].[dbo].[MyTable]tab1 INNER JOIN [DB2].[MyDatabaseOnDB2].[dbo].[MyOtherTable]tab2 ON tab1.ID=tab2.ID U can use like this

Manas Mohapatra · Answer

Try like below: SELECT DB_NAME(dbid) as DBName COUNT (dbid) as NumberOfConnections loginame as LoginName FROM sys.sysprocesses WHERE dbid > 0 GROUP BY dbid loginame Note: If you want Database specific then add filter in where condition.