Thank you for making that distinction for others that may read this. I hadn't thought to include that.

Correct. Queued.

Of course I figured out that in the OLE DB Source you can click the drop down and select SQL command as the Data Access Mode after I posted this....

In synchronous mode every transaction is hardened to the mirror before being committed at the principal.

In asynchronous mode (Enterprise only), the transactions are committed at the principal and then sent...

Controlled Failover: Failover done manually through use of the 'Failover' button in Mirroring Monitor (or equivalent T-SQL), typically used to failover in the event that you want to do system...

sivaji (6/23/2010)

---

However be the number of times, I am resuming mirroring, after few seconds again mirroring state is changing to "Suspended". Seems like full chaos or a Microsoft bug. I...

Sure did. It works fine as long as it was a controlled failover. If it was an automatic failover or forced manual failover, it holds the transactions until...

SQLJocky (6/5/2010)

---

Are there any fundamental issues or things I should know in advance when using transactional replication w/ updateable subscriptions and mirroring at the same time? I heard that...

By the way, I'm feeling a little foolish for not seeing this sooner but for anyone else looking for it, there is a special system stored procedure that is already...

Awesome, that works like a charm. Thanks!

Should it be something closer to this? Still not right as it is asking me to declare scalar value even though I'm only returning a single value. How...

I think I'm missing something else here as well. I get a couple errors on the declare statement syntax (on the , separating the two variables and it says...

Brandie Tarvin (6/2/2010)

---

Check the dump log, and the server's event viewer. What are they saying?

The usual "fix" in SQL 2000 for me (when it came to problems like this) was...

Did you ever find a fix for this? It is happening for us now.

Brandie Tarvin (6/2/2010)

---

It's been forever since I've used replication. I have this bizarre, vague memory that there's a setting in one of the properties windows that needs to be set...