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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 sp_repldone

Author  Topic 

livezone
Starting Member

10 Posts

Posted - 2008-12-14 : 20:27:06
Does anyone know how much time sp_repldone stored proc required to execute. My db transaction log has grown to 2.5 GB. Is there any chance running this stored proc can create more transaction log

DBCC OPENTRAN gives following information

Transaction information for database 'MyDb'
Replicated Transaction Information:
Oldest distributed LSN : (0:0:0)
Oldest non-distributed LSN : (7390:337:1)

Thanks
Shafiq
   

- Advertisement -