-- Table: dbo.SLSLogShippingLog -- Bill Wunder use admin GO CREATE TABLE [dbo].[SLSLogShippingLog] ( [Id] [int] IDENTITY (1, 1) NOT NULL , [DatabaseName] [sysname] NOT NULL , [BackupFileName] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL , [UndoFileName] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [RecoveryFlag] [bit] NULL , [ShipCompleteDt] [datetime] NULL , [BackupUser] [sysname] NOT NULL CONSTRAINT [dft_SLSLogShippingLog__BackupUser] DEFAULT (suser_sname()), [BackupDt] [datetime] NOT NULL CONSTRAINT [dft_SLSLogShippingLog__BackupDt] DEFAULT (getdate()), CONSTRAINT [pkc_SLSLogShippingLog__Id] PRIMARY KEY CLUSTERED ( [Id] ) ON [PRIMARY] , CONSTRAINT [ukn_SLSLogShippingLog__DatabaseName__BackupFileName] UNIQUE NONCLUSTERED ( [DatabaseName], [BackupFileName] ) ON [PRIMARY] , CONSTRAINT [fk_SLSLogShippingLog__DatabaseName__to__SLSLogShipping] FOREIGN KEY ( [DatabaseName] ) REFERENCES [dbo].[SLSLogShipping] ( [DatabaseName] ) ) ON [PRIMARY] GO GRANT UPDATE ON [dbo].[SLSLogShippingLog] ( [ShipCompleteDt] ) TO [public] GO GRANT SELECT ON [dbo].[SLSLogShippingLog] TO [NT AUTHORITY\ANONYMOUS LOGON] GO