Yes, that'll do it. Thanks!

That could work. How do I do the "associate the company name with it" bit?

This is an interesting method. But the problem is that on the first page, the "report header" items appear BELOW the "page header" items.

One the user has selected a client, the @Client parameter is populated with the value of ClientID from the query. I can then use the @Client parameter variable in the...

Thanks again for your reply and input, I appreciate it. Sorry if it comes across as harsh, but I have some contrary ideas to your suggestions. Ultimately, though, this is...

Thanks for your input.

"it seems to me that the only error that could be raised that would crash the trigger would be the renaming of the table the trigger uses,...

Thanks for the suggestion. I tried using a TRY..CATCH block it but it did not change the behaviour: the event that caused the trigger to fire is also rolled back....

I should be moere specific.

I know how to drop a database, but what I am after is how to remove everything that was set up when you run through the...

No? I used to get the "Invalid object name" error at compile-time several months ago. But something has changed and now I don't.

The reason for using a CLR trigger is make the auditing generic. The generic CLR trigger inserts any changed fields into one standard auditing table. Also, by calling the generic...

Thanks for the suggestion. I tried it, but SSIS gives me the error:

Parameter Information cannot be derived from SQL statements with sub-select queries. Set parameter information before preparing command.

I cannot try that because each table has an ID field, and I need to refer to the ID field in the DELETE query.

This is very frustrating - it is...

Hi, thanks for the suggestion. I tried it, but it also given an error, a different one. This one is:

The multi-part identifier "HouseFacilityGroup.HouseId" could not be bound.

Again, the revised DELETE...

This is an OLE DB Command transformation within a Data Flow task.

You're right, the data gets clobbered.

What I meant to say was that I want to perform a check without clobbering the data.