Aleks
asked on
Check ALL SP in database make sure there are no errors
Is there a way to check all the Stored Procedures in a database and see if there are any errors in them ?
Like an ambiguous field when selecting or referencing an object that no longer exists, etc.
Like an ambiguous field when selecting or referencing an object that no longer exists, etc.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I don't think this helps me check existing Stored Procedures for missing columns or other errors.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I think the only viable solution is to open each stored procedure and see if anything is marked in red. I found that any missing column is marked in red. It will take time but seems the only reasonable way to do it without messing with the database
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will spread the points since I will need to basically go over each SP individually to see if there is any error marked in red. Thanks for the help.
ASKER
I caught one instance but there may be others. I want to know if there is a way of checking this because there are hundreds of SP int he database.