/* Creates a record in the subtext_log table */  
CREATE PROC [dbo].[subtext_AddLogEntry]  
(  
  @Date DateTime  
  , @BlogId int = NULL  
  , @Thread varchar(255)  
  , @Context varchar(512)  
  , @Level varchar(20)  
  , @Logger nvarchar(256)  
  , @Message nvarchar(2000)  
  , @Exception nvarchar(1000)  
  , @Url varchar(255)  
)  
AS  
  
if @BlogId < 0  
 SET @BlogId = NULL  
  
INSERT [dbo].[subtext_Log]  
SELECT @BlogId, @Date, @Thread, @Context, @Level, @Logger, @Message, @Exception, @Url