Sample Header Ad - 728x90

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