Hi Jason,

First of all I thank you very much and appreciate your response on this.Actually I am posting a add first time in here.Basically what I want to know is to find out status of SP's/Views/functions etc. I think in oracle we can query dba_objects and it's status column give you whether the object is valid or invalid.

Thats what I want to look at in SQL server as well. So I am looking at similar thing.

Thanks..