Steve Jones - Editor (11/17/2008)
What are you trying to do? They usually perform separate actions, but if you are looking to just update another server, I might recommend looking at Service Broker.
Yes, I realize it is a strange question. I have known about Service Broker - at a high level - for some time, and never thought of it in this context. My manager talked to someone from Microsoft the other day, and the MS person suggested Service Broker as an alternative to linked servers (perhaps more in the context of SQL 2008). My manager has asked me to investigate further... :w00t:
I really am "fishing" with this post, I realize. Just wondering whether anyone has had any experience with this. Googling it hasn't given me anything to work with...
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]