This is a multi-part message in MIME format.

------_=_NextPart_001_01C48E63.5BDF8BE0
Content-Type: text/plain;
	charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit

堀川　様
 
お世話になります。新美です。
ご教授いただきありがとうございました。
 
早速試してみます。
 

________________________________

From: Akira Horikawa [mailto:who@example.ne.jp]
Sent: 2004/08/30 (月) 16:01
To: who@example.ne.jp
Subject: [ml-msde:01356] RE: フィールドの「説明」について



堀川です、こんにちは

-----Original Message-----
From: 新美 正隆 [mailto:who@example.jp]
Sent: Monday, August 30, 2004 3:41 PM
To: who@example.ne.jp
Subject: [ml-msde:01355] フィールドの「説明」について


>EnterpriseManager や Access2002 からSQL Server2000に対して
>フィールド毎に「説明」の項目に任意の文字を登録出来ようになっています。
>プログラムからこれを操作（読み書き）する方法を色々調べたのですが行き詰っ
>ている状況です。

fn_listextendedproperty
sp_addextendedproperty

などを参照下さい


>Transact-SQLのリファレンスを探しましたが見つかりませんでした。
「拡張プロパティ」で、検索して下さい

SQL Server 2000 をお使いであれば、「SQLプロファイラ」が、クライアント
ツールの中に登録されています。

このプロファイラを動かして、Enterprise Managerで適当な操作を実行すると、
Enterprise ManagerがどのようなSQL文やストアドプロシージャを呼び出して
いるのか調査することができます。

ただ時々、Books Online に載っていないストアドプロシージャを呼び出したり
するので、そのような命令は、自己責任の下で、お使い下さい


------------------------------------
（株）日本技術ソフト開発
  　    　堀川　明  (Akira Horikawa)
    ０８月３０日（月曜日）　１６時０１分記
        mailto:who@example.ne.jp
        http://www.horikawa.ne.jp/msde/




------_=_NextPart_001_01C48E63.5BDF8BE0
Content-Type: application/ms-tnef;
	name="winmail.dat"
Content-Transfer-Encoding: base64

eJ8+IhsHAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAApAMAAAAAAACnAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEEgAEANgAAAFJFOiBbbWwtbXNkZTowMTM1
Nl0gUkU6ICCDdINCgVuDi4NogsyBdZDglr6BdoLJgsKCooLEAEsWAQWAAwAOAAAA1AcIAB4AEAAd
AAUAAQA0AQEggAMADgAAANQHCAAeABAAHwAaAAEASwEBCYABACEAAABBRkUzRTdDNkI4Q0UzNzQ4
OTdGQTk5MDRGMTgyMDlERgBtBwEDkAYAjBQAADcAAAADADYAAAAAAEAAOQAgXIgHY47EAR4APQAB
AAAABQAAAFJFOiAAAAAAAgFHAAEAAAAoAAAAYz1KUDthPSA7cD1zM3M7bD1TMy1TMDEtMDQwODMw
MDczMTI2Wi0yAB4ASQABAAAAMgAAAFttbC1tc2RlOjAxMzU2XSBSRTogIIN0g0KBW4OLg2iCzIF1
kOCWvoF2gsmCwoKigsQAAABAAE4AgE02Pl+OxAEeAFoAAQAAAA8AAABBa2lyYSBIb3Jpa2F3YQAA
AgFbAAEAAABBAAAAAAAAAIErH6S+oxAZnW4A3QEPVAIAAAAAQWtpcmEgSG9yaWthd2EAU01UUABh
a2lyYUBob3Jpa2F3YS5uZS5qcAAAAAACAVwAAQAAABoAAABTTVRQOkFLSVJBQEhPUklLQVdBLk5F
LkpQAAAAHgBdAAEAAAAPAAAAQWtpcmEgSG9yaWthd2EAAAIBXgABAAAAQQAAAAAAAACBKx+kvqMQ
GZ1uAN0BD1QCAAAAAEFraXJhIEhvcmlrYXdhAFNNVFAAYWtpcmFAaG9yaWthd2EubmUuanAAAAAA
AgFfAAEAAAAaAAAAU01UUDpBS0lSQUBIT1JJS0FXQS5ORS5KUAAAAB4AZgABAAAABQAAAFNNVFAA
AAAAHgBnAAEAAAAVAAAAYWtpcmFAaG9yaWthd2EubmUuanAAAAAAHgBoAAEAAAAFAAAAU01UUAAA
AAAeAGkAAQAAABUAAABha2lyYUBob3Jpa2F3YS5uZS5qcAAAAAAeAHAAAQAAADIAAABbbWwtbXNk
ZTowMTM1Nl0gUkU6ICCDdINCgVuDi4NogsyBdZDglr6BdoLJgsKCooLEAAAAAgFxAAEAAAAgAAAA
AcSOXEY9HSV5yNFCSvOh1XdmLdplaQAAf1cwAAEw+zgeAHQAAQAAABcAAABtbC1tc2RlQGhvcmlr
YXdhLm5lLmpwAAAeABoMAQAAAAoAAACQVpT8IJCzl7IAAAAeAB0OAQAAADIAAABbbWwtbXNkZTow
MTM1Nl0gUkU6ICCDdINCgVuDi4NogsyBdZDglr6BdoLJgsKCooLEAAAAAgEJEAEAAADdDQAA2Q0A
AL01AABMWkZ1TLp84gMACgByY3BnOTMywQNDaHRtbDEDMAEDnwH3CoACpAPjAgBjaArAQHNldDEy
OAXSTfsLgBDgbwKAD/MAUARWEZ53DkEDARDHMgYABsMSJTNzBEYQxzAgCFUHshIlNCMQXxFhXCc4
DkAnNm8A4BnTAcAZtmYZwRYQJ9Y1G4EbczYbVDYZ8RtyNDRlEiU1GI8RZFVJ4CBHb3RoDeACgBIz
iwjvCfc7IM8yNTUh73chwRIxDGBjAFALCQFkMyY2FzALpTQgD/IqXHsOogGQZxqxCrISMycYNAEV
IDwhRE9DVFkAUEUgSFRNTCAAUFVCTElDICJALS8vVzNDKrBERFREKcQzLjIqsEW4TiI+KB0nvyzx
MRFw3jwp0iw/LU8vwDMmsC6g+EVBRC79DuEwHzKfLiSCNg7gPE1FVEEHsGJBNZA9IkcJ8ASQYYp0
BbAiF0BPTlQsACZUNiAF4UV4EOFuZ3plBlJ2F6E4cQCQAiAgADYuNS42OTQ0nC4wLC4z/y4zNzcp
IKBUSVRMRS7+NA7gIlsOwC1tcwEAOjAUMTMcMF0H8EU6IPsZshuBNxhwHOQcwgBQG6BLDDAbYzhA
tTY4GcRjSxoyQHE3HcAnOQFAJ+cKYELBHEFiZUJFHEJB8i45QcUcwhnxYUU1YzT1LZ41KSAvPH86
ry91PcEvR2Axfy/PSzQ1FzA8QnhPRFlKrSYhS88OEDYBKSBESVYgaWQ9QVAgT1dBUmULUHmgVGV4
dDQxMDgmsNBkaXI9S1BySqBLE30AISAAAFHRCrFSwhDgXP5xAyFSNRcwTY9On0+mUZ/3Uq9Tukrp
NkYwV6lT7y4kS1FQKSBGNwEgZgDQZX82IBnPGt8b7xz0NtAgQz1UIzBiAyAAkHpdsDL3V4sYYAMw
YxQgA7IB0FPJXUNEN0GxQuNCNTRDMjf/XiItrGBQR1FdMleJV5dZ278BwFeXCqJpSAqALawwMUH/
KxBP8GifW89VP1ZPV19Yb/9pf1qPbp9cr12/Xs9f32Dp/2J/Y4RkPWcvaD9ub0slUWHgJm5ic3AC
gGL6ekH8YTBpT2pfa29sf22PgO//b69wv3HPct9z73T/dg93H394L3k/ek97X3xvfX8ZtWF7ZZVF
ojlBsRyzRHpBtWX9QbVkk5UBsGYlmiJC8ZWS/zmAkyAQ0EHFQrGc3H6ff6//g++E/4YPhx+IL5Df
ik+LX/+Mb41/jo+Pn5Cvkb+Sz5Pf35Tvlf+XD5gfGbViHMJAsbcl8LGRQ7FmRDVFpmILMH+cxEOy
RXJAskVyQvGb2mH+YUHFuRY/srfWnOK9lUWm/5yXnya6Ep/voP+iD6MfpC//pT+mT6dfqG+pf6qP
q5+sr/+tv67Pr9+w77H/sw+0H7Uv/7Y/0F/B38gPgW+Cf4OPw///xQ/GH8cv2o/JT8pfy2/Mf//N
j86fz6/Qv9HP0t/T79T//9YP1x9kuEBxQGLzUgDRuLP/9FO/2UYgnDW6FZyfwR/Zn//DP97v3//h
D+If6s/kP+VP/+Zf52/of+mP6p/rr+y/7c//7t/v7/D/8g/Yf/iv/t/br//cv93P+s/73/zv/f8R
XwAfXwEvAj8DT1OvLegxKRFCflIdWRsyJIEfPxrPG9tIRFIgI1BiSW4+UHhYPS0xDSxAcHEJgHFA
alx1bGRiDhB+3CBfJ9InkR6AaTZgFoN/If8jDgUvBj8HTwhaN4FVAEkgR290aGlj/wyvY2NHQA4v
Eg1NEB1bJ4HBMadGcm9tOiQMILFGLzNKFHkgQWsc8GGEIEhhwGlrYXc4ECdJTCOVPfBhaUtQbzpS
YTfiQGg4RS4ogC74anBdH81PsSDsKGIo/4cyjzOfPqJTZW50NS8PNj83R2RQGGAvMDgvmjMpkCgJ
EfQjKSA8wPg6MDE77zz/Pg8/H0Av/UjUVDpwQe9C/zdWOM8jwvEhUC1tcyWQOu1GP0dPj0hfSW9K
f0E1dWJqZgC/Qc9NDzc4OhBQFEYBMwuA4F0gUkU6Tq8jswqk3je+kmEiuBLzYTW7EgsS1V41Npwl
Y2YVN58hZcP/ZpILkbqDX/K5FZsXmqW/Bv/1kFFvUn9Tjw9fEG9mT2Rf/2VvFN8V7xb/GA9oby0O
b9//cO8p/yQPcuwsf3TfKwtysP5QIQ+YmXc/LQ8INi/fE/H78l8LkTeZpVdQnr/3RPNib5zig8Um
wZrLYgqSmuJkv2mfaq9l74aPh5+IqS2MUipPOFBnKHBhHwBNZfRzczlwZYxTiV+Kb4h83zTj8yKd
65FFuII59yG4AAtaIFRvQXlEaHJlZgMu0DolbmlpbWlAKHMzczuhIg0saWUbJ2BbkmYnYChwc3R7
AEhZUEVSTElObEsglV+WYn0q8ZgBcvJzOVBcYybBJ1AxiZk/3zuwcz98WnPPV/pBjzA73y+O/4ht
QZONIG8lgGF5oiw3wHVndZhQIEUAX6UQW395ckSCpZA6g7Ag/FBNoV+ib4h8S+GcMFAf31EvqM+p
31cHWiw1WxCl7/9cj12fXq9fv2DPYd9i76zP/63fiK+537rvu/+9D74fvy+pErNndBNJPsHYRUGw
hmUeQDhQc2VNYYzw142AdZAJFGUKAEG1UI1BC0SBCgZhhUVlN1NRzkyxH3ljQZBydsUwRIH/tmGE
9vNSLrD0vr9/wI/Bn3/Cr8O/8vSyn7OvtLS2kjj/tOaFQrWvtr+1RPYi1pWk4NvKmfWhNAsSgcFk
CxK1Jdo59SFiC5LLgTnZFXgw1/MxC9IKkTmBwTXLggqR190D9yK05WW3ZWH1pbfX/7TmhMb1pbjW
9p/3rc1/zo9/z5/Qr9G8C5XYQwxSCpU434VCCxLKhcfIg9xl3BrzYm/KgvYhgjPzYTbLAgxRY//s
pfYT3RKDxSVQ7zXZFeMDt8ZSywL1IWa0YdbCNMqF+9yD1pE0C5LTUoHChALiFn/spuoitSaCjrii
2RLqITf/2pXxk7RhCXbhAOOv5L/lz//m3+fv0eXhX/L03cIUErRS/8v3gs7jn/w//U8E7wX/Bwr4
Zm5fKGCYUCWgxSAlgZJkxVBvcMUwdHkHz+cI3wbsEyBfYfCQCz8MT/8NXwb/EN8R7wAvtObspdyC
bdvCNfEi6qFj6aKFQWL/8ib5pgS/FJ8Srxq/G88c398d7x7/IA/+v8QOVDgAmED5LqB0LchhtPna
EtkS0lr/yoLaEidV3MK0kvWS3EfTEf4135XL9uKHgsb3JfkT4pH/x8a4V8fWtOXih4VFhLeCxn8s
2gR/IV8ib9ID1dUnwjZbBDH10mEp1emeNyjVNv+CwtLZt1eCwoOG2xLqouoh/mYx3eGDGU8aXzQ/
NU8gj+9Ab6NuyH/JiyDKUkWfsiZ/F8a4orTiy4E3QribgsVh/8qF7ZbLc4OG1dMmtDgfKC//2fTq
5rcp+RODhupiy4Lq6f9QllKWKcY3QEJvQ381j7Si/9oS017a1tMSt2nczz6ZTGf/4Z8Dz1XPVt9B
n2B/YY8V/r/tFidGTp9Pr+q53Flhy4X/x8Y9S4ODxQhHr3ljxaUDSP1b0jTzopLSt2aBwu5uF8n+
Y+6l+ZbymrUT9SWDsGM//2RPYlxtP25Pb1n5ExdJ95b93w84JrPbR8ZTKelVY1Q877TTZ2+RlFla
NYC1tBMXxvtfIV4WZBiF3QLLv3Zfd2+/ZY8Bq/dpx8L11+ohYrTl/3SOZpdRqks6WiVfH2AviM//
Yk+S75P/ig/3B9cD29K25QMqQ1JjQm9va3Mg/E9ulMJ5z0i5t9PqIdkH/+Ef4Cy403//gQ+CH4Mv
hD//hU+GX/baL8CVz5bfl++N///3fVJm9eJaKX0/cVbW0uoh9d5CZIa1YzLW8SLLgcfD/6aScZLW
kdqC2ceL9j4Zrk7/Se/TEj4fPy+qP6tPlb+7b2+8f72Pvp+/qi3Db8R/Lf/Ab8F/q4/vZSfC2cLx
1lvS1mbJUumhN/olNdkSp5G9OUY1ZybSlUpjNxE0yVWfD2DFr8a/v48jzG5iDzD/JMnOwAKiS+Ak
18BAnA+dFv1SYjDRr9K/08/Wv9fP2N//2e/a/9wPNlX0EsrDtFXvFh/gtpmg3R/eL98/IChBRGtp
JjAgSG95gGvwYXdhKc6vz7/Qz+MP/+Qf3D/qT+tf7G/tf+6P0/971Q+dRjSGtaVDkbJrJTX/SvX1
YspGyMf2NbICygrJxv/gdvWj+vYDspn29TpqonAR8y3DWaE0Y+cf6C/pP/Cv//G/758BvwLPA98E
7wX/Bw//CB8JLwo/C08MXw1vDn8Pj58QnxGvEr/yzyO8PEGc9ABocmVmPSJtYSJpJCBvOmHmMkBo
heaVLgCgLmpwIv/JoRahaWVsZP6iZhyAAQCQc3R7SFlQRcBSTElOSyAZvxrKTH19FqEcgHJzJCBc
8mMxQXVsAGAUFx4fGtg/JOcXKSNfwD4rAP+AL0H//8D+j/+fAK8U3xXvE88qX/8rbyx/LY8uny+v
ML8xzzLf/zPvNP82DzcfOC85PzpPO18/Fv/z33sAF+8Y+yiQdHBQOi8vd0QgLhqcL+Btc2RlLxt/
HI8dlv9Dv0TNH98g6khPRMwknyRv/zzvJo8nnyivUB9Sf1OPVJ+GMaRAUXFGT05UVhn/Tp9XkHrC
P8hXGJzzVx/0Bio3UWJQUb4wGMEvROxJVllPXW9nyIFBj2KPhz3DoUBRcUJPRFlRvRdRYGQPZpE3
UXFIVE0KTFYQfWjAAAAAHgA1EAEAAAA6AAAAPDY5MzNGMjk3QkZBQUYyNDhCRDVBQzE2REMyNEZE
MjgwMDMyMzBFQHMzLXMwMS5zM3MubG9jYWw+AAAAHgBHEAEAAAAPAAAAbWVzc2FnZS9yZmM4MjIA
AAsA8hABAAAAHwDzEAEAAABkAAAAUgBFACUAMwBBACAAWwBtAGwALQBtAHMAZABlACUAMwBBADAA
MQAzADUANgBdACAAUgBFACUAMwBBACAAIADVMKMw/DDrMMkwbjAMMKyKDmYNMGswZDBEMGYwLgBF
AE0ATAAAAAsA9hAAAAAAQAAHMMb5hQdjjsQBQAAIMO6y5ltjjsQBAwDePyzEAAADAPE/EQQAAB4A
+D8BAAAACgAAAJBWlPwgkLOXsgAAAAIB+T8BAAAAQQAAAAAAAADcp0DIwEIQGrS5CAArL+GCAQAA
AAAAAAAvTz1TM1MvT1U9UzNTL0NOPVJFQ0lQSUVOVFMvQ049TklJTUkAAAAAHgD6PwEAAAAVAAAA
U3lzdGVtIEFkbWluaXN0cmF0b3IAAAAAAgH7PwEAAAAeAAAAAAAAANynQMjAQhAatLkIACsv4YIB
AAAAAAAAAC4AAAADAP0/pAMAAAMAGUAAAAAAAwAaQAAAAAADAB1AAAAAAAMAHkAAAAAAHgAwQAEA
AAAGAAAATklJTUkAAAAeADFAAQAAAAYAAABOSUlNSQAAAB4AMkABAAAAFQAAAGFraXJhQGhvcmlr
YXdhLm5lLmpwAAAAAB4AM0ABAAAAFQAAAGFraXJhQGhvcmlrYXdhLm5lLmpwAAAAAB4AOEABAAAA
BgAAAE5JSU1JAAAAHgA5QAEAAAACAAAALgAAAAMAdkD/////CwApAAAAAAALACMAAAAAAAMABhBR
4CYTAwAHEHkFAAADABAQAAAAAAMAERAAAAAAHgAIEAEAAABlAAAAJEJLWUBOTU0oSiRCJCpAJE9D
JEskSiRKJCQ5Iz83SCRHJDkjKEokQiQ0NjU8WCQkJD8kQCQtJCIkSiQsJEgkJiQ0JDYkJCQkNyQ/
IyhKJEJBQUI7TiQ3JEYkJCQ5IyhKRlJPTQAAAAACAX8AAQAAADoAAAA8NjkzM0YyOTdCRkFBRjI0
OEJENUFDMTZEQzI0RkQyODAwMzIzMEVAczMtczAxLnMzcy5sb2NhbD4AAAAixQ==

------_=_NextPart_001_01C48E63.5BDF8BE0--