When the procedure is called {namingConventionForDatabaseObjects}_QueueActivation

Oct 30, 2015 at 3:57 PM
Edited Oct 30, 2015 at 4:03 PM
Hi
Could you please help me.
when the stored procedure is called {namingConventionForDatabaseObjects}_QueueActivation

When the tableDependency is stopped?

If the sp is called when tableDependency is stopped and automaticDatabaseObjectsTeardown equal true
that I think the sp have error
this condition is wrong
IF (SELECT COUNT(*) FROM [namingConventionForDatabaseObjects] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 
I think you need delete this condition if the tableDependency is stopped and automaticDatabaseObjectsTeardown equal true
IF (SELECT COUNT(*) FROM [namingConventionForDatabaseObjects] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 
Nov 4, 2015 at 8:05 AM
H tolik51

If I remove this condition:
IF (SELECT COUNT(*) FROM [namingConventionForDatabaseObjects] WHERE message_type_name = 'http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer') > 0 
when the "client" exits without Disposing or Stopping TableDependency, all database objects created for send notifications are not dropped.
This condition ensure a clean up operation: in this way no unused database object are left inside DB.