Don's post looked like it might be relevant.  Otherwise, Scott ....  I have the same take on this as you .....    There are a few references in BOL to "ad hoc"...

Also, when you detach, through EM, it gives you the option to kill all the connections.  You can use that feature even if you don't really want to detach. Kill...

Go to Books Online, and look at the "overview" section of PULL and PUSH subscriptions.  There's some good info there.

I was wondering what those "_WA_Sys_%" ones were all about.  I omitted them, but didn't know if that was a reliable thing to do for accurate, long term results.

I still...

I thought something like this would work:

select * from sysobjects a

where (not exists

 (select * from sysindexes b where a.id = b.id))

and xtype = 'U'

order by name

But I find that...

Have you read this ?

http://support.microsoft.com/default.aspx?scid=kb;en-us;321822

I had a problem a while back caused by the publisher being registered with the local name, not the actual server name.

When setting up...

Hmmmm   that's odd ......  Do you see the server, but not the publications ??   Or do you not even see the server ?  Are they on the same domain ?

I've only used Trans & Snapshot ...  so I can't be much help with Merge.  Since you're using Merge, I assume you have updates that occur at the publisher &...

Are you setting up merge replication just to get the databases to be the same ?  Backup & restore sounds the simplest solution to me.

After they are the same, then...

I saw it already, but didn't have any ideas about it.

After you're finished configuring replication, SQL will create a regular SQL Agent job. You can then edit that job just like any other job to add an additional step.

A...

Perhaps you can put a second step into your push subscription job. If the replication at step one fails, then your new step 2 won't happen. Step 2 writes a...

Changes at the subscriber CAN update the publisher if you've enabled "Immediate Updating". I haven't used it, but the option is there.  Here's the first bit from BOL:

Immediate Updating

Immediate...

" ... When you say ""contimuosly updating" subscriber" do you mean a combination ..."

Replication creates the SQL Agent jobs. When you create the subscription, you can choose:

"Continuosly updating" -...

I usually have the SQL Agent job create a log text file...  It's often quite helpful in troubleshooting.

Job -> Steps -> Edit -> Advanced  then specify a name & path...