Data Driven Subscription Workaround
A guide for getting around the missing data driven subscription feature in Standard editions of Microsoft SQL Server.
2016-08-29
6,245 reads
A guide for getting around the missing data driven subscription feature in Standard editions of Microsoft SQL Server.
2016-08-29
6,245 reads
SQL School expands its replication series with a look at how you can set up a subscriber with MVP Andy Warren.
2009-04-21
2,587 reads
Generates a dataset for determining when subscriptions fail to send e-mail or post reports to file shares.
2009-08-05 (first published: 2008-11-19)
1,202 reads
What version of client tools are you using? I can register my SS2K servers, SP3a on W2K from my W2K3 server.
2004-11-07
2003-06-18
One option is to use a derived table containing the key + max(ship_date) and then delete from your table the rows that don't match as so: DELETE Orders --select * FROM Orders t LEFT OUTER JOIN (SELECT Order_No ,Line_No, Ship_Date = MAX(Ship_Date) FROM Orders GROUP BY Order_No ,Line_No) s ON t.Order_No = s.Order_No AND t.Line_No […]
2003-06-04
By Steve Jones
I don’t do a lot of work with disabled index, but I learned how...
By Steve Jones
I’m leaving again tomorrow for a trip. This time I head back to Boston...
By Tim Mitchell
Most of us who work with data have, at least a few times, been...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers