Problem with order of object scripting

Topics: Database Publishing Wizard
May 16, 2007 at 12:08 AM
First, let me thank you for this great tool!

The script I created for one of my databases generates the following error, which is related to the order that the objects are scripted:

Msg 208, Level 16, State 1, Procedure PhotosView, Line 4
Invalid object name 'classifieds_Photos'.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'UpdateCategoryAdCounts'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'UpdateCategoryAdCounts'. The stored procedure will still be created.

I would like to email you the whole script so that you can guide me as to how I can workaround this problem. Please let me know to which address I can email.

Thanks,
Andreas
May 24, 2007 at 6:29 PM
Hi Andreas

Can you mail the script to himanshu@microsoft.com?

Thanks
Himanshu