[SQL Server] Chercher une procédure stockée dans toutes les BD
EXEC sp_MSForEachDB
'USE ?;
SELECT DB_NAME(), ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ''%MaProcedure%''
AND ROUTINE_TYPE = ''PROCEDURE'''
EXEC sp_MSForEachDB
'USE ?;
SELECT DB_NAME(), ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE ''%MaProcedure%''
AND ROUTINE_TYPE = ''PROCEDURE'''