SELECT * — Stored Procs
FROM sysobjects so INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.Id
WHERE objectproperty( so.id, N’IsMSShipped’ ) = 0
AND objectproperty( so.id, N’IsProcedure’ ) = 1
AND SC.Text LIKE ‘%
FROM @XMLString.nodes(//MingleEvents) tab(col) %’
===============================================================
SELECT * — Stored Procs
FROM sysobjects so INNER JOIN syscomments SC (NOLOCK) on SO.Id = SC.Id
WHERE objectproperty( so.id, N’IsMSShipped’ ) = 0
AND objectproperty( so.id, N’IsProcedure’ ) = 1
AND SC.Text LIKE ‘%select%’
SELECT ROUTINE_NAME, ROUTINE_DEFINITION
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ‘%INSERT INTO dbo.matrixMasterSCAC%’
AND ROUTINE_TYPE=’PROCEDURE’
Advertisement
