How to manage stored procedure dependencies in SSDT?
3
votes
1
answer
1733
views
I have multiple stored procedures, some that depend upon others. When publishing my database, I receive an error when creating some stored procedures due to dependency issues. SSDT seems to be creating the stored procedures in alphabetical order, not dependency order like I need.
For example, suppose sp_ProcA depends upon sp_ProcB. SSDT is trying to create sp_ProcA first and fails because sp_ProcB hasn't been created yet.
I've looked through project and script settings. I've found nothing related to dependency management.
Asked by mw007
(133 rep)
Sep 29, 2015, 12:04 PM
Last activity: Sep 29, 2015, 04:44 PM
Last activity: Sep 29, 2015, 04:44 PM