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:
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

0 Comments:
Skicka en kommentar
<< Home