General discussion

Locked

MSSQL: Object Status

By RodSherer ·
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?

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by sl_alagappan In reply to MSSQL: Object Status

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

Back to Web Development Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums