SA Developer .NET

How do you put the DB In Single User Mode if you have Transactional Replication Running and this DB is the Publisher? 

ALTER DATABASE MyPublisherDB

  SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Yields: Nonqualified transactions are being rolled back. Estimated rollback completion: 100%

---

A Program is only Complete when the Programmer Dies

Can you temporarily stop the log reader agent?

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!

I can, I'll try it shortly.

---

A Program is only Complete when the Programmer Dies

Awesome Gila, stopping the Log Reader Agent is exactly what worked :)

---

A Program is only Complete when the Programmer Dies

Pleasure

---

Gail Shaw - SQL In the Wild
SQL Server MVP
--
Chaos, panic and disorder. My job here is done!