InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 16:39:21 GMT20http://www.sqlservercentral.com/Forums/Topic435362-146-1.aspxIt also really depends on what you mean by valid? You could look at the dependencies to make sure they all exist for that SP.[code]select object_name(so.id), object_name(depid)from sysdepends sd inner join sysobjects so on so.id = sd.idwhere so.xtype = 'P'[/code]Thu, 20 Dec 2007 13:23:37 GMTJohn Rowanhttp://www.sqlservercentral.com/Forums/Topic435362-146-1.aspxI don't believe so... other than running it or taking it apart and running the peices...You could always setup to exec it and run an estimated execution plan on it, but if it creates temp tables, you may get false errors.Thu, 20 Dec 2007 13:16:28 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic435362-146-1.aspxHi AllOne question :Is there any method to find out stored procedure is valid or not valid. Please help me Regards,ShineThu, 20 Dec 2007 12:56:59 GMTsps-554505