This project has moved and is read-only. For the latest updates, please go here.

missing SP in the .SQL files

Jan 9, 2012 at 6:23 PM

Hi,

 

the SP required by the dependency viewer are not in the .SQL file.

usp_RetrieveRunIDs and others doesn'T exists.

where to get them?

Coordinator
Jan 10, 2012 at 8:36 AM

Willgart,

Those procedures were added into the database version 6, and are created by the Analysers.  I neglected to update the SQL Scripts, as the analysers now maintain the database (creating new procedures etc. on startup).

I'll update the SQL Scripts in the next week.

Please note that if you run the analyser against an empty or existing meta data database (where you have dbowner rights), all the DDL will be executed for you as part of the analysis.

 

Keith.

Jan 10, 2012 at 11:20 AM

Hi,

I finally find them in the code... but they are not been applied automatically!!!

In fact after running the utility 2 times, the tool detect that the DB is wrong and finally apply the patch to create the SP!

so the bug is at the DB level detection, which was not detected as level 5 during the first execution of the EXE

now its correct.

Coordinator
Jan 11, 2012 at 6:03 AM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Coordinator
Jan 11, 2012 at 1:15 PM

This issue has been addressed in Alpha 12