ストアドプロシージャ一覧の取得

コマンド:

SELECT name, crdate FROM sysobjects WHERE TYPE='P' ORDER BY name;

処理結果:

name                                         crdate
-------------------------------------------- -----------------------
sp_ActiveDirectory_Obj                       2008-07-09 16:45:20.407
sp_ActiveDirectory_SCP                       2008-07-09 16:45:19.987
sp_ActiveDirectory_Start                     2008-07-09 16:45:19.597
sp_add_agent_parameter                       2008-07-09 16:33:33.370
sp_add_agent_profile                         2008-07-09 16:33:31.903
～省略～
sp_who                                       2008-07-09 16:26:49.040
sp_who2                                      2008-07-09 16:26:49.603
sp_xml_schema_rowset                         2008-07-09 16:29:43.230
sp_xml_schema_rowset2                        2008-07-09 16:29:43.760
xp_grantlogin                                2008-07-09 16:27:26.120
xp_logininfo                                 2008-07-09 16:21:45.600
xp_repl_convert_encrypt_sysadmin_wrapper     2008-07-09 16:30:22.620
xp_revokelogin                               2008-07-09 16:27:27.010

(1348 行処理されました)