• Bad effort because of lack of knowledge.

    From BOL:

    A trigger is a special type of stored procedure that is not called directly by a user. When the trigger is created, it is defined to execute when a specific type of data modification is made against a specific table or column.

    So, create a view. It may be real view or a dummy one:

    CREATE VIEW MyView

    AS

    SELECT

    CAST(NULL as int) as Col1,

    CAST(NULL AS nvarchar(50) as Col2,

    etc.

    Create your SP as a INSTEAD OF INSERT trigger on this view.

    Perform insert into the view.

    Here it is: table passed to stored procedure as system table "inserted".

    Works quickly, effectively, in both versions of SQL Server.

    _____________
    Code for TallyGenerator