SQL Server: Connection_Check

 USE [dbatoolbox]

GO

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[Connections_Full](

[server] [nvarchar](130) NOT NULL,

[name] [nvarchar](130) NOT NULL,

[login_time] [datetime] NOT NULL,

[last_batch] [datetime] NOT NULL,

[timestamp] [datetime] NOT NULL,

[status] [nvarchar](30) NOT NULL,

[hostname] [nvarchar](130) NOT NULL,

[program_name] [nvarchar](130) NOT NULL,

[nt_username] [nvarchar](130) NOT NULL,

[loginame] [nvarchar](130) NOT NULL

) ON [PRIMARY]

GO

ALTER PROCEDURE [dbo].[usp_ConnectionsCount_full] 

AS

BEGIN

 SET NOCOUNT ON;

INSERT INTO Connections_Full 

  SELECT @@ServerName AS SERVER

 ,NAME

 ,login_time

 ,last_batch

 ,getdate() AS DATE

 ,status

 ,hostname

 ,program_name

 ,nt_username

 ,loginame

FROM sys.databases d

LEFT JOIN sys.sysprocesses sp ON d.database_id = sp.dbid

WHERE database_id NOT BETWEEN 0

  AND 4

 AND loginame IS NOT NULL

END