GSquared (2/17/2012)

---

Also had an old Volkswagen Beetle that we put through four or five years of -35F to -45F winters, parked in the woods (where we lived), and we started...

That's great news and thanks for posting back.

Grant Fritchey (2/16/2012)

---

Stefan Krzywicki (2/16/2012)

---

Brandie Tarvin (2/16/2012)

---

Can I just say, I hate that nothing dies in Florida? For those of you experiencing winter, please send snow in my direction. I'm...

Look into using a while loop or a cursor. I believe that will provide you what you need.

Troubleshooting replication is something best done with detailed issues as it really depends on what the issue is. So, if you have a replication problem please share as much detail...

It will be good to hear how things go with that change.

Just a note but when you say publication, I think you are referring to the snapshot agent. You really...

Definitely appears that your metadata is corrupt. My recommendation would be to call MS and get support from them.

Let me know how things work out.

Have you tried running the sp_dropsubscription and passing in a specific article name instead of "all"? Please try that and let me know.

If this doesn't work you have a...

...and when you run the following you show the tables in the publication?

selectsa.*

fromsysarticles sa inner join syspublications sp

on sa.pubid = sp.pubid

wheresp.name = 'Pub1'

When you ran the first query that...

One other thought here, can you open the publication, remove the article from the publication and then drop the publication?

So you see a publication, Pub1 on the publisher but don't show a subscription. When you query syssubscriptions on the publisher you return 0 rows. What happens when you query...

Just to be clear you don't have a file in the location specified?

"D:\SQLData\Replication\unc\RICHMSSQL11_REFERENCE_REFERENCEPUBLICATION\20120215070002\physn_17#16.bcp"

If not then I would definitely be suspicious of the subscription.

Are there other publications for that database that you want to keep? The query that the previous poster is helpful. I would include a bit more to get a better...

Based on the other questions that the OP posted, I'm beginning to guess yes....

The execution plan, as shown to you in SSMS is a visual rendering of XML. The optimizer which comes up with the plan is not a part of that plan...