Here is a neat form of the DELETE query shown above that I find useful at times:

WITH cte

...

Duplicate post. Direct replies here: http://www.sqlservercentral.com/Forums/Topic1140682-392-1.aspx

al_nick (7/12/2011)

---

Hi all-

I have the following EAV table based on exam data which we are receiving:

CREATE TABLE [dbo].[Exams](

[examid] [int] NULL,

[entity] [varchar](255) NULL,

[value] [varchar](255) NULL,

[examrowid] [int] NULL

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

INSERT...

Jeffrey Williams-493691 (7/12/2011)

---

I would recommend SSIS also - and I don't see Service Broker as the right solution. I would think service broker is more geared toward event driven...

Elliott Whitlow (7/12/2011)

---

I absolutely agree it can be done with service broker,...

This script from Lowell is pretty slick:

http://www.sqlservercentral.com/Forums/FindPost1140415.aspx

It's better than what I had in place. It only needs a few tweaks. I gave it a spin and the I saw it...

That's scary, we even picked the same alias and variable names :blink:

If you're ready for a new challenge asynchronous behavior can be achieved purely in T-SQL using Service Broker.

Thanks for sharing the links. They had me at "Undo/Redo" 😀

Try this form (changes to your original query bolded):

DECLARE @cnt INT

SELECT @cnt = cnt

FROM OPENQUERY(SDW, 'SELECT count(*) as cnt

...

Yes,...

David Benoit (7/12/2011)

---

Yes, force_invalidate_snapshot = 1 is identical to the warning in the GUI. Only run the sp_droparticle statement though not the sp_dropsubscription statement that you have. You really don't...

Thanks for the reply David. I would like to do this in T-SQL if possible. Would running this on the publisher instance be equivalent to the steps you provided for...

This is a first for me...I never before heard anyone say they used the "English Query" sub-system. I am curious as to why it was dropped from the product since...

Dean Cochrane (7/12/2011)

---

I haven't tried that - change compatibility to...