| bio | website | |
|---|---|---|
| location | ||
| age | ||
| visits | member for | 1 year, 4 months |
| seen | Nov 28 '12 at 21:57 | |
| stats | profile views | 0 |
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. |