Wednesday, July 18, 2007

Read the content of the storedprocedure by sql query

Read the content of the stored procedure by sql query


Get the list of the store procedure

SELECT * FROM sysobjects WHERE type = 'P' AND category = 0 ORDER BY name

Get the content of the stored procedure by specifying the name

SELECT text FROM syscomments WHERE id = (SELECT id FROM sysobjects WHERE name = 'my_StoreProcedureName') ORDER BY colid