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 |
|
DBADave
Constraint Violating Yak Guru
366 Posts |
 Posted - 2004-07-08 : 14:04:32
|
| Today was the first time I tried running DBCC OPENTRAN on a server involved in replication. I received the following results.Transaction information for database 'DatabaseXYZ'.Replicated Transaction Information: Oldest distributed LSN : (1003:35253:1) Oldest non-distributed LSN : (1003:35254:1)DBCC execution completed. If DBCC printed error messages, contact your system administrator.I thought I should see a message indicating NO long-running transactions or SPID, UID, Name, LSN and Start Time if one exists. Does this command work differently with replication? If so, will I see SPID, UID, etc... when a long-running transaction is detected?Thanks, Dave |
|
|
|
|
|
DBCC OPENTRAN Results and Replication