No.  The trigger would wait for the stored procedure to complete.  It is no asyncronous.  If the stored procedure fails, the trigger fails and everything has to roll back. Remember...

If that was the case, how would this forum help him?

My System Table Map doesn't show anything for DTS, but the agent tables are in msdb.  A quick search of BOL will tell what tables you need to look at.

This says it all: An explicit value for the identity column in table 'table name' can only be specified when a column list is used and IDENTITY_INSERT is ON.

Looks like...

Personally, I don't think he knows how to read BOL.

CTE's haven't made me forget.  I find them easier to use where I have normally used a derived table in a query.  I don't mind using them, but also look...

I think we could use a little more info.  Could you post the DDL for the source table, some sample data, and the expected output from the sample data.  Be...

Just to confirm, a full backup only backs up enough of the transaction log to ensure a consistant database when restored.  The transaction log backup will truncate all inactive transactions...

One, there are features and capabilities you won't have access to in your QA/DEV environment that you would have access to in your production environment.  I would suggest upgrading your...

What I gave you may or may not work in your situation, but based on the data it seemed to work.  Take it, play with it, read BOL to see...

It might help if you could provide some sample data and what your trying to convert it to.

Oblio,

Based on what you gave me above, how does this look:

declare @datatbl table (

    ida int,

    idb int,

    userid int,

    iddate datetime

    )

insert into @datatbl values(16251,4,13761,'2005-03-26 00:00:00')

insert into @datatbl values(16251,4,16241,'2006-12-07...

I have an idea, post sample data, sample results, and what YOU have done so far and what results YOU have gotten so far.  Then we can help you figure out...

Show us what you have so far.  Perhaps we can see what changes are needed to get it to work.

A little more specific on what you mean optional.  What exactly do you want returned from this stored proc?  Some sample data and results would help.  My suggestion without any...