Post reply

any way to tell if sp_replicationdboption is already enabled?

  • May 4, 2004 at 7:13 am

    #163559

    Poked around some but I couldn't find a workable 'If exists' example to test if a DB is already enabled for replication.  Just trying to script out a procedure and while I can run it even if it is, would rather test on it.

    thanks,

    Chris

     

  • May 4, 2004 at 7:32 am

    #505131

    What about the following?

    if exists (select * from master..sysdatabases where name = <DB Name> and category > 0)

    ...

  • May 4, 2004 at 7:40 am

    #505136

    category was what I was looking for, thanks

    Chris

  • May 7, 2004 at 6:39 am

    #505653

    You can also use:

    sp_helpreplicationdboption 'dbname'

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply