freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
- From: "Lowden, James K" <LowdenJK AT bernstein.com>
- To: "TDS Development Group" <freetds AT lists.ibiblio.org>
- Subject: [freetds] bcp timestamp trace
- Date: Mon, 5 Apr 2004 18:21:04 -0400
Attached for future reference is a perfect tcpdump trace of a short session
using BCP.EXE to load four rows into a Microsoft SQL Server 7.0 table.
Notes:
1. To get the metadata, does:
SET FMTONLY ON
select * from dbname..tablename
SET FMTONLY OFF
Might be more efficient than "where 0=1".
2. "insert bulk dbname..tablename (ts int)".
The DDL for the table:
CREATE TABLE ts (ts int, cc timestamp)
So (in contradiction to comments I just committed), the timestamp column is
simply omitted from the query. I guess the server does the magic.
--jkl
<<ts.windump.txt>>
-----------------------------------------
The information contained in this transmission may contain privileged and
confidential information and is intended only for the use of the person(s)
named above. If you are not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, any
review, dissemination, distribution or duplication of this communication is
strictly prohibited. If you are not the intended recipient, please contact
the sender immediately by reply e-mail and destroy all copies of the original
message. Please note that we do not accept account orders and/or instructions
by e-mail, and therefore will not be responsible for carrying out such orders
and/or instructions.
If you, as the intended recipient of this message, the purpose of which is to
inform and update our clients, prospects and consultants of developments
relating to our services and products, would not like to receive further
e-mail correspondence from the sender, please "reply" to the sender
indicating your wishes. In the U.S.: 1345 Avenue of the Americas, New York,
NY 10105.
17:51:33.918090 10.80.58.175.2500 > 10.81.36.40.2192: P 66:470(404) ack 381
win 8380 (DF)
0x0000 4500 01bc 6c05 4000 7e06 1bbf 0a50 3aaf E...l.@.~....P:.
0x0010 0a51 2428 09c4 0890 0207 7ad5 0039 eeb1 .Q$(......z..9..
0x0020 5018 20bc ee67 0000 0401 0194 0000 0000 P....g..........
0x0030 e31b 0001 0674 0065 0073 0074 0064 0062 .....t.e.s.t.d.b
0x0040 0006 6d00 6100 7300 7400 6500 7200 ab64 ..m.a.s.t.e.r..d
0x0050 0045 1600 0002 0025 0043 0068 0061 006e .E.....%.C.h.a.n
0x0060 0067 0065 0064 0020 0064 0061 0074 0061 .g.e.d...d.a.t.a
0x0070 0062 0061 0073 0065 0020 0063 006f 006e .b.a.s.e...c.o.n
0x0080 0074 0065 0078 0074 0020 0074 006f 0020 .t.e.x.t...t.o..
0x0090 0027 0074 0065 0073 0074 0064 0062 0027 .'.t.e.s.t.d.b.'
0x00a0 002e 0007 4e00 5400 5300 3000 3100 3900 ....N.T.S.0.1.9.
0x00b0 3800 0000 00e3 1700 020a 7500 7300 5f00 8.........u.s._.
0x00c0 6500 6e00 6700 6c00 6900 7300 6800 00ab e.n.g.l.i.s.h...
0x00d0 6800 4716 0000 0100 2700 4300 6800 6100 h.G.....'.C.h.a.
0x00e0 6e00 6700 6500 6400 2000 6c00 6100 6e00 n.g.e.d...l.a.n.
0x00f0 6700 7500 6100 6700 6500 2000 7300 6500 g.u.a.g.e...s.e.
0x0100 7400 7400 6900 6e00 6700 2000 7400 6f00 t.t.i.n.g...t.o.
0x0110 2000 7500 7300 5f00 6500 6e00 6700 6c00 ..u.s._.e.n.g.l.
0x0120 6900 7300 6800 2e00 074e 0054 0053 0030 i.s.h....N.T.S.0
0x0130 0031 0039 0038 0000 0000 e30f 0003 0569 .1.9.8.........i
0x0140 0073 006f 005f 0031 0001 0100 e30d 0005 .s.o._.1........
0x0150 0533 0033 0032 0038 0030 0000 e305 0006 .3.3.2.8.0......
0x0160 0130 0000 ad36 0001 0700 0000 164d 0069 .0...6.......M.i
0x0170 0063 0072 006f 0073 006f 0066 0074 0020 .c.r.o.s.o.f.t..
0x0180 0053 0051 004c 0020 0053 0065 0072 0076 .S.Q.L...S.e.r.v
0x0190 0065 0072 0000 0000 0007 0004 46e3 1300 .e.r........F...
0x01a0 0404 3400 3000 3900 3600 0434 0030 0039 ..4.0.9.6..4.0.9
0x01b0 0036 00fd 0000 0000 0000 0000 .6..........
17:51:33.920148 10.81.36.40.2192 > 10.80.58.175.2500: P 381:441(60) ack 470
win 8291 (DF)
0x0000 4500 0064 7875 4000 8006 0ea7 0a51 2428 E..dxu@......Q$(
0x0010 0a50 3aaf 0890 09c4 0039 eeb1 0207 7c69 .P:......9....|i
0x0020 5018 2063 9ebf 0000 0101 003c 0000 0100 P..c.......<....
0x0030 2000 7300 6500 7400 2000 7100 7500 6f00 ..s.e.t...q.u.o.
0x0040 7400 6500 6400 5f00 6900 6400 6500 6e00 t.e.d._.i.d.e.n.
0x0050 7400 6900 6600 6900 6500 7200 2000 6f00 t.i.f.i.e.r...o.
0x0060 6600 6600 f.f.
17:51:33.920738 10.80.58.175.2500 > 10.81.36.40.2192: P 470:487(17) ack 441
win 8320 (DF)
0x0000 4500 0039 6d05 4000 7e06 1c42 0a50 3aaf E..9m.@.~..B.P:.
0x0010 0a51 2428 09c4 0890 0207 7c69 0039 eeed .Q$(......|i.9..
0x0020 5018 2080 99b9 0000 0401 0011 0000 0000 P...............
0x0030 fd00 00fd 000f 0000 00 .........
17:51:33.924432 10.81.36.40.2192 > 10.80.58.175.2500: P 441:559(118) ack 487
win 8274 (DF)
0x0000 4500 009e 7975 4000 8006 0d6d 0a51 2428 E...yu@....m.Q$(
0x0010 0a50 3aaf 0890 09c4 0039 eeed 0207 7c7a .P:......9....|z
0x0020 5018 2052 b008 0000 0101 0076 0000 0100 P..R.......v....
0x0030 5300 4500 5400 2000 4600 4d00 5400 4f00 S.E.T...F.M.T.O.
0x0040 4e00 4c00 5900 2000 4f00 4e00 2000 7300 N.L.Y...O.N...s.
0x0050 6500 6c00 6500 6300 7400 2000 2a00 2000 e.l.e.c.t...*...
0x0060 6600 7200 6f00 6d00 2000 7400 6500 7300 f.r.o.m...t.e.s.
0x0070 7400 6400 6200 2e00 2e00 7400 7300 2000 t.d.b.....t.s...
0x0080 5300 4500 5400 2000 4600 4d00 5400 4f00 S.E.T...F.M.T.O.
0x0090 4e00 4c00 5900 2000 4f00 4600 4600 N.L.Y...O.F.F.
17:51:33.925016 10.80.58.175.2500 > 10.81.36.40.2192: P 487:547(60) ack 559
win 8202 (DF)
0x0000 4500 0064 7805 4000 7e06 1117 0a50 3aaf E..dx.@.~....P:.
0x0010 0a51 2428 09c4 0890 0207 7c7a 0039 ef63 .Q$(......|z.9.c
0x0020 5018 200a f453 0000 0401 003c 0000 0000 P....S.....<....
0x0030 fd01 00b9 0000 0000 0081 0200 0000 0800 ................
0x0040 3802 7400 7300 5000 0000 ad08 0002 6300 8.t.s.P.......c.
0x0050 6300 fd01 00c1 0000 0000 00fd 0000 ba00 c...............
0x0060 0000 0000 ....
17:51:33.976404 10.81.36.40.2192 > 10.80.58.175.2500: P 559:677(118) ack 547
win 8214 (DF)
0x0000 4500 009e 9375 4000 8006 f36c 0a51 2428 E....u@....l.Q$(
0x0010 0a50 3aaf 0890 09c4 0039 ef63 0207 7cb6 .P:......9.c..|.
0x0020 5018 2016 cf92 0000 0101 0076 0000 0100 P..........v....
0x0030 5300 4500 5400 2000 4600 4d00 5400 4f00 S.E.T...F.M.T.O.
0x0040 4e00 4c00 5900 2000 4f00 4e00 2000 5300 N.L.Y...O.N...S.
0x0050 6500 6c00 6500 6300 7400 2000 2a00 2000 e.l.e.c.t...*...
0x0060 6600 7200 6f00 6d00 2000 7400 6500 7300 f.r.o.m...t.e.s.
0x0070 7400 6400 6200 2e00 2e00 7400 7300 2000 t.d.b.....t.s...
0x0080 5300 4500 5400 2000 4600 4d00 5400 4f00 S.E.T...F.M.T.O.
0x0090 4e00 4c00 5900 2000 4f00 4600 4600 N.L.Y...O.F.F.
17:51:33.977563 10.80.58.175.2500 > 10.81.36.40.2192: P 547:607(60) ack 677
win 8084 (DF)
0x0000 4500 0064 d005 4000 7e06 b916 0a50 3aaf E..d..@.~....P:.
0x0010 0a51 2428 09c4 0890 0207 7cb6 0039 efd9 .Q$(......|..9..
0x0020 5018 1f94 f417 0000 0401 003c 0000 0000 P..........<....
0x0030 fd01 00b9 0000 0000 0081 0200 0000 0800 ................
0x0040 3802 7400 7300 5000 0000 ad08 0002 6300 8.t.s.P.......c.
0x0050 6300 fd01 00c1 0000 0000 00fd 0000 ba00 c...............
0x0060 0000 0000 ....
17:51:33.985224 10.81.36.40.2192 > 10.80.58.175.2500: P 677:745(68) ack 607
win 8154 (DF)
0x0000 4500 006c 9575 4000 8006 f19e 0a51 2428 E..l.u@......Q$(
0x0010 0a50 3aaf 0890 09c4 0039 efd9 0207 7cf2 .P:......9....|.
0x0020 5018 1fda a986 0000 0101 0044 0000 0100 P..........D....
0x0030 6900 6e00 7300 6500 7200 7400 2000 6200 i.n.s.e.r.t...b.
0x0040 7500 6c00 6b00 2000 7400 6500 7300 7400 u.l.k...t.e.s.t.
0x0050 6400 6200 2e00 2e00 7400 7300 2800 7400 d.b.....t.s.(.t.
0x0060 7300 2000 6900 6e00 7400 2900 s...i.n.t.).
17:51:33.986436 10.80.58.175.2500 > 10.81.36.40.2192: P 607:624(17) ack 745
win 8016 (DF)
0x0000 4500 0039 e205 4000 7e06 a741 0a50 3aaf E..9..@.~..A.P:.
0x0010 0a51 2428 09c4 0890 0207 7cf2 0039 f01d .Q$(......|..9..
0x0020 5018 1f50 9979 0000 0401 0011 0000 0000 P..P.y..........
0x0030 fd00 00c3 0000 0000 00 .........
17:51:33.986760 10.81.36.40.2192 > 10.80.58.175.2500: P 745:782(37) ack 624
win 8137 (DF)
0x0000 4500 004d 9675 4000 8006 f0bd 0a51 2428 E..M.u@......Q$(
0x0010 0a50 3aaf 0890 09c4 0039 f01d 0207 7d03 .P:......9....}.
0x0020 5018 1fc9 5753 0000 0701 0025 0000 0100 P...WS.....%....
0x0030 8101 0000 0008 0026 0402 7400 7300 d104 .......&..t.s...
0x0040 0100 0000 fd00 0000 0000 0000 00 .............
17:51:34.107062 10.80.58.175.2500 > 10.81.36.40.2192: . ack 782 win 7979 (DF)
0x0000 4500 0028 a806 4000 7e06 e151 0a50 3aaf E..(..@.~..Q.P:.
0x0010 0a51 2428 09c4 0890 0207 7d03 0039 f042 .Q$(......}..9.B
0x0020 5010 1f2b 9b57 0000 0000 0000 0000 P..+.W........
17:51:34.111212 10.80.58.175.2500 > 10.81.36.40.2192: P 624:641(17) ack 782
win 7979 (DF)
0x0000 4500 0039 af06 4000 7e06 da40 0a50 3aaf E..9..@.~..@.P:.
0x0010 0a51 2428 09c4 0890 0207 7d03 0039 f042 .Q$(......}..9.B
0x0020 5018 1f2b 992a 0000 0401 0011 0000 0000 P..+.*..........
0x0030 fd10 00f0 0001 0000 00 .........
17:51:34.126552 10.81.36.40.2192 > 10.80.58.175.2500: F 782:782(0) ack 641
win 8120 (DF)
0x0000 4500 0028 9875 4000 8006 eee2 0a51 2428 E..(.u@......Q$(
0x0010 0a50 3aaf 0890 09c4 0039 f042 0207 7d14 .P:......9.B..}.
0x0020 5011 1fb8 9ab8 0000 P.......
17:51:34.126807 10.80.58.175.2500 > 10.81.36.40.2192: . ack 783 win 7979 (DF)
0x0000 4500 0028 c606 4000 7e06 c351 0a50 3aaf E..(..@.~..Q.P:.
0x0010 0a51 2428 09c4 0890 0207 7d14 0039 f043 .Q$(......}..9.C
0x0020 5010 1f2b 9b45 0000 0000 0000 0000 P..+.E........
17:51:34.162621 10.80.58.175.2500 > 10.81.36.40.2192: F 641:641(0) ack 783
win 7979 (DF)
0x0000 4500 0028 0707 4000 7e06 8251 0a50 3aaf E..(..@.~..Q.P:.
0x0010 0a51 2428 09c4 0890 0207 7d14 0039 f043 .Q$(......}..9.C
0x0020 5011 1f2b 9b44 0000 0000 0000 0000 P..+.D........
17:51:34.162818 10.81.36.40.2192 > 10.80.58.175.2500: . ack 642 win 8120 (DF)
0x0000 4500 0028 aa75 4000 8006 dce2 0a51 2428 E..(.u@......Q$(
0x0010 0a50 3aaf 0890 09c4 0039 f043 0207 7d15 .P:......9.C..}.
0x0020 5010 1fb8 9ab7 0000 P.......
-
[freetds] bcp timestamp trace,
Lowden, James K, 04/05/2004
- Re: [freetds] bcp timestamp trace, James K. Lowden, 04/07/2004
- <Possible follow-up(s)>
- RE: [freetds] bcp timestamp trace, ZIGLIO, Frediano, VF-IT, 04/06/2004
-
RE: [freetds] bcp timestamp trace,
Thompson, Bill D (London), 04/13/2004
- RE: [freetds] bcp timestamp trace, Frediano Ziglio, 04/13/2004
- RE: [freetds] bcp timestamp trace, Lowden, James K, 04/13/2004
- RE: [freetds] bcp timestamp trace, Lowden, James K, 04/13/2004
- RE: [freetds] bcp timestamp trace, Lowden, James K, 04/13/2004
- RE: [freetds] bcp timestamp trace, Thompson, Bill D (London), 04/14/2004
- RE: [freetds] bcp timestamp trace, Lowden, James K, 04/14/2004
Archive powered by MHonArc 2.6.24.