Use of SqlDependency creates sprocs/queues/services

asok14215asok14215 Posts: 4
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?

Comments

  • Eddie DEddie D Posts: 1,567 Rose Gold 4
    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
    Eddie Davis
    Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.