Peter Petrov (10/15/2010)
Nice finding! Good to know...The script could be simplified (2005 and 2008):
SELECTOBJECT_NAME(object_id) AS proc_name
,object_id
,definition
FROMsys.sql_modules
WHEREPATINDEX('%CREATE%PROCEDURE%',definition) > 0
ANDPATINDEX('%' + OBJECT_NAME(object_id) + '%', definition) = 0
ORDERBY OBJECT_NAME(object_id);
Thanks Peter,
Yes you are right. As mentioned in the article in 2005 and 2008 you don't have the problem of record size limitation therefore it is much easier to extract the rouge procedures.
Moe M
Database Consultant
http://www.cubeangle.com