sql | SQL Server‎ > ‎sqlsrv | T-SQL‎ > ‎

tsql | SP_WHO

USE [master]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[ttc](
[spid] [smallint] NOT NULL,
[ecid] [smallint] NOT NULL,
[status] [nchar](30) NOT NULL,
[loginame] [nvarchar](128) NULL,
[hostname] [nchar](128) NOT NULL,
[blk] [char](5) NULL,
[dbname] [nvarchar](128) NULL,
[cmd] [nchar](16) NOT NULL,
[request_id] [int] NOT NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO


Comments