Search code examples
sql-serversql-server-data-toolsservice-broker

SSDT failing to find stored procedures from SQL Server Service Broker

I am running into an issue with SSDT and SQL Server Service Broker. When I run SSDT updates, it is finding one of the stored procedures that get created and dropped regularly (SqlQueryNotificationStoredProcedure-GUID).

Is there a way to ignore these stored procedures when I run my updates so that I will not get an error thrown that the stored procedure is missing (because it has already been dropped by the broker)?

Solution

  • I haven't seen that dependency thing before, looks pretty cool!

    You can use my filter to exclude them from the deployment:

    https://agilesqlclub.codeplex.com/

    Probably:

    /p:AdditionalDeploymentContributorArguments="SqlPackageFilter=IgnoreName(SqlQueryNotificationStoredProcedure.*)"

    ed