SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-- ==========================================================================================
-- Author:		M. Jordaan
-- Create date: 24-feb-2016
-- Description:	Verwijderen records op basis van tijd kolom uit FL tabellen.
--              Tijd kolom dient op basis van DATETIME te zijn.
-- ==========================================================================================
CREATE PROCEDURE [dbo].[msp_LinkedServerCreateTable] 
	-- Parameters for the stored procedure here
AS
BEGIN
  -- SET NOCOUNT ON added to prevent extra result sets from
  -- interfering with SELECT statements.
  SET NOCOUNT ON;


  BEGIN TRY

    IF object_id('master.dbo.Linkedserveroffline') is null
	BEGIN

	  CREATE TABLE [master].[dbo].[LinkedServerOffline](
	    [LinkedServer] [nvarchar](50) NOT NULL,
	    [Offline] [datetime] NULL,
	    [TestInterval] [int] NOT NULL CONSTRAINT [DF_LinkedServerOffline_TestInterval]  DEFAULT ((60))
      ) ON [PRIMARY]

	  CREATE UNIQUE CLUSTERED INDEX [IDX_LinkedServerOffline] ON [master].[dbo].[LinkedServerOffline]
	    ([Offline] DESC,
	     [LinkedServer] DESC
        )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, 
		       DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
	END
  END TRY

  BEGIN CATCH

  END CATCH
END








GO