sql-server-maintenance-solution/Queue.sql at master · nflash/sql-server-maintenance-solution · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[Queue]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[Queue](
 [QueueID] [int] IDENTITY(1,1) NOTNULL,
 [SchemaName] [sysname] NOTNULL,
 [ObjectName] [sysname] NOTNULL,
 [Parameters] [nvarchar](max) NOTNULL,
 [QueueStartTime] [datetime] NULL,
 [SessionID] [smallint] NULL,
 [RequestID] [int] NULL,
 [RequestStartTime] [datetime] NULL,
CONSTRAINT [PK_Queue] PRIMARYKEYCLUSTERED
(
 [QueueID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO