獲取SQLServer數(shù)據(jù)庫中所有的用戶存儲過程

SELECT SCHEMA_NAME(sp.schema_id) AS [Schema],sp.name AS [Name] FROM sys.all_objects AS sp
WHERE
(sp.type = N'P' OR sp.type = N'RF' OR sp.type=N'PC')and(CAST(
 case 
 WHEN sp.is_ms_shipped = 1 THEN 1
 WHEN (
 SELECT 
 major_id 
 FROM 
 sys.extended_properties
 WHERE 
 major_id = sp.object_id and 
 minor_id = 0 and 
 class = 1 and 
 name = N'microsoft_database_tools_support') 
 IS NOT NULL THEN 1
 ELSE 0
END AS bit)=N'0')
ORDER BY [Schema] ASC,[Name] ASC
?
?
?