Skip to content

Instantly share code, notes, and snippets.

@tromboneamafone

tromboneamafone/priorJuly

Created November 27, 2012 02:03
Show Gist options
  • Save tromboneamafone/4151932 to your computer and use it in GitHub Desktop.
Save tromboneamafone/4151932 to your computer and use it in GitHub Desktop.
Download ZIP
tedious debug info
Raw
priorJuly
connected to 192.168.0.113:1433
Sent
type:0x12(PRELOGIN), status:0x01(EOM), length:0x002F, spid:0x0000, packetId:0x01, window:0x00
0000 00001A00 06010020 00010200 21000103 00220004 04002600 01FF0000 00010001 ....... ....!... ."....&. ........
0020 02000000 000000 .......
PreLogin - version:0.0.0.1 1, encryption:0x02(NOT_SUP), instopt:0x00, threadId:0x00000000, mars:0x00(OFF)
State change: Connecting -> SentPrelogin
Received
type:0x04(TABULAR_RESULT), status:0x01(EOM), length:0x002B, spid:0x0000, packetId:0x01, window:0x00
0000 00001A00 06010020 00010200 21000103 00220000 04002200 01FF0900 05770000 ....... ....!... ."....". .....w..
0020 020000 ...
PreLogin - version:9.0.5.119 0, encryption:0x02(NOT_SUP), instopt:0x00, threadId:0x00000000, mars:0x00(OFF)
Sent
type:0x10(LOGIN7), status:0x01(EOM), length:0x00BA, spid:0x0000, packetId:0x01, window:0x00
0000 B2000000 02000972 00100000 00000000 18110000 00000000 A0000008 68010000 .......r........ ........ ....h...
0020 09040000 5E000F00 7C000600 88000700 96000700 A4000000 A4000000 A4000700 ....^... |....... ........ ........
0040 B2000000 B2000000 01020304 0506B200 0000B200 0000B200 00000000 00006500 ........ ........ ........ ......e.
0060 6E007200 67002D00 38003700 33003600 38006400 38006400 63003600 62006100 n.r.g.-. 8.7.3.6. 8.d.8.d. c.6.b.a.
0080 6C006C00 65007200 81A533A5 82A5E3A5 33A5F3A5 86A55400 65006400 69006F00 l.l.e.r. ..3..... 3.....T. e.d.i.o.
00A0 75007300 54006500 64006900 6F007500 7300 u.s.T.e. d.i.o.u. s.
Login7 - TDS:0x72090002, PacketSize:0x00001000, ClientProgVer:0x00000000, ClientPID:0x00001118, ConnectionID:0x00000000
Flags1:0xA0, Flags2:0x00, TypeFlags:0x00, Flags3:0x08, ClientTimezone:360, ClientLCID:0x00000409
Hostname:'enrg-87368d8dc6', Username:'*', Password:*', AppName:'Tedious', ServerName:'undefined', LibraryName:'Tedious'
Language:'undefined', Database:'undefined', SSPI:'', AttachDbFile:'', ChangePassword:''
State change: SentPrelogin -> SentLogin7WithStandardLogin
Received
type:0x04(TABULAR_RESULT), status:0x01(EOM), length:0x016D, spid:0x006A, packetId:0x01, window:0x00
0000 E31B0001 066D0061 00730074 00650072 00066D00 61007300 74006500 7200AB5E .....m.a.s.t.e.r..m.a.s. t.e.r..^
0020 00451600 00020025 00430068 0061006E 00670065 00640020 00640061 00740061 .E.....%.C.h.a.n.g.e.d. .d.a.t.a
0040 00620061 00730065 00200063 006F006E 00740065 00780074 00200074 006F0020 .b.a.s.e. .c.o.n.t.e.x.t. .t.o.
0060 0027006D 00610073 00740065 00720027 002E0003 53005100 4C000001 000000E3 .'.m.a.s.t.e.r.'....S.Q. L.......
0080 08000705 0904D000 3400E317 00020A75 0073005F 0065006E 0067006C 00690073 ........ 4......u.s._.e.n.g.l.i.s
00A0 00680000 AB620047 16000001 00270043 00680061 006E0067 00650064 0020006C .h...b.G.....'.C.h.a.n.g.e.d. .l
00C0 0061006E 00670075 00610067 00650020 00730065 00740074 0069006E 00670020 .a.n.g.u.a.g.e. .s.e.t.t.i.n.g.
00E0 0074006F 00200075 0073005F 0065006E 0067006C 00690073 0068002E 00035300 .t.o. .u.s._.e.n.g.l.i.s.h....S.
0100 51004C00 00010000 00AD3600 01720900 02164D00 69006300 72006F00 73006F00 Q.L..... ..6..r.. ..M.i.c. r.o.s.o.
0120 66007400 20005300 51004C00 20005300 65007200 76006500 72000000 00000900 f.t. .S. Q.L. .S. e.r.v.e. r.......
0140 0577E313 00040434 00300039 00360004 34003000 39003600 FD000000 00000000 .w.....4.0.9.6.. 4.0.9.6. ........
0160 00000000 00 .....
{ name: 'ENVCHANGE',
type: 'DATABASE',
event: 'databaseChange',
oldValue: 'master',
newValue: 'master' }
{ number: 5701,
state: 2,
class: 0,
message: 'Changed database context to \'master\'.',
serverName: 'SQL',
procName: '',
lineNumber: 1,
name: 'INFO',
event: 'infoMessage' }
{ name: 'ENVCHANGE',
type: 'SQL_COLLATION',
event: 'sqlCollationChange',
oldValue: <Buffer >,
newValue: <Buffer 09 04 d0 00 34> }
{ name: 'ENVCHANGE',
type: 'LANGUAGE',
event: 'languageChange',
oldValue: '',
newValue: 'us_english' }
{ number: 5703,
state: 1,
class: 0,
message: 'Changed language setting to us_english.',
serverName: 'SQL',
procName: '',
lineNumber: 1,
name: 'INFO',
event: 'infoMessage' }
{ name: 'LOGINACK',
event: 'loginack',
interface: 'SQL_TSQL',
tdsVersion: '7_2',
progName: 'Microsoft SQL Server\u0000\u0000',
progVersion:
{ major: 9,
minor: 0,
buildNumHi: 5,
buildNumLow: 119 } }
{ name: 'ENVCHANGE',
type: 'PACKET_SIZE',
event: 'packetSizeChange',
oldValue: 4096,
newValue: 4096 }
Packet size changed from 4096 to 4096
{ name: 'DONE',
event: 'done',
more: false,
sqlError: false,
attention: false,
serverError: false,
rowCount: undefined,
curCmd: 0 }
State change: SentLogin7WithStandardLogin -> LoggedInSendingInitialSql
Sent
type:0x01(SQL_BATCH), status:0x01(EOM), length:0x004C, spid:0x0000, packetId:0x01, window:0x00
0000 16000000 12000000 02000000 00000000 00000100 00007300 65007400 20007400 ........ ........ ......s. e.t. .t.
0020 65007800 74007300 69007A00 65002000 32003100 34003700 34003800 33003600 e.x.t.s. i.z.e. . 2.1.4.7. 4.8.3.6.
0040 34003700 4.7.
Received
type:0x04(TABULAR_RESULT), status:0x01(EOM), length:0x0015, spid:0x006A, packetId:0x01, window:0x00
0000 FD0000BE 00000000 00000000 00 ........ .....
{ name: 'DONE',
event: 'done',
more: false,
sqlError: false,
attention: false,
serverError: false,
rowCount: undefined,
curCmd: 190 }
State change: LoggedInSendingInitialSql -> LoggedIn
Sent
type:0x03(RPC_REQUEST), status:0x01(EOM), length:0x00F4, spid:0x0000, packetId:0x01, window:0x00
0000 16000000 12000000 02000000 00000000 00000100 00000D00 73007000 5F006500 ........ ........ ........ s.p._.e.
0020 78006500 63007500 74006500 73007100 6C000000 0A400073 00740061 00740065 x.e.c.u. t.e.s.q. l....@.s.t.a.t.e
0040 006D0065 006E0074 0000E7A0 0F000000 00007E00 73006500 6C006500 63007400 .m.e.n.t........ ..~.s.e. l.e.c.t.
0060 20007400 6F007000 20003500 20006400 61007400 61002C00 20006400 61007400 .t.o.p. .5. .d. a.t.a.,. .d.a.t.
0080 65002000 66007200 6F006D00 20007200 65006100 6C005400 69006D00 65002000 e. .f.r. o.m. .r. e.a.l.T. i.m.e. .
00A0 77006800 65007200 65002000 64006100 74006500 20003E00 20002700 32003000 w.h.e.r. e. .d.a. t.e. .>. .'.2.0.
00C0 31003200 2D003000 35002D00 30003600 27000740 00700061 00720061 006D0073 1.2.-.0. 5.-.0.6. '..@.p.a.r.a.m.s
00E0 0000E7A0 0F000000 00000000 ........ ....
RPC Request - sp_executesql
State change: LoggedIn -> SentClientRequest
Received
type:0x04(TABULAR_RESULT), status:0x01(EOM), length:0x00A5, spid:0x006A, packetId:0x01, window:0x00
0000 81020000 00000009 006D0804 64006100 74006100 00000000 08003D04 64006100 ........ .m..d.a. t.a..... ..=.d.a.
0020 74006500 D1080DAF 5C7C5BA7 464086A0 0000C03B D600D108 3A9700AF E6974640 t.e..... \|[.F@.. ...;.... :.....F@
0040 86A00000 183ED600 D108C4D8 9131C4F5 464086A0 00007040 D600D108 D743E82A .....>.. .....1.. F@....p@.....C.*
0060 BDE04640 86A00000 C842D600 D1086379 D853A3CF 464086A0 00002045 D600FF11 ..F@.... .B....cy.S..F@.. .. E....
0080 00C10005 00000000 00000079 00000000 FE0000E0 00000000 00000000 00 ........ ...y.... ........ .....
{ name: 'COLMETADATA',
event: 'columnMetadata',
columns:
[ { userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined },
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined },
data: { userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined },
date: { userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } ] }
{ name: 'ROW',
event: 'row',
columns:
[ { value: 45.30747942472053,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
{ value: Fri Jul 06 2012 13:00:00 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } },
data: { value: 45.30747942472053,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
date: { value: Fri Jul 06 2012 13:00:00 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } } ] }
45.30747942472053
Fri Jul 06 2012 13:00:00 GMT-0500 (Central Daylight Time)
{ name: 'ROW',
event: 'row',
columns:
[ { value: 45.1867274048695,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
{ value: Fri Jul 06 2012 13:00:02 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } },
data: { value: 45.1867274048695,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
date: { value: Fri Jul 06 2012 13:00:02 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } } ] }
45.1867274048695
Fri Jul 06 2012 13:00:02 GMT-0500 (Central Daylight Time)
{ name: 'ROW',
event: 'row',
columns:
[ { value: 45.92004985448287,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
{ value: Fri Jul 06 2012 13:00:04 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } },
data: { value: 45.92004985448287,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
date: { value: Fri Jul 06 2012 13:00:04 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } } ] }
45.92004985448287
Fri Jul 06 2012 13:00:04 GMT-0500 (Central Daylight Time)
{ name: 'ROW',
event: 'row',
columns:
[ { value: 45.755772937212605,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
{ value: Fri Jul 06 2012 13:00:06 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } },
data: { value: 45.755772937212605,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
date: { value: Fri Jul 06 2012 13:00:06 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } } ] }
45.755772937212605
Fri Jul 06 2012 13:00:06 GMT-0500 (Central Daylight Time)
{ name: 'ROW',
event: 'row',
columns:
[ { value: 45.62217186040905,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
{ value: Fri Jul 06 2012 13:00:08 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } },
data: { value: 45.62217186040905,
metadata:
{ userType: 0,
flags: 9,
type:
{ type: 'FLTN',
name: 'FloatN',
dataLengthLength: 1,
id: 109 },
colName: 'data',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: 8,
tableName: undefined } },
date: { value: Fri Jul 06 2012 13:00:08 GMT-0500 (Central Daylight Time),
metadata:
{ userType: 0,
flags: 8,
type:
{ type: 'DATETIME',
name: 'DateTime',
declaration: [Function],
writeParameterData: [Function],
id: 61 },
colName: 'date',
collation: undefined,
precision: undefined,
scale: undefined,
dataLength: undefined,
tableName: undefined } } ] }
45.62217186040905
Fri Jul 06 2012 13:00:08 GMT-0500 (Central Daylight Time)
{ name: 'DONEINPROC',
event: 'doneInProc',
more: true,
sqlError: false,
attention: false,
serverError: false,
rowCount: 5,
curCmd: 193 }
{ name: 'RETURNSTATUS',
event: 'returnStatus',
value: 0 }
{ name: 'DONEPROC',
event: 'doneProc',
more: false,
sqlError: false,
attention: false,
serverError: false,
rowCount: undefined,
curCmd: 224 }
State change: SentClientRequest -> LoggedIn
5 rows
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment