I couldn't wait until Tuesday, I spent Monday afternoon at work creating the delete trigger template.

It works beautifully, thanks for the correction on adding object type to the object_id...

Wayne, your solution was MUCH better than mine. Cursors are evil 🙂

Thanks for more interesting answers. And Paul, especially thank you for explaining the source of the table name! I don't need it after all, but it is satisfying...

Thanks, Jeffrey. That was the syntax I needed.

The temp table will only contain one row, which contains the @LastUpdateUser parameter passed into the stored procedure.

Insert/Update triggers can use the...

The temp table is available to the procedure that created it and objects called by it.

I am trying to save an input parameter of UserId to pass to a...

This is slow and not elegant, but a cursor will work with your table structure:

DECLARE @Action varchar(10),

@Time datetime,

@UserCount int,

@MaxUsers int

SELECT @UserCount = 0, @MaxUsers = 0

DECLARE Cur CURSOR...

Thank you for the filtering idea.

Trace found the issue.

I had to do the promotion with a single text file for all the procedures. I put the...

Thank you both.

I made a backup yesterday as soon as this started.

A DDL trigger is a good thought, I will experiment with that today.

I ran one trace yesterday, there...

Nope, Honolulu and Urbana

Try playing with a temp table. This keeps the original employeeid and filters from the activedirectory table first. It should let you use the indexes on WhitePaper:

--------------------------------

create table #ActiveDirectory...

If you have to work with extensions to a 3rd party application, you need to follow their pattern. I worked on a large health-care system (same as Sean's?), that stored...

Barry, That link just redirects to the SQL Server 2008 homepage at Microsoft.

There's probably a better way than this, but I couldn't think of a summary function.

If you wanted this to be generic (any number if values associated with one id),...

Thank you, that worked perfectly.

I had tried the same techique putting the exec in a FROM clause, which failed.

🙂