syssubscriptions w/ dest_db = 'virtual'

I wrote some scripts to report on my replication jobs, and noticed that one
table isn't showing up on my report. After digging a bit, I find that it's
because the only entry in syssubscriptions has SRVID = -1 and DEST_DB =
'virtual'. All the other subscriptions have 2 records in syssubscriptions,
one with SRVID = -1 and DEST_DB = 'virtual', and a second row with SRVID =
2 (server id) and DEST_DB = 'AdvDbWhs' (my subscriber DB).

I dropped the publication, and recreated it and the subscriber, but I still
only get that 1 "virtual" record in syssubscriptions.

Any thoughts on why this is ?


--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-replication/200508/1
.

Relevant Pages

  • USCG/Cocaine Bust
    ... You are subscribed to Pentagon Channel Reports for the Pentagon Channel. ... Update your subscriptions, modify your password or e-mail address, or stop ... U.S. and friendly nation laws prohibit fully ... with our laws this report cannot be provided in ...
    (sci.military.naval)
  • Re: Free SCA newsletters
    ... > subscriptions, the subscriptions are usually expected to support the ... > office (e.g. report copies, office supplies, etc.). ... cost of physical newsletter copies, can the cost of the on-line ...
    (rec.org.sca)
  • Re: Passing a dataset
    ... SSRS has many bugs and weaknesses. ... the report viewer but not when rendered to PDF. ... Digging into Crystal now. ... A head to head comparison of the two will ...
    (microsoft.public.vb.crystal)
  • Re: (More) problem(s) when filtering lists in connected webparts...
    ... I'll start digging. ... I'll report back any useful results.... ... you'll have to reverse engineer how SharePoint builds ...
    (microsoft.public.sharepoint.windowsservices)
  • Re: Customer arrested for content in his Digital Camera at Best Buy
    ... >I'd be willing to bet that many other states have laws like this on the ... >books. ... I did a little digging about this and found a plethora of material at ... states require film developers to report." ...
    (misc.legal)