116 reputation
2
bio website
location
age
visits member for 2 years, 7 months
seen yesterday

SQL Server DBA, Prog-rock fan, scifi reader, Renaissance Nerd.


Oct
5
awarded  Supporter
Aug
31
comment Event Notification / Service Broker - no inserts anymore, “previously existing connection with the same peer”
Unfortunately, I don't have a better solution, but dropping all the objects on both sides (queues, routes, endpoints) fixed it. While not optimal, it's a different solution than "Restart the service", which is the other solution I've seen.
Aug
30
comment Event Notification / Service Broker - no inserts anymore, “previously existing connection with the same peer”
Tried, no luck. My thought was that I'm not dequeueing things properly, so using Remus Rusanu's code I've changed how I catch and handle messages. That doesn't fix it. Oddly, on a second machine it's sending just the TRC_DEPRECATION messages, though I'm trapping for a lot of others.
Aug
30
awarded  Student
Aug
29
asked Event Notification / Service Broker - no inserts anymore, “previously existing connection with the same peer”
May
30
comment SQL Server SMO Method “Discover()”
What other modules are you running? My profile is pretty bare. When I ran your code, I got a message saying that Smo.DatabaseCollection doesn't contain a method named Discover.