CREATE TABLE [mig_director].[Secret] ( [Id] INT IDENTITY(1,1) NOT NULL, [Name] VARCHAR(250) NOT NULL, [Value] VARCHAR(MAX) NOT NULL, CONSTRAINT [PK_Secret] PRIMARY KEY CLUSTERED ([Id] ASC) ); GO CREATE UNIQUE INDEX [IX_Secret_Name] ON [mig_director].[Secret] ([Name]) GO create procedure [mig_director].[Secret_List] as select [Id] , [Name] , [Value] from [mig_director].[Secret] order by [Name] GO create procedure [mig_director].[Secret_GetByName] @name varchar(250) , @id int output , @value varchar(max) output as select @id = [Id] , @value = [Value] from [mig_director].[Secret] where [Name] = @name GO create procedure [mig_director].[Secret_Get] @id int , @name varchar(250) output , @value varchar(max) output as select @name = [Name] , @value = [Value] from [mig_director].[Secret] where [Id] = @id GO create procedure [mig_director].[Secret_Delete] @id int as delete [mig_director].[Secret] where [Id] = @id GO create procedure [mig_director].[Secret_Create] @name varchar(250) , @value varchar(max) as insert [mig_director].[Secret] ( [Name] , [Value] ) values ( @name , @value ) GO create procedure [mig_director].[Secret_Update] @id int , @name varchar(250) , @value varchar(max) as update [mig_director].[Secret] set [Name] = @name , [Value] = @value where [Id] = @id GO delete [mig_director].[Folder] where [FolderId] = 'ErrorFiles' GO delete [mig_director].[TrackFolder] where [FolderId] = 'ErrorFiles' GO