Gyrus Knowledge Base
Article Number:		04990841
Article Title:		Missing object error when running MSTBLS.SQL

All Training Wizard releases that use Microsoft SQL Server

When running the MSTBLS.SQL script to create the Training Wizard database for Microsoft SQL Server, the following warnings will be reported:

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_class'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_course'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_courselesson'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_enrollment'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_organization'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_student'. The stored procedure will still be created.

Cannot add rows to Sysdepends for the current stored procedure because it depends on the missing object 'sp_goal_stulesson'. The stored procedure will still be created.

These warnings are normal and can be ignored. The reason they appear is because MSTBLS.SQL defines triggers that call stored procedures that have not been created yet. When the MSGOAL.SQL script is run, those stored procedures will be properly created and the references from the triggers to those stored procedure will be resolved.

04990842 - Row size error when running MSTBLS.SQL.

THIS INFORMATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. GYRUS SYSTEMS DISCLAIMS ALL WARRANTIES, EITHER EXPRESSED OR IMPLIED. GYRUS SYSTEMS SHALL NOT BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS, OR SPECIAL DAMAGES, EVEN IF GYRUS SYSTEMS HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES.

For additional assistance send email to support@gyrus.com or phone technical support at 1-800-284-9787
Gyrus Systems, Inc. is located at Gyrus Center, 620 Moorefield Park Drive, Richmond, VA 23236-3692.
Office Phone: (804) 320-1414 Office Fax: (804) 320-2323 Located on the web at www.gyrus.com