I just want to add, that there is no obvious reason why you should be getting deadlocks with this approach. This leads me to believe that there is more...

I don't see anything obviously wrong with your current method, however, the details that you have given us are very sketchy. Please read this article on how to get...

I just want to add to Gail's statment that if you feel that you do need to do these things in a trigger, you should consider using Service Broker to...

joel_langlois (11/30/2008)[hrI'm not exaclty sure what you mean by "initial (but different name) in DNS for the new site"

What I seem to understand is to use a "temporary address" for...

I would think that changing an integer Identity column to a GUID would break the app.

I do not think that you should need this for the Reporting Services issue, you...

Glad I could help.

As for why it's doubled, my guess is that you've got 2 people in accounting and 2 people in sales.

I should also mention that you need to insure that this does not become a SQL Injection target.

Triggers are synchronous, not asynchronous, and are part of your applications synchronous batch of SQL requests. So unless you are using asynchronous .net calls, your app will be stalled...

OK, leaving aside the rest of the select statement, here is what you need to do with just the table names and the FROM clause for Dynamic SQL:

Declare @sql nvarchar(MAX)

--build...

Hmm, thinking about it, I realize that I also have used triggers for custom replication-type solutions and as an input source for Service Broker applications.

I also, pretty much only use DML triggers for Auditing and constraint implementation where the built-in constraints facilities will not work.

joel_langlois (11/30/2008)

---

So I’m wondering how to insure the integrity of the data during the transfer…

For example, once I have a backup of the db on the old host…by the time...

The way to think of Triggers on SQL Server is that they are triggered by the modification statement and not by the actual modification of the individual rows.

This explains both...

Heh. You know the first time I read this I thought that you said "Partitioned Table". I didn't realize until Chris's...