CREATE_TABLE2010-01-19T19:58:26.94052BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbooktDocumentTABLECREATE TABLE [SQLRunbook].[tDocument] ( [Id] [INT] IDENTITY (1, 1) NOT NULL , [File] [NVARCHAR] (450) NULL , [Document] [VARBINARY] (MAX) NULL , [DocumentType] [NVARCHAR] (8) NULL , [LastModifiedDt] [DATETIME] NULL , [Owner] [NVARCHAR] (128) NOT NULL CONSTRAINT [dft_tDocument_Owner] DEFAULT (ORIGINAL_LOGIN()) , [WatchFileForChange] [BIT] NOT NULL CONSTRAINT [dft_tDocument_WatchFileForChange] DEFAULT (1) , [RecCreatedDt] [DATETIME] NOT NULL CONSTRAINT [dft_tDocument__RecCreatedDt] DEFAULT (CURRENT_TIMESTAMP) , [RecCreatedUser] [NVARCHAR] (128) NOT NULL CONSTRAINT [dft_tDocument_RecCreatedUser] DEFAULT (ORIGINAL_LOGIN()) , [LastUpdatedDt] [DATETIME] NOT NULL CONSTRAINT [dft_tDocument__LastUpdatedDt] DEFAULT (CURRENT_TIMESTAMP) , [LastUpdatedUser] [NVARCHAR] (128) NOT NULL CONSTRAINT [dft_tDocument_LastUpdatedUser] DEFAULT (ORIGINAL_LOGIN()) , CONSTRAINT [qkn_tDocument__File] UNIQUE ([File]) , CONSTRAINT [pkc_tDocument__Id] PRIMARY KEY NONCLUSTERED ([Id])); CREATE_INDEX2010-01-19T19:58:27.01052BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__OwnerINDEXtDocumentTABLECREATE NONCLUSTERED INDEX [ixn_tDocument__Owner] ON [SQLRunbook].[tDocument] ([Owner]); CREATE_INDEX2010-01-19T19:58:27.11752BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__LastModifiedDtINDEXtDocumentTABLECREATE NONCLUSTERED INDEX [ixn_tDocument__LastModifiedDt] ON [SQLRunbook].[tDocument] ([LastModifiedDt]); CREATE_INDEX2010-01-19T19:58:27.22052BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__RecCreatedDtINDEXtDocumentTABLECREATE CLUSTERED INDEX [ixn_tDocument__RecCreatedDt] ON [SQLRunbook].[tDocument] ([RecCreatedDt]); CREATE_INDEX2010-01-19T19:58:27.28352BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__RecCreatedUserINDEXtDocumentTABLECREATE NONCLUSTERED INDEX [ixn_tDocument__RecCreatedUser] ON [SQLRunbook].[tDocument] ([RecCreatedUser]); CREATE_INDEX2010-01-19T19:58:27.37352BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__LastUpdatedDtINDEXtDocumentTABLECREATE NONCLUSTERED INDEX [ixn_tDocument__LastUpdatedDt] ON [SQLRunbook].[tDocument] ([LastUpdatedDt]); CREATE_INDEX2010-01-19T19:58:27.44052BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbookixn_tDocument__LastUpdatedUserINDEXtDocumentTABLECREATE NONCLUSTERED INDEX [ixn_tDocument__LastUpdatedUser] ON [SQLRunbook].[tDocument] ([LastUpdatedUser]); CREATE_FULLTEXT_INDEX2010-01-19T19:58:27.54052BILL764\NOVCTPBILL764\bwunderdboSQLClueSQLRunbooktDocumentTABLECREATE FULLTEXT INDEX ON [SQLRunbook].[tDocument] ([File] LANGUAGE 0X0, [Document] TYPE COLUMN [DocumentType] LANGUAGE 0X0 ) KEY INDEX [pkc_tDocument__Id] ON [ftSQLRunbookCatalog] WITH CHANGE_TRACKING AUTO;