forked from olahallengren/sql-server-maintenance-solution
- Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathCommandLog.sql
More file actions
Latest commit
31 lines (30 loc) · 957 Bytes
/
Copy pathCommandLog.sql
File metadata and controls
31 lines (30 loc) · 957 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
SET ANSI_NULLS ON
GO
SETQUOTED_IDENTIFIERON
GO
IFNOTEXISTS (SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[CommandLog]') ANDtypein (N'U'))
BEGIN
CREATETABLE [dbo].[CommandLog](
[ID] [int] IDENTITY(1,1) NOTNULL,
[DatabaseName] [sysname] NULL,
[SchemaName] [sysname] NULL,
[ObjectName] [sysname] NULL,
[ObjectType] [char](2) NULL,
[IndexName] [sysname] NULL,
[IndexType] [tinyint] NULL,
[StatisticsName] [sysname] NULL,
[PartitionNumber] [int] NULL,
[ExtendedInfo] [xml] NULL,
[Command] [nvarchar](max) NOTNULL,
[CommandType] [nvarchar](60) NOTNULL,
[StartTime] [datetime] NOTNULL,
[EndTime] [datetime] NULL,
[ErrorNumber] [int] NULL,
[ErrorMessage] [nvarchar](max) NULL,
CONSTRAINT [PK_CommandLog] PRIMARYKEYCLUSTERED
(
[ID] ASC
)WITH (PAD_INDEX=OFF, STATISTICS_NORECOMPUTE=OFF, IGNORE_DUP_KEY=OFF, ALLOW_ROW_LOCKS=ON, ALLOW_PAGE_LOCKS=ON)
)
END
GO