Kbase P16801: Cannot add rows to Sysdepends for the current stored procedu
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/30/2003 |
|
Status: Unverified
FACT(s) (Environment):
MS SQL 2000
FACT(s) (Environment):
MS SQL 7
SYMPTOM(s):
Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object <object name>.
Getting the message when running the script to create the stored procedures
CAUSE:
In Microsoft SQL Server version 6.5 and later, scripts for stored procedures are generated in alphabetical order if the object dependencies options is not selected.
FIX:
This error does not affect your ability to use the stored procedures. They will be created and you will be able to run them. You can avoid this error message by selecting the "include object dependencies" option when the scripts are generated.
Generate the scripts without including the object dependencies and ignore the error you receive when running the script to create the stored procedures.
-or-
Include the object dependencies and then delete the drop and create table sections.