Reputation
Next privilege 125 Rep.
Vote down
Badges
3
Impact
~738 people reached

  • 0 posts edited
  • 0 helpful flags
  • 13 votes cast
Mar
15
comment Get object script in SQL Server via T-SQL?
ObOtherWayToDoIT. I've been using Event Notifications for the past couple years with great success. (So great I now present on it at SQLSatrudays). Here's my current presentation, slide deck, demos, code repository and all. sqlsaturday.com/viewsession.aspx?sat=362&sessionid=25219
Mar
15
comment Get object script in SQL Server via T-SQL?
What he said. Here's a good article on doing it via Powershell: simple-talk.com/sql/database-administration/…
Sep
24
awarded  Autobiographer
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.