Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
homebrew
Posting Yak Master
114 Posts |
 Posted - 2005-08-05 : 14:23:11
|
| 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.So, what action will create a syssubscriptions record with srvid = 2 and dest_db = 'my dest database' like all the other ones ?? I will create the snapshot tomorrow when there are no locks on the table. I'm pretty sure that this publication and subscription are the same format as all the others.Any thoughts on why this is ? |
|
|
|
|
|
Repl - syssubscriptions w/ "virtual" dest_db