Troubleshooting: I can't see my stored procedures in ApexSQL Report even after refreshing on MetaData management

LINKS

General

Apex SQL Audit
Apex SQL Clean
Apex SQL Code
Apex SQL Diff
Apex SQL Diff (Data)
Apex SQL Doc
Apex SQL Edit
Apex SQL Enforce
Apex SQL Log
Apex SQL Report
Apex SQL Script

Troubleshooting Home

SITE FEED

Site Feed

Support Forum

The fastest and most effective to get answers to your questions quickly. Click Here for more info.

FAQs

Quick answers to common questions. Click Here for more info.

Troubleshooting

Known issues and basic troubleshooting techniques for problems or unexpected behaviors. Click Here for more info.

Knowledgebase

Technical tips, How-to articles, and other tutorials about ApexSQL Tools. Click Here for more info.

Online Documentation

All of our help files for download or convenient viewing online. Click Here for more info.

Videos

Watch product demos, training videos, or tutorials of our products' main features. We frequently upload new videos so check often for updates. Click Here for more info.

Troubleshooting

Troubleshooting and Known issues with Apex SQL Tools

I can't see my stored procedures in ApexSQL Report even after refreshing on MetaData management

CAUSE

ApexSQL Report doesn't recognize the stored procedures during Metadata synchronization.

RESOLUTION

Please confirm following if ApexSQL Report doesn't recognize your stored procedures during Metadata synchronization:

Do your stored procedure return resultset? ApexSQL Report skips stored procedures that do not return resultset.
Stored procedures with prefix dt_ & asprpt_ get ignored in MetaData refresh.
Do your stored procedure fail during synchronization? A list of failing stored procedures is shown each time metadata is refreshed. User has option to add such stored procedures to MetaData by selecting and adding manually. Examples of Stored procedures that fail during MetaData refresh:

Invalid or non-runnable stored procedures. Such stored procedures must be corrected before they can be used with ApexSQL Report.
Stored procedures that contain Temp tables or Complex queries. Such stored procedures are runnable on SQL query tool but fail during safe-mode synchronization. User can still make these available to ApexSQL Report by selecting and adding them manually to metadata.

LAST REVIEW

10 August 2007 Date of Last Review

Labels: ApexSQL Report

posted by Jordan Davis on Friday, August 10, 2007

0 Comments: