tag:blogger.com,1999:blog-6357505892638015674.post7129958179764961780..comments2023-12-11T22:43:08.539-08:00Comments on Welcome to SQLServer MVP Blog: Finding text in the stored procedureUnknownnoreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6357505892638015674.post-56440250242853087862010-03-08T20:07:54.744-08:002010-03-08T20:07:54.744-08:00There is one problem with this code...
SELECT *
F...There is one problem with this code...<br /><br />SELECT *<br />FROM sys.procedures<br />WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%Venkat_Table%' <br /><br />If the "Venkat_Table" is as Text comment in any other procedure, the it's name will come in the result set (even though table is not used).<br /><br />Is there any other to find "Table used in SP"?<br /><br />Pradeep.<br />ypradeep23@hotmail.comAnonymousnoreply@blogger.com