moGun


Hi,

I have two publications on a database. One Merge Replication and one snapshot replication. When i run select * from syspublications i see only one row. (snapshot). I am not able to see the record for the merger replication. I am a dbo and administrator on the system. Is this some known issue I am surprised.

Have any one else noticed this Or am i missing something obvious

Cheers

Mohan




Re: syspublications ..is there a known issue.?

Greg Y


transactional and snaphost publications can be found in table "syspublications", merge publications can be found in table "sysmergepublications".




Re: syspublications ..is there a known issue.?

moGun

Thanks Greg. I missed that. But still wondering why create a syspublications table and not have all publications in it. Any way thanks for the sharing.






Re: syspublications ..is there a known issue.?

Greg Y

There are too many properties differentiating the two types of publications, so we had to break it into two different tables.