I finally got this error figured out. After searching, posting and Tweeting I solved the problem by uninstalling SQL 2005. I know this is not an option for some but...

Hummm. In my haste of trying to figure this out I missed the tree in spite of the forest. I forgot about that.

I think this will be the better solution....

Thanks. I'll look into that.

Thanks.

But it seems I was not clear.

I need (want) to do this auto-magically based on the different users/server configurations.

I know how/where to find in SSMS.

It is...

Thanks

I have been tasked with writing and applying security to our Dev, Test, UAT databases. Our company is growing and the number of developers is increasing. Can you advise of...

Thanks for the article. Nice little snippet to add to my bag of tricks.

I usually create an ERD before creating the tables and keep that updated as things change.

But this...

I see some of your points but not all.

The reason I am declaring and setting variables is because not all the data for the reports is in the first table....

Not sure how this helps me do separate inserts....

I am doing similar but the second insert is the only one inserting into the table.

Pseudo code

SET NoCount ON

If Exists(Select ... From Inserted where StatusID = 3 )

Begin

--Declare the variables

@FormID int...

Select

variables...

From Inserted

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

-- Settngs for other forms

Depending on the formid re-setting varibles to different...

I can't post all the code, I tried to clean it and it appears I messed it up more for the post. Oh well.

Thanks for the help.

Never mind all I figured it out.

Point taken.

Respectfully

Aaron,

Thanks for your comment about the tables/trigger names.

But I posted my code for assistance NOT negative comments.

You would be more helpful to leave them out.