none
not finding the Replication -> local publications option in my sql-server 2005 instance. RRS feed

  • Question

  • HI,

     

    i am not finding the Local Publications option under Replication in my sql-server 2005 instance.  (however i am finding there Local Subscriptions option.)

     

    i have checked the setup installation and all the component are selected.

     

    Can any one suggest me how could i find this Replication- > Local Publications option .

     

    thanks

    Wednesday, April 30, 2008 3:07 PM

Answers

  • Hi, are you using SQL server express?

     

    SQL Express edition only can be a subscription from others publications.It can not create publications.

    Wednesday, April 30, 2008 3:36 PM

All replies

  • Under most circumstances the local publications folder will be empty if you do not have any publications on that server.

    Issue the following query to determine if you do or not.

    sp_msforeachdb 'use ?;exec sp_helppublication;exec sp_helpmergepublication '
    Wednesday, April 30, 2008 3:35 PM
    Moderator
  • Hi, are you using SQL server express?

     

    SQL Express edition only can be a subscription from others publications.It can not create publications.

    Wednesday, April 30, 2008 3:36 PM
  • HI,

    Exactly I was using sql server 2005 Express Edition.

    If you could have suggest what editions to use?

    Well I think Developer Edition as we are software providers / developers, isn't it.

    Thanks

    Thursday, May 1, 2008 4:41 AM
  • All other editions(Enterprise, Standard and Develop)  has a possibility to set replication.

     

    Friday, May 2, 2008 12:12 PM