====== ストアドプロシージャ一覧の取得 ======
コマンド:
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 行処理されました)