FreeTDS Development Group

[Frediano Ziglio <freddyz77 AT tin.it>]

Il sab, 2003-02-22 alle 20:36, Brian Bruns ha scritto:
> I believe that is used for rpc (server to server) connections right?  
> Sybase has those zeroed in client-to-server streams i believe. Perhaps, MS 
> has them on all the time?
> 
> Brian
> 

I tested today with a mssql2k server.
These are the results of 3 connect to same server (same using TDS7 and TDS8)

Sending packet @ 2003-02-23 12:34:44.325524
0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |...".... s.e.l.e.|
0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@. @.s.p.i.|
0020  64 00                                              |d.|


Received header @ 2003-02-23 12:34:44.326833
0000  04 01 00 1d 00 39 01 00                            |.....9..|


Received packet @ 2003-02-23 12:34:44.326954
0000  81 01 00 00 00 00 00 34  00 d1 39 00 fd 10 00 c1   |.......4 .Ñ9.ý..Á|
0010  00 01 00 00 00                                     |.....|

--------------------

Sending packet @ 2003-02-23 12:34:51.329333
0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |...".... s.e.l.e.|
0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@. @.s.p.i.|
0020  64 00                                              |d.|


Received header @ 2003-02-23 12:34:51.330488
0000  04 01 00 1d 00 3a 01 00                            |.....:..|


Received packet @ 2003-02-23 12:34:51.330607
0000  81 01 00 00 00 00 00 34  00 d1 3a 00 fd 10 00 c1   |.......4 .Ñ:.ý..Á|
0010  00 01 00 00 00                                     |.....|

--------------------

Sending packet @ 2003-02-23 12:34:36.002745
0000  01 01 00 22 00 00 01 00  73 00 65 00 6c 00 65 00   |...".... s.e.l.e.|
0010  63 00 74 00 20 00 40 00  40 00 73 00 70 00 69 00   |c.t. .@. @.s.p.i.|
0020  64 00                                              |d.|


Received header @ 2003-02-23 12:34:36.003946
0000  04 01 00 1d 00 38 01 00                            |.....8..|


Received packet @ 2003-02-23 12:34:36.004067
0000  81 01 00 00 00 00 00 34  00 d1 38 00 fd 10 00 c1   |.......4 .Ñ8.ý..Á|
0010  00 01 00 00 00                                     |.....|

Same server using TDS 4.2

Sending packet @ 2003-02-23 12:38:06.218249
0000  01 01 00 15 00 00 00 00  73 65 6c 65 63 74 20 40   |........ select @|
0010  40 73 70 69 64                                     |@spid|


Received header @ 2003-02-23 12:38:06.220349
0000  04 01 00 20 00 39 01 00                            |... .9..|


Received packet @ 2003-02-23 12:38:06.220462
0000  a0 01 00 00 a1 05 00 06  00 00 00 34 d1 39 00 fd   | ...¡... ...4Ñ9.ý|
0010  10 00 c1 00 01 00 00 00                            |..Á.....|

-------------------

Sending packet @ 2003-02-23 12:37:58.342963
0000  01 01 00 15 00 00 00 00  73 65 6c 65 63 74 20 40   |........ select @|
0010  40 73 70 69 64                                     |@spid|


Received header @ 2003-02-23 12:37:58.344814
0000  04 01 00 20 00 38 01 00                            |... .8..|


Received packet @ 2003-02-23 12:37:58.344937
0000  a0 01 00 00 a1 05 00 06  00 00 00 34 d1 38 00 fd   | ...¡... ...4Ñ8.ý|
0010  10 00 c1 00 01 00 00 00                            |..Á.....|

-------------------

Sending packet @ 2003-02-23 12:38:13.327598
0000  01 01 00 15 00 00 00 00  73 65 6c 65 63 74 20 40   |........ select @|
0010  40 73 70 69 64                                     |@spid|


Received header @ 2003-02-23 12:38:13.329532
0000  04 01 00 20 00 3a 01 00                            |... .:..|


Received packet @ 2003-02-23 12:38:13.329680
0000  a0 01 00 00 a1 05 00 06  00 00 00 34 d1 3a 00 fd   | ...¡... ...4Ñ:.ý|
0010  10 00 c1 00 01 00 00 00                            |..Á.....|

You can note in every packet headers

04 01 00 20 00 3a 01 00
            ^^ ^^ same as @@spid

If someone can test same behavior with mssql7 or former...

freddy77