[freetds] bcp timestamp trace

Lowden, James K LowdenJK at bernstein.com
Mon Apr 5 18:21:04 EDT 2004


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.

-------------- next part --------------
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. at .~....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 at ......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. at .~..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 at ....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. at .~....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 at ....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.. at .~....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 at ......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.. at .~..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 at ......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..(.. at .~..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.. at .~.. at .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 at ......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..(.. at .~..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..(.. at .~..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 at ......Q$(
0x0010	 0a50 3aaf 0890 09c4 0039 f043 0207 7d15	.P:......9.C..}.
0x0020	 5010 1fb8 9ab7 0000                    	P.......


More information about the FreeTDS mailing list