2005-08-30

Visa alla stored procedures i SQL-server

Hittade en liten artikel här om hur man listar alla stored procedures i en SQL-server databas.
I korthet ser det ut så här:


SELECT
ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND OBJECTPROPERTY
(
OBJECT_ID(ROUTINE_NAME),
'IsMsShipped'
) = 0
ORDER BY ROUTINE_NAME