Viewing 15 posts - 121 through 135 (of 1,790 total)
GSquared (2/17/2012)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 9:05 am
That's great news and thanks for posting back.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 17, 2012 at 6:41 am
Grant Fritchey (2/16/2012)
Stefan Krzywicki (2/16/2012)
Brandie Tarvin (2/16/2012)
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2012 at 8:01 am
Look into using a while loop or a cursor. I believe that will provide you what you need.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2012 at 7:10 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2012 at 7:03 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 16, 2012 at 7:00 am
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 2:33 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 10:58 am
...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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 10:29 am
One other thought here, can you open the publication, remove the article from the publication and then drop the publication?
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 10:17 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 10:13 am
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.
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 10:09 am
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 15, 2012 at 9:56 am
Based on the other questions that the OP posted, I'm beginning to guess yes....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2012 at 12:12 pm
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...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
February 14, 2012 at 11:28 am
Viewing 15 posts - 121 through 135 (of 1,790 total)