Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
avignesh
Starting Member
2 Posts |
 Posted - 2005-08-29 : 01:31:06
|
| Friends,Is there any query in SQL Server to identify the invalid objects , just equivalent to the Oracle query "select * from dba_objects where object_type = 'PROCEDURE' and status = 'INVALID"Your help is really appreciated ..Regards,Vignesh.A |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-29 : 06:48:59
|
| Hi avignesh, Welcome to SQL Team!Can you give me an example of an "invalid object" in this context?Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-29 : 06:55:16
|
| Did you mean the objects that were not used by your application?MadhivananFailing to plan is Planning to fail |
|
|
|
avignesh
Starting Member
2 Posts |
Posted - 2005-08-30 : 10:42:26
|
| Friends,Thanks for the response.I'm using invalid objects in the sense , the dependent object of a procedure which actually not exists at the time of executing a procedure.I guess sp_depends in SQL Server serves the purpose of identifying whether the dependnt objects are exists or not.But my requirement is something like to list out the procedures which are invalid for execution( Say in Oracle, Select * from dba_objects where object_type = 'PROCEDURE' and status = 'INVALID" lists the procedures which are invalid)Any such options in SQL Server ??? |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-30 : 11:49:50
|
| The sysdepends table (and sp_depends) are what you want in SQL Server, but they aren't very "robust" IME (in SQL2000 at least)Kristen |
|
|
|
|
|
|
Identifying invalid objects