Web Development

Ask something
Discussion Locked

MSSQL: Object Status

0 helpful
1 reply

by rodsherer

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am looking for a way to query the MSSQL database for 'invalid' procedures and/or views. Oracle allows you to very simply query the user_objects table for objects with a status <> 'VALID'. However, it does not seem this cut and dry with MSSQL. Is there a way to check the status of procedures, functions and views in MSSQL?

1 reply

by sl_alagappan

if the result of the query 'select name from sysobjects where name =' does not return any row, then the proc called is invalid. If returns rows, then valid proc. Hope, I understand yr requirement clearly.

This discussion is closed to new replies.