Use of SqlDependency creates sprocs/queues/services

asok14215asok14215 Posts: 4
edited April 19, 2012 11:09AM in SQL Source Control Previous Versions
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?
· Share on Twitter

Comments

  • Eddie DEddie D Posts: 1,807 Rose Gold 5
    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
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
    · Share on Twitter
Sign In or Register to comment.