Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dudi777
Starting Member
4 Posts |
 Posted - 2008-04-03 : 09:27:00
|
| Hi.I have already ran dropping publication on one of the databases. The db is pretty big - about 5GB. The script has been running for over 2 hours by now. Why does it take so long? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 09:38:35
|
| How did you drop? Maybe transactions are rolling back.Check with sp_who2 active to see the state? Try DBCC opentran to see open transaction. |
 |
|
|
|
|
|
Dropping merge replication publication