Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Question Unanswered: Replication Flag on system table...

    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...

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Code:
    dbcc gettrunc()
    or
    Code:
    select * from sysobjects where name = "rs_lastcommit"

  3. #3
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    Code:
    dbcc gettrunc()
    or
    Code:
    select * from sysobjects where name = "rs_lastcommit"
    or
    Code:
    sp_config_repagent DBName

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •