You have other options as well.

YOu could create a view in the new database and access the view. Then if there are any changes to the other database you...

Have you verified that the query in the NOT EXISTS is correct?

You do have a couple of flaws in the T-SQL for the trigger as well.

1. If...

From BOL (bolding added):

To send Database Mail, you must be a member of the DatabaseMailUserRole database role in the msdb database.

Profile security. Database Mail enforces security for mail profiles. You...

Here's a thread with an example of an INSTEAD OF trigger, although you could use an AFTER trigger in this situation as well.

http://www.sqlservercentral.com/Forums/Topic649749-146-1.aspx

Oh, and I'd enforce this in a Stored...

Global temporary tables (##table_name) are named in the application. Temporary tables (#table_name) get the name given by the application plus an identifier by SQL Server. You can see...

Are you sure the user that is executing the source query has rights on the other database? Cross-Database ownership chaining is disabled by default in SQL Server 2005.

TO change the query timeout you can do this:

cmd.CommandTimeout = [desired timeout in seconds]

You still didn't answer my questions as to what happens when you run the sp in...

I don't have any experience with Dyanamics or Dexterity so I'm not sure I can be of anymore help. I suppose it could bethe use of Citrix is causing...

It will work with a table of any size. It will take longer to run, but it will work. As an aside 12000 rows really isn't a large...

What is the column you have the filter on?

Was it filtering the trigger correctly in the Profiler GUI?

First off, please take note of how I prepared your test data so that it could be used easily. You should read the articles in my signature to learn...

Well this works for any statements that return results. If you want to set this for all SSMS sessions, including new ones, when you open SSMS go to Tools...

Man, I haven't...

Do you want to suppress results to an application or just within an SSMS session?

Have you considered replication?