Use of SqlDependency creates sprocs/queues/services

asok14215

They always show up as new items starting with "SqlQueryNotification-<guid>" that need to be committed.

Is the best way to suppress this to use the filter?

Eddie D

Hi, Thank you for your post into the forum.

Most definitely using the filter is the way to remove the object types you wish to remove from SQL Source Control.

Right Click the database in the SSMS Object Explorer ->Select option Other SQL Source Control Tasks ->Edit Filter rules and uncheck the object types you do not wish to be seen on the commit tab, get latest tab or when you perform an undo task.

Many Thanks
Eddie