获取当前数据库中所有的用户存储过程名称

[sql]代码库

	SELECT sp.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) = 0
				)
			)