I was trying to add a Database Trace Listener to my Enterprise Library Logging Application Block, and had a hard time figuring out what the signature of the two stored procedures it references were supposed to look like.  Here are the procedures that I am referring to, AddCategoryStoredProcedure and WriteLogStoredProcedureName:

I finally just opened up the source code for the Enterprise Library itself to look what it was going to try to pass those procedures, and then created procedures that had the parameters it expected.  To save you the same trouble ... here is what those procedures are supposed to look like:

CREATE PROC [dbo].[WriteLog]
@EventID int,
@Priority int,
@Severity nvarchar(32),
@Title nvarchar(256),
@Timestamp datetime,
@MachineName nvarchar(32),
@AppDomainName nvarchar(512),
@ProcessID nvarchar(256),
@ProcessName nvarchar(512),
@ThreadName nvarchar(512),
@Win32ThreadId nvarchar(128),
@Message nvarchar(1500),
@FormattedMessage ntext,
@LogId int OUTPUT
AS

-- Add logic here to insert the values into the appropriate table

-- Set the ID the DB automatically assigned to the log entry so it
-- can be returned as an output parameter
SET @LogID = SCOPE_IDENTITY()

Then here is the one that tags the log with one or more categories:

CREATE PROC [dbo].[AddCategory]
@CategoryName varchar(MAX),
@LogID int
AS

-- Add logic here to insert the values into the appropriate table