USE [Bss]
GO
/****** Object:  StoredProcedure [dbo].[spInsertLog]    Script Date: 03/10/2009 04:12:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[spInsertLog]
(
    @LogType int = 1,
	@Title varchar(128),
	@Note varchar(512),
	@Employee int,
	@Job int,
	@Permit int,
	@Customer int,
	@Professional int,
	@Document int
)
AS
	SET NOCOUNT OFF;
IF ((SELECT [Enabled] FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType)) = 1)
    BEGIN
        IF (ISNULL(@Title, '') = '')
        SELECT @Title = Title FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType)

        INSERT INTO [Log](LogType, Title, Note, Employee, Job, Permit, Customer, Professional, [Document])
        VALUES (@LogType,@Title,@Note,@Employee,@Job,@Permit,@Customer,@Professional,@Document)
        SELECT LogId, Title, Note, Employee, Job, Permit, Customer, Professional, [Document], CreationTime FROM [Log] WHERE (LogId = SCOPE_IDENTITY())
    END
ELSE
    BEGIN
        (SELECT @Title = Title FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType))
        PRINT 'LogType ' + CAST(@LogType AS varchar(5)) + ' (' + @Title + ') is disabled, record was not added.'
        SELECT LogId = NULL, Title = NULL, Note = NULL, Employee = NULL, Job = NULL, Permit = NULL, Customer = NULL, Professional = NULL, [Document] = NULL, CreationTime = NULL
    END

CREATE TRIGGER Log_INSERT
   ON  [Log]
  INSTEAD OF INSERT 
AS 
BEGIN
	SET NOCOUNT OFF;

DECLARE
	@LogType int,
	@Title varchar(128),
	@Note varchar(512),
	@Employee int,
	@Job int,
	@Permit int,
	@Customer int,
	@Professional int,
	@Document int

SELECT 
	@LogType = LogType,
	@Title = Title,
	@Note= Note,
	@Employee = Employee,
	@Job = Job,
	@Permit = Permit,
	@Customer = Customer,
	@Professional = Professional,
	@Document = Document
FROM inserted

IF ((SELECT [Enabled] FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType)) = 1)
    BEGIN
        IF (ISNULL(@Title, '') = '')
        SELECT @Title = Title FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType)

        INSERT INTO [Log](LogType, Title, Note, Employee, Job, Permit, Customer, Professional, [Document])
        VALUES (@LogType,@Title,@Note,@Employee,@Job,@Permit,@Customer,@Professional,@Document)
        SELECT LogId, Title, Note, Employee, Job, Permit, Customer, Professional, [Document], CreationTime FROM [Log] WHERE (LogId = SCOPE_IDENTITY())
    END
ELSE
    BEGIN
        (SELECT @Title = Title FROM [BSS].[dbo].[LogType] WHERE (LogTypeId = @LogType))
        PRINT 'LogType ' + CAST(@LogType AS varchar(5)) + ' (' + @Title + ') is disabled, record was not added.'
        SELECT LogId = NULL, Title = NULL, Note = NULL, Employee = NULL, Job = NULL, Permit = NULL, Customer = NULL, Professional = NULL, [Document] = NULL, CreationTime = NULL
    END
GO

Msg 102, Level 15, State 1, Procedure Log_INSERT, Line 44
Incorrect syntax near 'END'.

quote:

---

Originally posted by guptam
Your error is most likely #1, SQL will complain like mad man .. but will not tell you it wants another "END" LOL.

---