/****** Object:  Table [dbo].[TMS_Log]    Script Date: 06/29/2009 12:28:18 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[TMS_Log](
	[FileName] [varchar](400) NULL,
	[ProcessDate] [datetime] NULL,
	[Action] [varchar](400) NULL
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

ALTER TABLE [dbo].[TMS_Log] ADD  CONSTRAINT [DF_TMS_Log_ProcessDate]  DEFAULT (getdate()) FOR [ProcessDate]
GO


/****** Object:  StoredProcedure [dbo].[usp_InsertTMSLog]    Script Date: 06/29/2009 07:02:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<>
-- Create date: <7/27/2009>
-- Description:	<Write log to TMS_Log>
-- =============================================
ALTER PROCEDURE [dbo].[usp_InsertTMSLog]
	-- Add the parameters for the stored procedure here
	@Filename varchar(400)
	,@Action varchar(50)
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

   INSERT INTO [TI].[dbo].[TMS_Log]
           ([FileName]
           ,[Action])
     VALUES (@Filename, @Action)

END