Replication Flag on system table...

Ant_P · #1 (**permalink**) 12-22-03, 13:59

I've seen it before. I'm hoping someone can kick me to remind me of it again....since I lost my book with all these useful bits of information my life has been a slow tortured hell.

Can anyone remind me of the query / suggest a method of querying a system table to see if replication is running for a certain DB please.

Many Thks...

fadace · #2 (**permalink**) 12-23-03, 16:13

Code:

dbcc gettrunc()

or

Code:

select * from sysobjects where name = "rs_lastcommit"

fadace · #3 (**permalink**) 12-23-03, 16:14

Code:

dbcc gettrunc()

or

Code:

select * from sysobjects where name = "rs_lastcommit"

or

Code:

sp_config_repagent DBName