Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object

Posted on 2006-05-18
Medium Priority
Last Modified: 2012-08-13
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'nk_sp_get_portion_size_for_recipe'. The stored procedure will still be created.

What does this mean?
Question by:lunchbyte
1 Comment
LVL 143

Accepted Solution

Guy Hengel [angelIII / a3] earned 2000 total points
ID: 16708248
this does mean that you create the procedure while the other one does not yet exist.
reverse the order of the create procedure statements of these 2 statements to get rid of this message.

the function(s) will work if they are all created.

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
It is possible to export the data of a SQL Table in SSMS and generate INSERT statements. It's neatly tucked away in the generate scripts option of a database.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question