Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we=20
send our data over TCP/IP every 3 minutes to SQL Server=20
but from 1 one week ago we found an error on SQL Server so=20
we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ************************************************
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
*=20
*
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09=20
00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00=20
00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 =
c8 ed 20 ca=20
ed e3 20 e3 e1 ed
* ب با با وي چ 20 =
c8 d3 df ca c8 c7 e1 20 c8 c7 20=20
e6 ed e1 8d d1 20
* با بيا اي ه =
و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20=20
df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 =
ca 20 8d e5 c7 d1 20 cc c7=20
e4 c8 e5 9d ed 20
* اي ا يا وبي =
ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20=20
ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 =
c7 ed 20 d4 e4 c7 d3 c7 ed ed 20=20
e4 dd d1 c7 ca 20
* ا ا ي به پا ا =
پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7=20
d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 =
20 c8 e6 cf a1 20 90=20
dd ca 3a 20 c2 90
* اهي وبي ا و =
و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20=20
e4 e6 da 20 e6 20
* يوه با ي يفا =
d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1=20
ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 =
cf d1 20 c7 e1 e3 81 ed df=20
20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 =
0d 0a db dd e6=20
d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 =
81 d3 20 c7 d2 20 c8 c7 d2=20
90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 =
e1 ed 20 c7 d2 20 e3 d3 c7=20
c8 de c7 ca 20 8d
* ها ا به ي اي =
ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20=20
c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 =
e5 20 ce c8 d1 90 d2 c7 d1=20
ed 20 cf c7 e4 d4
* ويا اي ا (اي =
ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20=20
28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a =
20 cf d1 20 c7=20
ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 =
ca 20 ca ed e3 9d e5 c7 ed=20
ed 20 8d e6 e4 20
* اي ا يا، قه ا =
ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1=20
e3 c7 e4 20 c7 d1
* وپا و ف ا ه و =
ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5=20
20 e6 20 c7 d3 81
* ا يا ي هاي و =
و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20=20
d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 =
d1 e3 20 c7 d1 e6 81 c7 20=20
d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf =
e4 cf 20 df e5=20
20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 =
d1 c7 e4 20 c7 ed e4 20 ca ed e3=20
9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 =
20 ca df e4 ed df ed=20
20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 =
e4 d3 c8 ca 20 c8 e5=20
20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 =
ed 20 c8 d1 ca d1 20=20
c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 =
20 d8 e6 d1 ed 20 df e5 20=20
cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 =
d1 20 dd d1 c7 e4 d3 e5 20 c8 c7=20
20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd =
20 32 30 20 c7 e3 ca ed c7 d2 a1=20
20 e3 de c7 c8 e1
* ا پا يا با ا =
اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20=20
c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 =
d2 20 e6=20
20 cf d1 20 e3 d5
* اف با اي ا يا =
با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed=20
c7 20 c8 c7 20 c7
* اف يا ي با ي =
ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20=20
c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 =
e6 c7 90 d0 c7 d1 20=20
df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 =
df=20
d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 =
ca e6 d1 e4 e3 e4 ca=20
20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed =
e4 20 c8 c7 d1 20 c8=20
e6 cf 20 df e5 20
* ب اب يفا ا =
وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4=20
20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 =
de d1 c7 d1 20 e3 ed 9d 90=20
d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 =
e5 20 cf e4 c8 c7 e1 20 e4=20
ca ed cc e5 20 e4
* بو ي ، ا با ا =
ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8=20
c7 20 c7 d1 d2 ed
* ابي ب با ي =
ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed=20
d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd =
c7 d9 20 df e1 c7 d3=20
9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 =
df ed a1 20 ca df e4 ed df=20
ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de =
d5 cf 20 cf c7=20
d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed =
c8 20 c7 d5 e1 ed 20 ca ed=20
e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 =
c7 ed 20 81 c7 d1 c7 e1 e3 81 ed=20
df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 =
ed ed 20 df e4 ed e3=20
2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 =
20 cf d1 20 c7 cf c7 e3 e5=20
20 c8 e5 20 df e3
* بو وي چ هاي =
ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed=20
20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 =
c7 d1 e5 20 df d1 cf 20 e6=20
20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 =
20 ca c7 20 de c8 e1=20
20 c7 d2 20 c7 da
* ا به آ وي چ =
ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6=20
ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed =
20 cf d1 20 c7=20
ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 =
20 de d1 c7 d1 20 c8 90 ed=20
d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 =
c7 d2 20 e3 d4 df e1=20
c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 =
cd e1 20 ce e6=20
c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed =
20 cf d1 20 c7 cf c7=20
e3 e5 20 90 dd ca
* و و و با اي =
ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20=20
c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 =
20=20
e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf =
e6 ed 20 c2 e3 c7 cf 90 ed=20
20 ca c7 20 d4 d1
* و ابقا پا ا =
پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81=20
c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 =
ce c8 d1 20 cf=20
c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a =
20 c7 dd d2 c7 ed d4 20 de=20
cf d1 ca 20 c8 cf
* ي با ي ا ، ا =
ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1=20
20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca =
df e4 ed df ed 20 e6 20 d1=20
dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 =
da dd 20 c7 e5 e3 20 c8 d1=20
e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 =
c7 ed e4 20 d3 e5 20 c7 d1=20
cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 =
e3 d1 e6 c7 20 cf d1 20 81=20
c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a =
20 d8 ed=20
20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 =
ca ed 20 df e5 20 cf d1 20 c7 ed=20
ca c7 e1 ed c7 20
* با وو ا ا پا =
يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7=20
d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 =
cf d1 20=20
d5 e6 d1 ca 20 e3
* وافق ف ا يو =
ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed=20
e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 =
c7 d2 c7 e4 20 e6 20 e3 da e1 e6=20
e1 ed e4 a1 20 de
* ب ا با يهاي ا =
پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7=20
ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf =
d1 20 ca=20
e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 =
e4 ed c7 20 d4 d1 df=20
ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 =
ed e3 2e 0d 0a c7 e4 ca e5 c7 ed=20
20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff=20
ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff=20
ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00=20
00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* =20
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF =20
00733000
* ntdll 77F80000 77FFCFFF =20
0007d000
* KERNEL32 7C570000 7C627FFF =20
000b8000
* ADVAPI32 7C2D0000 7C331FFF =20
00062000
* RPCRT4 77D30000 77DA0FFF =20
00071000
* USER32 77E10000 77E74FFF =20
00065000
* GDI32 77F40000 77F7DFFF =20
0003e000
* OPENDS60 41060000 41065FFF =20
00006000
* MSVCRT 78000000 78044FFF =20
00045000
* UMS 41070000 4107BFFF =20
0000c000
* SQLSORT 42AE0000 42B6FFFF =20
00090000
* MSVCIRT 780A0000 780B1FFF =20
00012000
* LPK 6CA60000 6CA67FFF =20
00008000
* USP10 66650000 666A3FFF =20
00054000
* sqlevn70 10000000 10006FFF =20
00007000
* NETAPI32 7A7C0000 7A80EFFF =20
0004f000
* SECUR32 7C340000 7C34EFFF =20
0000f000
* NETRAP 7A810000 7A815FFF =20
00006000
* SAMLIB 7A820000 7A82EFFF =20
0000f000
* WS2_32 7A830000 7A843FFF =20
00014000
* WS2HELP 7A850000 7A857FFF =20
00008000
* WLDAP32 7A860000 7A889FFF =20
0002a000
* DNSAPI 7A890000 7A8B3FFF =20
00024000
* WSOCK32 7A8C0000 7A8C7FFF =20
00008000
* ole32 7AB70000 7AC5EFFF =20
000ef000
* XOLEHLP 7AC60000 7AC67FFF =20
00008000
* MSDTCPRX 7AC70000 7AD26FFF =20
000b7000
* MTXCLU 7AD30000 7AD3FFFF =20
00010000
* VERSION 7AD40000 7AD46FFF =20
00007000
* LZ32 7AD50000 7AD55FFF =20
00006000
* CLUSAPI 7AD60000 7AD6FFFF =20
00010000
* RESUTILS 7AD70000 7AD7CFFF =20
0000d000
* USERENV 7C0F0000 7C150FFF =20
00061000
* rnr20 7AD80000 7AD8BFFF =20
0000c000
* iphlpapi 7AD90000 7ADA2FFF =20
00013000
* ICMP 7ADB0000 7ADB4FFF =20
00005000
* MPRAPI 7ADC0000 7ADD6FFF =20
00017000
* OLEAUT32 7ADE0000 7AE7AFFF =20
0009b000
* ACTIVEDS 7AE80000 7AEAEFFF =20
0002f000
* ADSLDPC 7AEB0000 7AED2FFF =20
00023000
* RTUTILS 7AEE0000 7AEEDFFF =20
0000e000
* SETUPAPI 7AEF0000 7AF7DFFF =20
0008e000
* RASAPI32 7AF80000 7AFB2FFF =20
00033000
* RASMAN 7AFC0000 7AFD0FFF =20
00011000
* TAPI32 7AFE0000 7B001FFF =20
00022000
* COMCTL32 7B010000 7B093FFF =20
00084000
* SHLWAPI 7B0A0000 7B104FFF =20
00065000
* DHCPCSVC 7B110000 7B128FFF =20
00019000
* winrnr 7B5D0000 7B5D7FFF =20
00008000
* rasadhlp 7B5E0000 7B5E4FFF =20
00005000
* SSNETLIB 7BDA0000 7BDB4FFF =20
00015000
* NTMARTA 7BE00000 7BE1CFFF =20
0001d000
* WINSPOOL 7BE20000 7BE3DFFF =20
0001e000
* MPR 7BE40000 7BE4FFFF =20
00010000
* NTDSAPI 7BE50000 7BE60FFF =20
00011000
* security 003F0000 003F3FFF =20
00004000
* msafd 10450000 1046DFFF =20
0001e000
* wshtcpip 10470000 10476FFF =20
00007000
* SSmsLPCn 10500000 10507FFF =20
00008000
* SSnmPN70 410D0000 410D5FFF =20
00006000
* rsabase 7CA00000 7CA22FFF =20
00023000
* CRYPT32 7C740000 7C7C6FFF =20
00087000
* MSASN1 109A0000 109AFFFF =20
00010000
* SQLFTQRY 10BD0000 10C01FFF =20
00032000
* CLBCATQ 10C10000 10C9FFFF =20
00090000
* sqloledb 10CC0000 10D32FFF =20
00073000
* MSDART 10D40000 10D5EFFF =20
0001f000
* comdlg32 10D60000 10D9DFFF =20
0003e000
* SHELL32 10DA0000 10FE7FFF =20
00248000
* MSDATL3 10FF0000 11004FFF =20
00015000
* oledb32 1F8A0000 1F905FFF =20
00066000
* OLEDB32R 1F910000 1F91FFFF =20
00010000
* msv1_0 11340000 11360FFF =20
00021000
* xpstar 410F0000 41136FFF =20
00047000
* SQLRESLD 42AC0000 42AC6FFF =20
00007000
* SQLSVC 11370000 11386FFF =20
00017000
* ODBC32 11390000 113C1FFF =20
00032000
* odbcbcp 113D0000 113D5FFF =20
00006000
* W95SCM 41140000 4114BFFF =20
0000c000
* SQLUNIRL 41090000 410BCFFF =20
0002d000
* SHFOLDER 113E0000 113E7FFF =20
00008000
* odbcint 1F850000 1F865FFF =20
00016000
* NDDEAPI 114F0000 114F6FFF =20
00007000
* SQLSVC 11500000 11505FFF =20
00006000
* xpstar 11510000 11518FFF =20
00009000
* dbghelp 167A0000 16854FFF =20
000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 =20
43B19918 43B190C0 43F7C030 =20
* Esi: 00000000:=20
* Eax: 00000000:=20
* Ebx: 43B551D8: 00000034 00000000 01178E38 =20
000094FE 00000000 00000000 =20
* Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E =20
00000000 00000000 00000000 =20
* Edx: FFFFFFFF:=20
* Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C =20
E8E04D8B 0000002D 64F04D8B =20
* Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 =20
10A2B644 10A2B8E7 780238AE =20
* SegCs: 0000001B:=20
* EFlags: 00010246: 00720067 006D0061 00460020 =20
006C0069 00730065 004D005C =20
* Esp: 10A2AC94: 43B55508 00000000 43B551D8 =20
10A2ACDC 43B55000 10A2AC94 =20
* SegSs: 00000023:=20
*=20
************************************************** *********
********************
* ----
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E)=20
(CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29)=20
(utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E)=20
(RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7)=20
(RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57)=20
(Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787)=20
(DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F)=20
(DataSplitMgr::RegularSplitPoint+00000099)
* 0043F481 Module(sqlservr+0003F481)=20
(DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337)=20
(DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7)=20
(InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375)=20
(RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229)=20
(CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149)=20
(SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400)=20
(CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91)=20
(CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6)=20
(CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E)=20
(CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3)=20
(CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF)=20
(CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C)=20
(CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A)=20
(CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB)=20
(CMsqlExecContext::ExecuteStmts+000003B9)
* 0041BA11 Module(sqlservr+0001BA11)=20
(CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D)=20
(CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262)=20
(CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37)=20
(CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29)=20
(CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A)=20
(process_commands+00000232)
* 41072838 Module(UMS+00002838)=20
(ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3)=20
(ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File:=20
<R:\sql\ntdbms\storeng\drs\include\record.inl>, line=3D1447=20
Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D=20
MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad Reza
Your database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:
Showing posts with label remote. Show all posts
Showing posts with label remote. Show all posts
Thursday, March 22, 2012
Error: 3624, Severity: 20, State: 1.
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we=20
send our data over TCP/IP every 3 minutes to SQL Server=20
but from 1 one week ago we found an error on SQL Server so=20
we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ****************************************
********
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
*=20
*
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09=20
00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00=20
00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 =
c8 ed 20 ca=20
ed e3 20 e3 e1 ed
* ب با با وي چ 20 =
c8 d3 df ca c8 c7 e1 20 c8 c7 20=20
e6 ed e1 8d d1 20
* با بيا اي ه =
و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20=20
df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 =
ca 20 8d e5 c7 d1 20 cc c7=20
e4 c8 e5 9d ed 20
* اي ا يا وبي =
ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20=20
ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 =
c7 ed 20 d4 e4 c7 d3 c7 ed ed 20=20
e4 dd d1 c7 ca 20
* ا ا ي به پا ا =
پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7=20
d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 =
20 c8 e6 cf a1 20 90=20
dd ca 3a 20 c2 90
* اهي وبي ا و =
و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20=20
e4 e6 da 20 e6 20
* يوه با ي يفا =
d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1=20
ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 =
cf d1 20 c7 e1 e3 81 ed df=20
20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 =
0d 0a db dd e6=20
d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 =
81 d3 20 c7 d2 20 c8 c7 d2=20
90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 =
e1 ed 20 c7 d2 20 e3 d3 c7=20
c8 de c7 ca 20 8d
* ها ا به ي اي =
ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20=20
c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 =
e5 20 ce c8 d1 90 d2 c7 d1=20
ed 20 cf c7 e4 d4
* ويا اي ا (اي =
ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20=20
28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a =
20 cf d1 20 c7=20
ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 =
ca 20 ca ed e3 9d e5 c7 ed=20
ed 20 8d e6 e4 20
* اي ا يا، قه ا =
ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1=20
e3 c7 e4 20 c7 d1
* وپا و ف ا ه و =
ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5=20
20 e6 20 c7 d3 81
* ا يا ي هاي و =
و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20=20
d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 =
d1 e3 20 c7 d1 e6 81 c7 20=20
d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf =
e4 cf 20 df e5=20
20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 =
d1 c7 e4 20 c7 ed e4 20 ca ed e3=20
9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 =
20 ca df e4 ed df ed=20
20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 =
e4 d3 c8 ca 20 c8 e5=20
20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 =
ed 20 c8 d1 ca d1 20=20
c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 =
20 d8 e6 d1 ed 20 df e5 20=20
cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 =
d1 20 dd d1 c7 e4 d3 e5 20 c8 c7=20
20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd =
20 32 30 20 c7 e3 ca ed c7 d2 a1=20
20 e3 de c7 c8 e1
* ا پا يا با ا =
اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20=20
c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 =
d2 20 e6=20
20 cf d1 20 e3 d5
* اف با اي ا يا =
با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed=20
c7 20 c8 c7 20 c7
* اف يا ي با ي =
ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20=20
c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 =
e6 c7 90 d0 c7 d1 20=20
df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 =
df=20
d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 =
ca e6 d1 e4 e3 e4 ca=20
20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed =
e4 20 c8 c7 d1 20 c8=20
e6 cf 20 df e5 20
* ب اب يفا ا =
وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4=20
20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 =
de d1 c7 d1 20 e3 ed 9d 90=20
d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 =
e5 20 cf e4 c8 c7 e1 20 e4=20
ca ed cc e5 20 e4
* بو ي ، ا با ا =
ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8=20
c7 20 c7 d1 d2 ed
* ابي ب با ي =
ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed=20
d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd =
c7 d9 20 df e1 c7 d3=20
9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 =
df ed a1 20 ca df e4 ed df=20
ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de =
d5 cf 20 cf c7=20
d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed =
c8 20 c7 d5 e1 ed 20 ca ed=20
e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 =
c7 ed 20 81 c7 d1 c7 e1 e3 81 ed=20
df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 =
ed ed 20 df e4 ed e3=20
2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 =
20 cf d1 20 c7 cf c7 e3 e5=20
20 c8 e5 20 df e3
* بو وي چ هاي =
ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed=20
20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 =
c7 d1 e5 20 df d1 cf 20 e6=20
20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 =
20 ca c7 20 de c8 e1=20
20 c7 d2 20 c7 da
* ا به آ وي چ =
ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6=20
ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed =
20 cf d1 20 c7=20
ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 =
20 de d1 c7 d1 20 c8 90 ed=20
d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 =
c7 d2 20 e3 d4 df e1=20
c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 =
cd e1 20 ce e6=20
c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed =
20 cf d1 20 c7 cf c7=20
e3 e5 20 90 dd ca
* و و و با اي =
ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20=20
c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 =
20=20
e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf =
e6 ed 20 c2 e3 c7 cf 90 ed=20
20 ca c7 20 d4 d1
* و ابقا پا ا =
پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81=20
c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 =
ce c8 d1 20 cf=20
c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a =
20 c7 dd d2 c7 ed d4 20 de=20
cf d1 ca 20 c8 cf
* ي با ي ا ، ا =
ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1=20
20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca =
df e4 ed df ed 20 e6 20 d1=20
dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 =
da dd 20 c7 e5 e3 20 c8 d1=20
e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 =
c7 ed e4 20 d3 e5 20 c7 d1=20
cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 =
e3 d1 e6 c7 20 cf d1 20 81=20
c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a =
20 d8 ed=20
20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 =
ca ed 20 df e5 20 cf d1 20 c7 ed=20
ca c7 e1 ed c7 20
* با وو ا ا پا =
يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7=20
d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 =
cf d1 20=20
d5 e6 d1 ca 20 e3
* وافق ف ا يو =
ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed=20
e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 =
c7 d2 c7 e4 20 e6 20 e3 da e1 e6=20
e1 ed e4 a1 20 de
* ب ا با يهاي ا =
پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7=20
ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf =
d1 20 ca=20
e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 =
e4 ed c7 20 d4 d1 df=20
ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 =
ed e3 2e 0d 0a c7 e4 ca e5 c7 ed=20
20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff=20
ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff=20
ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00=20
00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* =20
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF =20
00733000
* ntdll 77F80000 77FFCFFF =20
0007d000
* KERNEL32 7C570000 7C627FFF =20
000b8000
* ADVAPI32 7C2D0000 7C331FFF =20
00062000
* RPCRT4 77D30000 77DA0FFF =20
00071000
* USER32 77E10000 77E74FFF =20
00065000
* GDI32 77F40000 77F7DFFF =20
0003e000
* OPENDS60 41060000 41065FFF =20
00006000
* MSVCRT 78000000 78044FFF =20
00045000
* UMS 41070000 4107BFFF =20
0000c000
* SQLSORT 42AE0000 42B6FFFF =20
00090000
* MSVCIRT 780A0000 780B1FFF =20
00012000
* LPK 6CA60000 6CA67FFF =20
00008000
* USP10 66650000 666A3FFF =20
00054000
* sqlevn70 10000000 10006FFF =20
00007000
* NETAPI32 7A7C0000 7A80EFFF =20
0004f000
* SECUR32 7C340000 7C34EFFF =20
0000f000
* NETRAP 7A810000 7A815FFF =20
00006000
* SAMLIB 7A820000 7A82EFFF =20
0000f000
* WS2_32 7A830000 7A843FFF =20
00014000
* WS2HELP 7A850000 7A857FFF =20
00008000
* WLDAP32 7A860000 7A889FFF =20
0002a000
* DNSAPI 7A890000 7A8B3FFF =20
00024000
* WSOCK32 7A8C0000 7A8C7FFF =20
00008000
* ole32 7AB70000 7AC5EFFF =20
000ef000
* XOLEHLP 7AC60000 7AC67FFF =20
00008000
* MSDTCPRX 7AC70000 7AD26FFF =20
000b7000
* MTXCLU 7AD30000 7AD3FFFF =20
00010000
* VERSION 7AD40000 7AD46FFF =20
00007000
* LZ32 7AD50000 7AD55FFF =20
00006000
* CLUSAPI 7AD60000 7AD6FFFF =20
00010000
* RESUTILS 7AD70000 7AD7CFFF =20
0000d000
* USERENV 7C0F0000 7C150FFF =20
00061000
* rnr20 7AD80000 7AD8BFFF =20
0000c000
* iphlpapi 7AD90000 7ADA2FFF =20
00013000
* ICMP 7ADB0000 7ADB4FFF =20
00005000
* MPRAPI 7ADC0000 7ADD6FFF =20
00017000
* OLEAUT32 7ADE0000 7AE7AFFF =20
0009b000
* ACTIVEDS 7AE80000 7AEAEFFF =20
0002f000
* ADSLDPC 7AEB0000 7AED2FFF =20
00023000
* RTUTILS 7AEE0000 7AEEDFFF =20
0000e000
* SETUPAPI 7AEF0000 7AF7DFFF =20
0008e000
* RASAPI32 7AF80000 7AFB2FFF =20
00033000
* RASMAN 7AFC0000 7AFD0FFF =20
00011000
* TAPI32 7AFE0000 7B001FFF =20
00022000
* COMCTL32 7B010000 7B093FFF =20
00084000
* SHLWAPI 7B0A0000 7B104FFF =20
00065000
* DHCPCSVC 7B110000 7B128FFF =20
00019000
* winrnr 7B5D0000 7B5D7FFF =20
00008000
* rasadhlp 7B5E0000 7B5E4FFF =20
00005000
* SSNETLIB 7BDA0000 7BDB4FFF =20
00015000
* NTMARTA 7BE00000 7BE1CFFF =20
0001d000
* WINSPOOL 7BE20000 7BE3DFFF =20
0001e000
* MPR 7BE40000 7BE4FFFF =20
00010000
* NTDSAPI 7BE50000 7BE60FFF =20
00011000
* security 003F0000 003F3FFF =20
00004000
* msafd 10450000 1046DFFF =20
0001e000
* wshtcpip 10470000 10476FFF =20
00007000
* SSmsLPCn 10500000 10507FFF =20
00008000
* SSnmPN70 410D0000 410D5FFF =20
00006000
* rsabase 7CA00000 7CA22FFF =20
00023000
* CRYPT32 7C740000 7C7C6FFF =20
00087000
* MSASN1 109A0000 109AFFFF =20
00010000
* SQLFTQRY 10BD0000 10C01FFF =20
00032000
* CLBCATQ 10C10000 10C9FFFF =20
00090000
* sqloledb 10CC0000 10D32FFF =20
00073000
* MSDART 10D40000 10D5EFFF =20
0001f000
* comdlg32 10D60000 10D9DFFF =20
0003e000
* SHELL32 10DA0000 10FE7FFF =20
00248000
* MSDATL3 10FF0000 11004FFF =20
00015000
* oledb32 1F8A0000 1F905FFF =20
00066000
* OLEDB32R 1F910000 1F91FFFF =20
00010000
* msv1_0 11340000 11360FFF =20
00021000
* xpstar 410F0000 41136FFF =20
00047000
* SQLRESLD 42AC0000 42AC6FFF =20
00007000
* SQLSVC 11370000 11386FFF =20
00017000
* ODBC32 11390000 113C1FFF =20
00032000
* odbcbcp 113D0000 113D5FFF =20
00006000
* W95SCM 41140000 4114BFFF =20
0000c000
* SQLUNIRL 41090000 410BCFFF =20
0002d000
* SHFOLDER 113E0000 113E7FFF =20
00008000
* odbcint 1F850000 1F865FFF =20
00016000
* NDDEAPI 114F0000 114F6FFF =20
00007000
* SQLSVC 11500000 11505FFF =20
00006000
* xpstar 11510000 11518FFF =20
00009000
* dbghelp 167A0000 16854FFF =20
000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 =20
43B19918 43B190C0 43F7C030 =20
* Esi: 00000000:=20
* Eax: 00000000:=20
* Ebx: 43B551D8: 00000034 00000000 01178E38 =20
000094FE 00000000 00000000 =20
* Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E =20
00000000 00000000 00000000 =20
* Edx: FFFFFFFF:=20
* Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C =20
E8E04D8B 0000002D 64F04D8B =20
* Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 =20
10A2B644 10A2B8E7 780238AE =20
* SegCs: 0000001B:=20
* EFlags: 00010246: 00720067 006D0061 00460020 =20
006C0069 00730065 004D005C =20
* Esp: 10A2AC94: 43B55508 00000000 43B551D8 =20
10A2ACDC 43B55000 10A2AC94 =20
* SegSs: 00000023:=20
*=20
****************************************
*******************
********************
* ----
--
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E)=20
(CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29)=20
(utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E)=20
(RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7)=20
(RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57)=20
(Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787)=20
(DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F)=20
(DataSplitMgr::RegularSplitPoint+0000009
9)
* 0043F481 Module(sqlservr+0003F481)=20
(DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337)=20
(DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7)=20
(InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375)=20
(RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229)=20
(CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149)=20
(SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400)=20
(CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91)=20
(CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6)=20
(CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E)=20
(CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3)=20
(CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF)=20
(CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C)=20
(CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A)=20
(CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB)=20
(CMsqlExecContext::ExecuteStmts+000003B9
)
* 0041BA11 Module(sqlservr+0001BA11)=20
(CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D)=20
(CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262)=20
(CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37)=20
(CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29)=20
(CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A)=20
(process_commands+00000232)
* 41072838 Module(UMS+00002838)=20
(ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3)=20
(ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
--
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File:=20
< R:\sql\ntdbms\storeng\drs\include\record
.inl>, line=3D1447=20
Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D=20
MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad RezaYour database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx
.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:sql
Hello,
We have a SQL Server 2000 on a remote server in Texas, we=20
send our data over TCP/IP every 3 minutes to SQL Server=20
but from 1 one week ago we found an error on SQL Server so=20
we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ****************************************
********
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
*=20
*
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00=20
65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09=20
00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00=20
00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 =
c8 ed 20 ca=20
ed e3 20 e3 e1 ed
* ب با با وي چ 20 =
c8 d3 df ca c8 c7 e1 20 c8 c7 20=20
e6 ed e1 8d d1 20
* با بيا اي ه =
و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20=20
df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 =
ca 20 8d e5 c7 d1 20 cc c7=20
e4 c8 e5 9d ed 20
* اي ا يا وبي =
ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20=20
ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 =
c7 ed 20 d4 e4 c7 d3 c7 ed ed 20=20
e4 dd d1 c7 ca 20
* ا ا ي به پا ا =
پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7=20
d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 =
20 c8 e6 cf a1 20 90=20
dd ca 3a 20 c2 90
* اهي وبي ا و =
و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20=20
e4 e6 da 20 e6 20
* يوه با ي يفا =
d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1=20
ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 =
cf d1 20 c7 e1 e3 81 ed df=20
20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 =
0d 0a db dd e6=20
d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 =
81 d3 20 c7 d2 20 c8 c7 d2=20
90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 =
e1 ed 20 c7 d2 20 e3 d3 c7=20
c8 de c7 ca 20 8d
* ها ا به ي اي =
ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20=20
c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 =
e5 20 ce c8 d1 90 d2 c7 d1=20
ed 20 cf c7 e4 d4
* ويا اي ا (اي =
ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20=20
28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a =
20 cf d1 20 c7=20
ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 =
ca 20 ca ed e3 9d e5 c7 ed=20
ed 20 8d e6 e4 20
* اي ا يا، قه ا =
ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1=20
e3 c7 e4 20 c7 d1
* وپا و ف ا ه و =
ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5=20
20 e6 20 c7 d3 81
* ا يا ي هاي و =
و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20=20
d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 =
d1 e3 20 c7 d1 e6 81 c7 20=20
d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf =
e4 cf 20 df e5=20
20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 =
d1 c7 e4 20 c7 ed e4 20 ca ed e3=20
9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 =
20 ca df e4 ed df ed=20
20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 =
e4 d3 c8 ca 20 c8 e5=20
20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 =
ed 20 c8 d1 ca d1 20=20
c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 =
20 d8 e6 d1 ed 20 df e5 20=20
cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 =
d1 20 dd d1 c7 e4 d3 e5 20 c8 c7=20
20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd =
20 32 30 20 c7 e3 ca ed c7 d2 a1=20
20 e3 de c7 c8 e1
* ا پا يا با ا =
اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20=20
c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 =
d2 20 e6=20
20 cf d1 20 e3 d5
* اف با اي ا يا =
با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed=20
c7 20 c8 c7 20 c7
* اف يا ي با ي =
ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20=20
c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 =
e6 c7 90 d0 c7 d1 20=20
df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 =
df=20
d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 =
ca e6 d1 e4 e3 e4 ca=20
20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed =
e4 20 c8 c7 d1 20 c8=20
e6 cf 20 df e5 20
* ب اب يفا ا =
وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4=20
20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 =
de d1 c7 d1 20 e3 ed 9d 90=20
d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 =
e5 20 cf e4 c8 c7 e1 20 e4=20
ca ed cc e5 20 e4
* بو ي ، ا با ا =
ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8=20
c7 20 c7 d1 d2 ed
* ابي ب با ي =
ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed=20
d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd =
c7 d9 20 df e1 c7 d3=20
9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 =
df ed a1 20 ca df e4 ed df=20
ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de =
d5 cf 20 cf c7=20
d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed =
c8 20 c7 d5 e1 ed 20 ca ed=20
e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 =
c7 ed 20 81 c7 d1 c7 e1 e3 81 ed=20
df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 =
ed ed 20 df e4 ed e3=20
2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 =
20 cf d1 20 c7 cf c7 e3 e5=20
20 c8 e5 20 df e3
* بو وي چ هاي =
ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed=20
20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 =
c7 d1 e5 20 df d1 cf 20 e6=20
20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 =
20 ca c7 20 de c8 e1=20
20 c7 d2 20 c7 da
* ا به آ وي چ =
ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6=20
ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed =
20 cf d1 20 c7=20
ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 =
20 de d1 c7 d1 20 c8 90 ed=20
d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 =
c7 d2 20 e3 d4 df e1=20
c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 =
cd e1 20 ce e6=20
c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed =
20 cf d1 20 c7 cf c7=20
e3 e5 20 90 dd ca
* و و و با اي =
ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20=20
c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 =
20=20
e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf =
e6 ed 20 c2 e3 c7 cf 90 ed=20
20 ca c7 20 d4 d1
* و ابقا پا ا =
پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81=20
c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 =
ce c8 d1 20 cf=20
c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a =
20 c7 dd d2 c7 ed d4 20 de=20
cf d1 ca 20 c8 cf
* ي با ي ا ، ا =
ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1=20
20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca =
df e4 ed df ed 20 e6 20 d1=20
dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 =
da dd 20 c7 e5 e3 20 c8 d1=20
e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 =
c7 ed e4 20 d3 e5 20 c7 d1=20
cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 =
e3 d1 e6 c7 20 cf d1 20 81=20
c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a =
20 d8 ed=20
20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 =
ca ed 20 df e5 20 cf d1 20 c7 ed=20
ca c7 e1 ed c7 20
* با وو ا ا پا =
يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7=20
d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 =
cf d1 20=20
d5 e6 d1 ca 20 e3
* وافق ف ا يو =
ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed=20
e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 =
c7 d2 c7 e4 20 e6 20 e3 da e1 e6=20
e1 ed e4 a1 20 de
* ب ا با يهاي ا =
پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7=20
ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf =
d1 20 ca=20
e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 =
e4 ed c7 20 d4 d1 df=20
ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 =
ed e3 2e 0d 0a c7 e4 ca e5 c7 ed=20
20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff=20
ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff=20
ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00=20
00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* =20
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF =20
00733000
* ntdll 77F80000 77FFCFFF =20
0007d000
* KERNEL32 7C570000 7C627FFF =20
000b8000
* ADVAPI32 7C2D0000 7C331FFF =20
00062000
* RPCRT4 77D30000 77DA0FFF =20
00071000
* USER32 77E10000 77E74FFF =20
00065000
* GDI32 77F40000 77F7DFFF =20
0003e000
* OPENDS60 41060000 41065FFF =20
00006000
* MSVCRT 78000000 78044FFF =20
00045000
* UMS 41070000 4107BFFF =20
0000c000
* SQLSORT 42AE0000 42B6FFFF =20
00090000
* MSVCIRT 780A0000 780B1FFF =20
00012000
* LPK 6CA60000 6CA67FFF =20
00008000
* USP10 66650000 666A3FFF =20
00054000
* sqlevn70 10000000 10006FFF =20
00007000
* NETAPI32 7A7C0000 7A80EFFF =20
0004f000
* SECUR32 7C340000 7C34EFFF =20
0000f000
* NETRAP 7A810000 7A815FFF =20
00006000
* SAMLIB 7A820000 7A82EFFF =20
0000f000
* WS2_32 7A830000 7A843FFF =20
00014000
* WS2HELP 7A850000 7A857FFF =20
00008000
* WLDAP32 7A860000 7A889FFF =20
0002a000
* DNSAPI 7A890000 7A8B3FFF =20
00024000
* WSOCK32 7A8C0000 7A8C7FFF =20
00008000
* ole32 7AB70000 7AC5EFFF =20
000ef000
* XOLEHLP 7AC60000 7AC67FFF =20
00008000
* MSDTCPRX 7AC70000 7AD26FFF =20
000b7000
* MTXCLU 7AD30000 7AD3FFFF =20
00010000
* VERSION 7AD40000 7AD46FFF =20
00007000
* LZ32 7AD50000 7AD55FFF =20
00006000
* CLUSAPI 7AD60000 7AD6FFFF =20
00010000
* RESUTILS 7AD70000 7AD7CFFF =20
0000d000
* USERENV 7C0F0000 7C150FFF =20
00061000
* rnr20 7AD80000 7AD8BFFF =20
0000c000
* iphlpapi 7AD90000 7ADA2FFF =20
00013000
* ICMP 7ADB0000 7ADB4FFF =20
00005000
* MPRAPI 7ADC0000 7ADD6FFF =20
00017000
* OLEAUT32 7ADE0000 7AE7AFFF =20
0009b000
* ACTIVEDS 7AE80000 7AEAEFFF =20
0002f000
* ADSLDPC 7AEB0000 7AED2FFF =20
00023000
* RTUTILS 7AEE0000 7AEEDFFF =20
0000e000
* SETUPAPI 7AEF0000 7AF7DFFF =20
0008e000
* RASAPI32 7AF80000 7AFB2FFF =20
00033000
* RASMAN 7AFC0000 7AFD0FFF =20
00011000
* TAPI32 7AFE0000 7B001FFF =20
00022000
* COMCTL32 7B010000 7B093FFF =20
00084000
* SHLWAPI 7B0A0000 7B104FFF =20
00065000
* DHCPCSVC 7B110000 7B128FFF =20
00019000
* winrnr 7B5D0000 7B5D7FFF =20
00008000
* rasadhlp 7B5E0000 7B5E4FFF =20
00005000
* SSNETLIB 7BDA0000 7BDB4FFF =20
00015000
* NTMARTA 7BE00000 7BE1CFFF =20
0001d000
* WINSPOOL 7BE20000 7BE3DFFF =20
0001e000
* MPR 7BE40000 7BE4FFFF =20
00010000
* NTDSAPI 7BE50000 7BE60FFF =20
00011000
* security 003F0000 003F3FFF =20
00004000
* msafd 10450000 1046DFFF =20
0001e000
* wshtcpip 10470000 10476FFF =20
00007000
* SSmsLPCn 10500000 10507FFF =20
00008000
* SSnmPN70 410D0000 410D5FFF =20
00006000
* rsabase 7CA00000 7CA22FFF =20
00023000
* CRYPT32 7C740000 7C7C6FFF =20
00087000
* MSASN1 109A0000 109AFFFF =20
00010000
* SQLFTQRY 10BD0000 10C01FFF =20
00032000
* CLBCATQ 10C10000 10C9FFFF =20
00090000
* sqloledb 10CC0000 10D32FFF =20
00073000
* MSDART 10D40000 10D5EFFF =20
0001f000
* comdlg32 10D60000 10D9DFFF =20
0003e000
* SHELL32 10DA0000 10FE7FFF =20
00248000
* MSDATL3 10FF0000 11004FFF =20
00015000
* oledb32 1F8A0000 1F905FFF =20
00066000
* OLEDB32R 1F910000 1F91FFFF =20
00010000
* msv1_0 11340000 11360FFF =20
00021000
* xpstar 410F0000 41136FFF =20
00047000
* SQLRESLD 42AC0000 42AC6FFF =20
00007000
* SQLSVC 11370000 11386FFF =20
00017000
* ODBC32 11390000 113C1FFF =20
00032000
* odbcbcp 113D0000 113D5FFF =20
00006000
* W95SCM 41140000 4114BFFF =20
0000c000
* SQLUNIRL 41090000 410BCFFF =20
0002d000
* SHFOLDER 113E0000 113E7FFF =20
00008000
* odbcint 1F850000 1F865FFF =20
00016000
* NDDEAPI 114F0000 114F6FFF =20
00007000
* SQLSVC 11500000 11505FFF =20
00006000
* xpstar 11510000 11518FFF =20
00009000
* dbghelp 167A0000 16854FFF =20
000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 =20
43B19918 43B190C0 43F7C030 =20
* Esi: 00000000:=20
* Eax: 00000000:=20
* Ebx: 43B551D8: 00000034 00000000 01178E38 =20
000094FE 00000000 00000000 =20
* Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E =20
00000000 00000000 00000000 =20
* Edx: FFFFFFFF:=20
* Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C =20
E8E04D8B 0000002D 64F04D8B =20
* Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 =20
10A2B644 10A2B8E7 780238AE =20
* SegCs: 0000001B:=20
* EFlags: 00010246: 00720067 006D0061 00460020 =20
006C0069 00730065 004D005C =20
* Esp: 10A2AC94: 43B55508 00000000 43B551D8 =20
10A2ACDC 43B55000 10A2AC94 =20
* SegSs: 00000023:=20
*=20
****************************************
*******************
********************
* ----
--
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E)=20
(CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29)=20
(utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E)=20
(RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7)=20
(RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57)=20
(Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787)=20
(DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F)=20
(DataSplitMgr::RegularSplitPoint+0000009
9)
* 0043F481 Module(sqlservr+0003F481)=20
(DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337)=20
(DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7)=20
(InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375)=20
(RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229)=20
(CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149)=20
(SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400)=20
(CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91)=20
(CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6)=20
(CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E)=20
(CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3)=20
(CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF)=20
(CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C)=20
(CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A)=20
(CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB)=20
(CMsqlExecContext::ExecuteStmts+000003B9
)
* 0041BA11 Module(sqlservr+0001BA11)=20
(CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D)=20
(CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262)=20
(CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37)=20
(CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29)=20
(CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A)=20
(process_commands+00000232)
* 41072838 Module(UMS+00002838)=20
(ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3)=20
(ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
--
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File:=20
< R:\sql\ntdbms\storeng\drs\include\record
.inl>, line=3D1447=20
Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D=20
MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad RezaYour database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx
.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:sql
Error: 3624, Severity: 20, State: 1.
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we send our data over TCP/IP every 3 minutes to SQL Server but from 1 one week ago we found an error on SQL Server so we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ************************************************
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
* *
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09 00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00 00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 = c8 ed 20 ca ed e3 20 e3 e1 ed
* ب با با وي چ 20 = c8 d3 df ca c8 c7 e1 20 c8 c7 20 e6 ed e1 8d d1 20
* با بيا اي ه = و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20 df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 = ca 20 8d e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20
* اي ا يا وبي = ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20 ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 = c7 ed 20 d4 e4 c7 d3 c7 ed ed 20 e4 dd d1 c7 ca 20
* ا ا ي به پا ا = پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7 d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 = 20 c8 e6 cf a1 20 90 dd ca 3a 20 c2 90
* اهي وبي ا و = و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20 e4 e6 da 20 e6 20
* يوه با ي يفا = d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1 ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 = cf d1 20 c7 e1 e3 81 ed df 20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 = 0d 0a db dd e6 d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 = 81 d3 20 c7 d2 20 c8 c7 d2 90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 = e1 ed 20 c7 d2 20 e3 d3 c7 c8 de c7 ca 20 8d
* ها ا به ي اي = ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20 c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 = e5 20 ce c8 d1 90 d2 c7 d1 ed 20 cf c7 e4 d4
* ويا اي ا (اي = ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20 28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a = 20 cf d1 20 c7 ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 = ca 20 ca ed e3 9d e5 c7 ed ed 20 8d e6 e4 20
* اي ا يا، قه ا = ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1 e3 c7 e4 20 c7 d1
* وپا و ف ا ه و = ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5 20 e6 20 c7 d3 81
* ا يا ي هاي و = و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20 d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 = d1 e3 20 c7 d1 e6 81 c7 20 d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf = e4 cf 20 df e5 20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 = d1 c7 e4 20 c7 ed e4 20 ca ed e3 9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 = 20 ca df e4 ed df ed 20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 = e4 d3 c8 ca 20 c8 e5 20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 = ed 20 c8 d1 ca d1 20 c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 = 20 d8 e6 d1 ed 20 df e5 20 cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 = d1 20 dd d1 c7 e4 d3 e5 20 c8 c7 20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd = 20 32 30 20 c7 e3 ca ed c7 d2 a1 20 e3 de c7 c8 e1
* ا پا يا با ا = اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20 c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 = d2 20 e6 20 cf d1 20 e3 d5
* اف با اي ا يا = با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed c7 20 c8 c7 20 c7
* اف يا ي با ي = ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20 c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 = e6 c7 90 d0 c7 d1 20 df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 = df d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 = ca e6 d1 e4 e3 e4 ca 20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed = e4 20 c8 c7 d1 20 c8 e6 cf 20 df e5 20
* ب اب يفا ا = وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4 20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 = de d1 c7 d1 20 e3 ed 9d 90 d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 = e5 20 cf e4 c8 c7 e1 20 e4 ca ed cc e5 20 e4
* بو ي ، ا با ا = ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8 c7 20 c7 d1 d2 ed
* ابي ب با ي = ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd = c7 d9 20 df e1 c7 d3 9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 = df ed a1 20 ca df e4 ed df ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de = d5 cf 20 cf c7 d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed = c8 20 c7 d5 e1 ed 20 ca ed e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 = c7 ed 20 81 c7 d1 c7 e1 e3 81 ed df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 = ed ed 20 df e4 ed e3 2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 = 20 cf d1 20 c7 cf c7 e3 e5 20 c8 e5 20 df e3
* بو وي چ هاي = ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed 20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 = c7 d1 e5 20 df d1 cf 20 e6 20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 = 20 ca c7 20 de c8 e1 20 c7 d2 20 c7 da
* ا به آ وي چ = ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6 ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed = 20 cf d1 20 c7 ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 = 20 de d1 c7 d1 20 c8 90 ed d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 = c7 d2 20 e3 d4 df e1 c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 = cd e1 20 ce e6 c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed = 20 cf d1 20 c7 cf c7 e3 e5 20 90 dd ca
* و و و با اي = ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20 c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 = 20 e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf = e6 ed 20 c2 e3 c7 cf 90 ed 20 ca c7 20 d4 d1
* و ابقا پا ا = پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81 c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 = ce c8 d1 20 cf c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a = 20 c7 dd d2 c7 ed d4 20 de cf d1 ca 20 c8 cf
* ي با ي ا ، ا = ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1 20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca = df e4 ed df ed 20 e6 20 d1 dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 = da dd 20 c7 e5 e3 20 c8 d1 e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 = c7 ed e4 20 d3 e5 20 c7 d1 cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 = e3 d1 e6 c7 20 cf d1 20 81 c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a = 20 d8 ed 20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 = ca ed 20 df e5 20 cf d1 20 c7 ed ca c7 e1 ed c7 20
* با وو ا ا پا = يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7 d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 = cf d1 20 d5 e6 d1 ca 20 e3
* وافق ف ا يو = ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 = c7 d2 c7 e4 20 e6 20 e3 da e1 e6 e1 ed e4 a1 20 de
* ب ا با يهاي ا = پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7 ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf = d1 20 ca e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 = e4 ed c7 20 d4 d1 df ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 = ed e3 2e 0d 0a c7 e4 ca e5 c7 ed 20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00 00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* *
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C627FFF 000b8000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7DFFF 0003e000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* LPK 6CA60000 6CA67FFF 00008000
* USP10 66650000 666A3FFF 00054000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 7A7C0000 7A80EFFF 0004f000
* SECUR32 7C340000 7C34EFFF 0000f000
* NETRAP 7A810000 7A815FFF 00006000
* SAMLIB 7A820000 7A82EFFF 0000f000
* WS2_32 7A830000 7A843FFF 00014000
* WS2HELP 7A850000 7A857FFF 00008000
* WLDAP32 7A860000 7A889FFF 0002a000
* DNSAPI 7A890000 7A8B3FFF 00024000
* WSOCK32 7A8C0000 7A8C7FFF 00008000
* ole32 7AB70000 7AC5EFFF 000ef000
* XOLEHLP 7AC60000 7AC67FFF 00008000
* MSDTCPRX 7AC70000 7AD26FFF 000b7000
* MTXCLU 7AD30000 7AD3FFFF 00010000
* VERSION 7AD40000 7AD46FFF 00007000
* LZ32 7AD50000 7AD55FFF 00006000
* CLUSAPI 7AD60000 7AD6FFFF 00010000
* RESUTILS 7AD70000 7AD7CFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 7AD80000 7AD8BFFF 0000c000
* iphlpapi 7AD90000 7ADA2FFF 00013000
* ICMP 7ADB0000 7ADB4FFF 00005000
* MPRAPI 7ADC0000 7ADD6FFF 00017000
* OLEAUT32 7ADE0000 7AE7AFFF 0009b000
* ACTIVEDS 7AE80000 7AEAEFFF 0002f000
* ADSLDPC 7AEB0000 7AED2FFF 00023000
* RTUTILS 7AEE0000 7AEEDFFF 0000e000
* SETUPAPI 7AEF0000 7AF7DFFF 0008e000
* RASAPI32 7AF80000 7AFB2FFF 00033000
* RASMAN 7AFC0000 7AFD0FFF 00011000
* TAPI32 7AFE0000 7B001FFF 00022000
* COMCTL32 7B010000 7B093FFF 00084000
* SHLWAPI 7B0A0000 7B104FFF 00065000
* DHCPCSVC 7B110000 7B128FFF 00019000
* winrnr 7B5D0000 7B5D7FFF 00008000
* rasadhlp 7B5E0000 7B5E4FFF 00005000
* SSNETLIB 7BDA0000 7BDB4FFF 00015000
* NTMARTA 7BE00000 7BE1CFFF 0001d000
* WINSPOOL 7BE20000 7BE3DFFF 0001e000
* MPR 7BE40000 7BE4FFFF 00010000
* NTDSAPI 7BE50000 7BE60FFF 00011000
* security 003F0000 003F3FFF 00004000
* msafd 10450000 1046DFFF 0001e000
* wshtcpip 10470000 10476FFF 00007000
* SSmsLPCn 10500000 10507FFF 00008000
* SSnmPN70 410D0000 410D5FFF 00006000
* rsabase 7CA00000 7CA22FFF 00023000
* CRYPT32 7C740000 7C7C6FFF 00087000
* MSASN1 109A0000 109AFFFF 00010000
* SQLFTQRY 10BD0000 10C01FFF 00032000
* CLBCATQ 10C10000 10C9FFFF 00090000
* sqloledb 10CC0000 10D32FFF 00073000
* MSDART 10D40000 10D5EFFF 0001f000
* comdlg32 10D60000 10D9DFFF 0003e000
* SHELL32 10DA0000 10FE7FFF 00248000
* MSDATL3 10FF0000 11004FFF 00015000
* oledb32 1F8A0000 1F905FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* msv1_0 11340000 11360FFF 00021000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 11370000 11386FFF 00017000
* ODBC32 11390000 113C1FFF 00032000
* odbcbcp 113D0000 113D5FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* SHFOLDER 113E0000 113E7FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 114F0000 114F6FFF 00007000
* SQLSVC 11500000 11505FFF 00006000
* xpstar 11510000 11518FFF 00009000
* dbghelp 167A0000 16854FFF 000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 43B19918 43B190C0 43F7C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 43B551D8: 00000034 00000000 01178E38 000094FE 00000000 00000000 * Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E 00000000 00000000 00000000 * Edx: FFFFFFFF: * Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 10A2B644 10A2B8E7 780238AE * SegCs: 0000001B: * EFlags: 00010246: 00720067 006D0061 00460020 006C0069 00730065 004D005C * Esp: 10A2AC94: 43B55508 00000000 43B551D8 10A2ACDC 43B55000 10A2AC94 * SegSs: 00000023: * ***********************************************************
********************
* ----
--
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E) (CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29) (utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E) (RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7) (RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57) (Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787) (DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F) (DataSplitMgr::RegularSplitPoint+00000099)
* 0043F481 Module(sqlservr+0003F481) (DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337) (DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7) (InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375) (RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229) (CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149) (SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400) (CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91) (CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6) (CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E) (CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3) (CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF) (CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C) (CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A) (CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB) (CMsqlExecContext::ExecuteStmts+000003B9)
* 0041BA11 Module(sqlservr+0001BA11) (CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D) (CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262) (CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37) (CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29) (CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A) (process_commands+00000232)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
--
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File: <R:\sql\ntdbms\storeng\drs\include\record.inl>, line=3D1447 Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad RezaYour database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:
Hello,
We have a SQL Server 2000 on a remote server in Texas, we send our data over TCP/IP every 3 minutes to SQL Server but from 1 one week ago we found an error on SQL Server so we cannot send data to SQL Server.
Errors are as below:
++++++++++
++++++++++
++++++++++
Using 'dbghelp.dll' version '4.0.5'
*Dump thread - spid =3D 52, PSS =3D 0x43b551d8, EC =3D 0x43b55508
*Stack Dump being sent to d:\sql2000
\data\MSSQL\log\SQLDump0459.txt
* ************************************************
*
* BEGIN STACK DUMP:
* 06/06/04 16:58:48 spid 52
*
* *
* s p _ e x e c u 0a 00 73 00 70 00 5f 00 65 00 78 00 65 00 63 00 75 00
* t e & & 74 00 65 00 00 00 00 00 26 04 04 09 00 00 00 00 00 26
* "ي #=AD 04 04 93 ed 05 00 00 00 23 ad 05 00 00 00 00 00 00 00
* =AD بي ي ي ad 05 00 00 d3 d1 e3 d1 = c8 ed 20 ca ed e3 20 e3 e1 ed
* ب با با وي چ 20 = c8 d3 df ca c8 c7 e1 20 c8 c7 20 e6 ed e1 8d d1 20
* با بيا اي ه = و c8 c7 20 c8 ed c7 e4 20 c7 ed e4 20 df e5 20 ca e6 d1
* چها ا به ي e4 e3 e4 = ca 20 8d e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20
* اي ا يا وبي = ب c7 ed ca c7 e1 ed c7 20 e3 cd df 20 ce e6 c8 ed 20 c8
* اي ا ايي ف ا d1 = c7 ed 20 d4 e4 c7 d3 c7 ed ed 20 e4 dd d1 c7 ca 20
* ا ا ي به پا ا = پي c7 da d2 c7 e3 ed 20 c8 e5 20 81 c7 d1 c7 e1 e3 81 ed
* آ بو ، ف : آ df 20 c2 ca e4 = 20 c8 e6 cf a1 20 90 dd ca 3a 20 c2 90
* اهي وبي ا و = و c7 e5 ed 20 ce e6 c8 ed 20 c7 d2 20 e4 e6 da 20 e6 20
* يوه با ي يفا = d4 ed e6 e5 20 c8 c7 d2 ed 20 cd d1 ed dd c7 e4 20 ce
* و ا پي پي ا e6 cf 20 = cf d1 20 c7 e1 e3 81 ed df 20 81 ed cf c7 20
* ي . غفو ا df d1 cf ed e3 2e 20 = 0d 0a db dd e6 d1 20 df c7 e3 d1
* وا پ ا با ي e6 c7 20 = 81 d3 20 c7 d2 20 c8 c7 d2 90 d4 ca 20 ca ed
* ي ا ابقا چ e3 20 e3 = e1 ed 20 c7 d2 20 e3 d3 c7 c8 de c7 ca 20 8d
* ها ا به ي اي = ا ي e5 c7 d1 20 cc c7 e4 c8 e5 9d ed 20 c7 ed ca c7 e1 ed
* ا به ب ا ي ا c7 20 c8 = e5 20 ce c8 d1 90 d2 c7 d1 ed 20 cf c7 e4 d4
* ويا اي ا (اي = ا cc e6 ed c7 e4 20 c7 ed d1 c7 e4 20 28 c7 ed d3 e4 c7
* )، ف : اي و 29 a1 20 90 dd ca 3a = 20 cf d1 20 c7 ed e4 20 ca e6 d1
* ي هايي چو e4 e3 e4 = ca 20 ca ed e3 9d e5 c7 ed ed 20 8d e6 e4 20
* اي ا يا، قه ا = ا c7 ed ca c7 e1 ed c7 a1 20 de e5 d1 e3 c7 e4 20 c7 d1
* وپا و ف ا ه و = ا پ e6 81 c7 20 e6 20 dd d1 c7 e4 d3 e5 20 e6 20 c7 d3 81
* ا يا ي هاي و = و c7 e4 ed c7 20 ca ed e3 e5 c7 ed 20 d3 e6 e3 20 e6 20
* چها ا وپا 8d e5 c7 = d1 e3 20 c7 d1 e6 81 c7 20 d4 d1 df ca 20 df
* ه بو ه و d1 cf e5 20 c8 e6 cf = e4 cf 20 df e5 20 e6 d1 d2 d4 df
* ا ا اي ي ها ا c7 = d1 c7 e4 20 c7 ed e4 20 ca ed e3 9d e5 c7 20 c7 d2
* اظ ي ي و ا 20 e1 cd c7 d9 = 20 ca df e4 ed df ed 20 e6 20 ca c7 df
* ي ي ب به ي ca ed df ed 20 = e4 d3 c8 ca 20 c8 e5 20 ca ed e3 20 e3
* ا ي ي ب بو . c7 20 ce ed e1 = ed 20 c8 d1 ca d1 20 c8 e6 cf e4 cf 2e
* به و ي ه ب ا 20 c8 e5 = 20 d8 e6 d1 ed 20 df e5 20 cf d1 20 c8 d1 c7
* ب ف ا ه با ا ا c8 = d1 20 dd d1 c7 e4 d3 e5 20 c8 c7 20 c7 ce ca e1 c7
* ف 20 ا يا ، قاب dd = 20 32 30 20 c7 e3 ca ed c7 d2 a1 20 e3 de c7 c8 e1
* ا پا يا با ا = اف 20 c7 d3 81 c7 e4 ed c7 20 c8 c7 20 c7 ce ca e1 c7 dd
* 12 ا يا و 20 31 32 20 c7 e3 ca ed c7 = d2 20 e6 20 cf d1 20 e3 d5
* اف با اي ا يا = با ا c7 dd 20 c8 c7 20 c7 ed ca c7 e1 ed c7 20 c8 c7 20 c7
* اف يا ي با ي = ه ce ca e1 c7 dd 20 d2 ed c7 cf ed 20 c8 c7 d2 ed 9d e5
* ا ا وا ا ي . c7 20 d1 c7 20 = e6 c7 90 d0 c7 d1 20 df d1 cf ed e3 2e
* وي ي : 0d 0a e6 ed 20 ca d5 d1 ed cd 20 = df d1 cf 3a 20 cf d1
* اي و ب اي 20 c7 ed e4 20 = ca e6 d1 e4 e3 e4 ca 20 c8 d1 c7 ed 20
* ي با بو ه e4 ce d3 ca ed = e4 20 c8 c7 d1 20 c8 e6 cf 20 df e5 20
* ب اب يفا ا = وپا c8 d1 c7 c8 d1 20 cd d1 ed dd c7 e4 20 c7 d1 e6 81 c7
* يي ق ا ي ف ي ed ed 20 = de d1 c7 d1 20 e3 ed 9d 90 d1 dd ca ed e3 20
* و به با ي ه e6 20 c8 = e5 20 cf e4 c8 c7 e1 20 e4 ca ed cc e5 20 e4
* بو ي ، ا با ا = ي c8 e6 cf ed e3 a1 20 e1 d0 c7 20 c8 c7 20 c7 d1 d2 ed
* ابي ب با ي = ها c7 c8 ed 20 c8 d3 df ca c8 c7 e1 ed d3 ca 9d e5 c7 20
* ا اظ ا ب ي c7 d2 20 e1 cd = c7 d9 20 df e1 c7 d3 9d c8 e4 cf ed 20
* پ ي، ي ي و ا 81 d2 d4 = df ed a1 20 ca df e4 ed df ed 20 e6 20 ca c7
* ي ي ق ا ي df ca ed df ed 20 de = d5 cf 20 cf c7 d4 ca ed e3 20 ca
* يب ا ي ي ا ب d1 df ed = c8 20 c7 d5 e1 ed 20 ca ed e3 20 d1 c7 20 c8
* اي پا ا پي آ d1 = c7 ed 20 81 c7 d1 c7 e1 e3 81 ed df 20 c2 ca e4 20
* ا ايي ي . ا d4 e4 c7 d3 c7 = ed ed 20 df e4 ed e3 2e 0d 0a df c7 e3
* وا ا ا ه به d1 e6 c7 = 20 cf d1 20 c7 cf c7 e3 e5 20 c8 e5 20 df e3
* بو وي چ هاي = ا ب c8 e6 cf 20 e6 ed e1 8d d1 e5 c7 ed 20 e3 e4 c7 d3 c8
* ا ا ه و اف و 20 c7 d4 = c7 d1 e5 20 df d1 cf 20 e6 20 c7 dd d2 e6 cf
* : ا ا قب ا ا 3a 20 c7 90 d1 = 20 ca c7 20 de c8 e1 20 c7 d2 20 c7 da
* ا به آ وي چ = ها d2 c7 e3 20 c8 e5 20 c2 ca e4 20 e6 ed e1 8d d1 e5 c7
* ي ي ا يا ed 20 e3 cf d1 e4 ed = 20 cf d1 20 c7 ce ca ed c7 d1 20
* ي ق ا ب ي ، ب ca ed e3 = 20 de d1 c7 d1 20 c8 90 ed d1 cf a1 20 c8 d3
* يا ي ا ا و ed c7 d1 ed 20 = c7 d2 20 e3 d4 df e1 c7 ca 20 e6 d1 d2
* ا ا واه d4 df c7 d1 c7 e4 20 = cd e1 20 ce e6 c7 e5 cf 20 d4 cf
* . وي ا ا ه ف 2e 0d 0a e6 ed = 20 cf d1 20 c7 cf c7 e3 e5 20 90 dd ca
* و و و با اي = ا، 9d e6 90 e6 20 ce e6 cf 20 c8 c7 20 c7 ed d3 e4 c7 a1
* ا ي 3 ه 20 c7 d2 20 ca d4 df ed e1 20 33 = 20 e3 d1 cd e1 e5 20
* ا وي آ ا ي ا c7 d1 cf = e6 ed 20 c2 e3 c7 cf 90 ed 20 ca c7 20 d4 d1
* و ابقا پا ا = پ e6 da 20 e3 d3 c7 c8 de c7 ca 20 81 c7 d1 c7 e1 e3 81
* ي آ ب ا و ed df 20 c2 ca e4 20 = ce c8 d1 20 cf c7 cf 20 e6 20 90
* ف : اف اي ق ب dd ca 3a = 20 c7 dd d2 c7 ed d4 20 de cf d1 ca 20 c8 cf
* ي با ي ا ، ا = ها e4 ed 20 c8 c7 d2 ed df e4 c7 e4 a1 20 df c7 d1 e5 c7
* ي ي ي و ف قا ed 20 ca = df e4 ed df ed 20 e6 20 d1 dd da 20 e4 de c7
* ف اه ب ا ه ه d8 20 d6 = da dd 20 c7 e5 e3 20 c8 d1 e4 c7 e3 e5 20 e5
* اي اي ه ا و . c7 ed 20 = c7 ed e4 20 d3 e5 20 c7 d1 cf e6 d3 ca 2e 0d
* ا وا پايا 0a df c7 = e3 d1 e6 c7 20 cf d1 20 81 c7 ed c7 e4 20 ca
* ا ي : ي ا c7 df ed cf 20 df d1 cf 3a = 20 d8 ed 20 e3 d0 c7 df d1
* ا ي ه اي ا يا c7 = ca ed 20 df e5 20 cf d1 20 c7 ed ca c7 e1 ed c7 20
* با وو ا ا پا = يا c8 c7 20 e3 d3 e6 e6 e1 c7 e4 20 c7 d3 81 c7 e4 ed c7
* ا ي ، و 20 cf c7 d4 ca ed e3 a1 20 = cf d1 20 d5 e6 d1 ca 20 e3
* وافق ف ا يو = ا e6 c7 dd de ca 20 dd cf d1 c7 d3 ed e6 e4 20 cc c7 e4
* با ا و و ي ، ق c8 = c7 d2 c7 e4 20 e6 20 e3 da e1 e6 e1 ed e4 a1 20 de
* ب ا با يهاي ا = پ c8 e1 20 c7 d2 20 c8 c7 d2 ed e5 c7 ed 20 c7 e1 e3 81
* ي آ ، و ed df 20 c2 ca e4 a1 20 cf = d1 20 ca e6 d1 e4 e3 e4 ca
* ا پا يا ي 20 c7 d3 81 c7 = e4 ed c7 20 d4 d1 df ca 20 e3 ed 9d df
* ي . ا هاي پيا e4 = ed e3 2e 0d 0a c7 e4 ca e5 c7 ed 20 81 ed c7 e3 00
* # # 00 23 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23
* # 00 00 00 00 00 00 00 00 00 ff ff ff ff 00 00 23 00 00
* o " 00 00 00 00 00 00 00 ff ff ff ff 00 00 6f 08 08 f8 94
* =B1 00 00 d8 1b b1 00
* *
* MODULE BASE END SIZE
* sqlservr 00400000 00B32FFF 00733000
* ntdll 77F80000 77FFCFFF 0007d000
* KERNEL32 7C570000 7C627FFF 000b8000
* ADVAPI32 7C2D0000 7C331FFF 00062000
* RPCRT4 77D30000 77DA0FFF 00071000
* USER32 77E10000 77E74FFF 00065000
* GDI32 77F40000 77F7DFFF 0003e000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107BFFF 0000c000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* LPK 6CA60000 6CA67FFF 00008000
* USP10 66650000 666A3FFF 00054000
* sqlevn70 10000000 10006FFF 00007000
* NETAPI32 7A7C0000 7A80EFFF 0004f000
* SECUR32 7C340000 7C34EFFF 0000f000
* NETRAP 7A810000 7A815FFF 00006000
* SAMLIB 7A820000 7A82EFFF 0000f000
* WS2_32 7A830000 7A843FFF 00014000
* WS2HELP 7A850000 7A857FFF 00008000
* WLDAP32 7A860000 7A889FFF 0002a000
* DNSAPI 7A890000 7A8B3FFF 00024000
* WSOCK32 7A8C0000 7A8C7FFF 00008000
* ole32 7AB70000 7AC5EFFF 000ef000
* XOLEHLP 7AC60000 7AC67FFF 00008000
* MSDTCPRX 7AC70000 7AD26FFF 000b7000
* MTXCLU 7AD30000 7AD3FFFF 00010000
* VERSION 7AD40000 7AD46FFF 00007000
* LZ32 7AD50000 7AD55FFF 00006000
* CLUSAPI 7AD60000 7AD6FFFF 00010000
* RESUTILS 7AD70000 7AD7CFFF 0000d000
* USERENV 7C0F0000 7C150FFF 00061000
* rnr20 7AD80000 7AD8BFFF 0000c000
* iphlpapi 7AD90000 7ADA2FFF 00013000
* ICMP 7ADB0000 7ADB4FFF 00005000
* MPRAPI 7ADC0000 7ADD6FFF 00017000
* OLEAUT32 7ADE0000 7AE7AFFF 0009b000
* ACTIVEDS 7AE80000 7AEAEFFF 0002f000
* ADSLDPC 7AEB0000 7AED2FFF 00023000
* RTUTILS 7AEE0000 7AEEDFFF 0000e000
* SETUPAPI 7AEF0000 7AF7DFFF 0008e000
* RASAPI32 7AF80000 7AFB2FFF 00033000
* RASMAN 7AFC0000 7AFD0FFF 00011000
* TAPI32 7AFE0000 7B001FFF 00022000
* COMCTL32 7B010000 7B093FFF 00084000
* SHLWAPI 7B0A0000 7B104FFF 00065000
* DHCPCSVC 7B110000 7B128FFF 00019000
* winrnr 7B5D0000 7B5D7FFF 00008000
* rasadhlp 7B5E0000 7B5E4FFF 00005000
* SSNETLIB 7BDA0000 7BDB4FFF 00015000
* NTMARTA 7BE00000 7BE1CFFF 0001d000
* WINSPOOL 7BE20000 7BE3DFFF 0001e000
* MPR 7BE40000 7BE4FFFF 00010000
* NTDSAPI 7BE50000 7BE60FFF 00011000
* security 003F0000 003F3FFF 00004000
* msafd 10450000 1046DFFF 0001e000
* wshtcpip 10470000 10476FFF 00007000
* SSmsLPCn 10500000 10507FFF 00008000
* SSnmPN70 410D0000 410D5FFF 00006000
* rsabase 7CA00000 7CA22FFF 00023000
* CRYPT32 7C740000 7C7C6FFF 00087000
* MSASN1 109A0000 109AFFFF 00010000
* SQLFTQRY 10BD0000 10C01FFF 00032000
* CLBCATQ 10C10000 10C9FFFF 00090000
* sqloledb 10CC0000 10D32FFF 00073000
* MSDART 10D40000 10D5EFFF 0001f000
* comdlg32 10D60000 10D9DFFF 0003e000
* SHELL32 10DA0000 10FE7FFF 00248000
* MSDATL3 10FF0000 11004FFF 00015000
* oledb32 1F8A0000 1F905FFF 00066000
* OLEDB32R 1F910000 1F91FFFF 00010000
* msv1_0 11340000 11360FFF 00021000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 11370000 11386FFF 00017000
* ODBC32 11390000 113C1FFF 00032000
* odbcbcp 113D0000 113D5FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 41090000 410BCFFF 0002d000
* SHFOLDER 113E0000 113E7FFF 00008000
* odbcint 1F850000 1F865FFF 00016000
* NDDEAPI 114F0000 114F6FFF 00007000
* SQLSVC 11500000 11505FFF 00006000
* xpstar 11510000 11518FFF 00009000
* dbghelp 167A0000 16854FFF 000b5000
*
* Edi: 43B55508: 43B551D8 43F7D418 43F7D418 43B19918 43B190C0 43F7C030 * Esi: 00000000: * Eax: 00000000: * Ebx: 43B551D8: 00000034 00000000 01178E38 000094FE 00000000 00000000 * Ecx: 10A2ACDC: 00000000 0001003F 3CFBD11E 00000000 00000000 00000000 * Edx: FFFFFFFF: * Eip: 0087FE8E: 4D830088 75FFFFFC 0875FF0C E8E04D8B 0000002D 64F04D8B * Ebp: 10A2ACC0: 10A2B4E0 0088199F 43B551D8 10A2B644 10A2B8E7 780238AE * SegCs: 0000001B: * EFlags: 00010246: 00720067 006D0061 00460020 006C0069 00730065 004D005C * Esp: 10A2AC94: 43B55508 00000000 43B551D8 10A2ACDC 43B55000 10A2AC94 * SegSs: 00000023: * ***********************************************************
********************
* ----
--
* Short Stack Dump
* 0087FE8E Module(sqlservr+0047FE8E) (CStackDump::GetContextAndDump+0000002E)
* 0088199F Module(sqlservr+0048199F) (stackTrace+00000223)
* 00935D29 Module(sqlservr+00535D29) (utassert_fail+000002E3)
* 005B483E Module(sqlservr+001B483E) (RecBase::Resize+00000091)
* 004035D7 Module(sqlservr+000035D7) (RecBase::Size+0000000E)
* 0040DD57 Module(sqlservr+0000DD57) (Page::GetRowSize+0000002A)
* 0050C787 Module(sqlservr+0010C787) (DataSplitMgr::MoveRecord+0000002E)
* 0050D18F Module(sqlservr+0010D18F) (DataSplitMgr::RegularSplitPoint+00000099)
* 0043F481 Module(sqlservr+0003F481) (DataSplitMgr::FindSplitPoint+00000046)
* 0043F337 Module(sqlservr+0003F337) (DataSplitMgr::SplitPage+00000022)
* 0043FDD8 Module(sqlservr+0003FDD8) (datasplit+0000002A)
* 004366A7 Module(sqlservr+000366A7) (InsertRowIntoNCIndex+0000027C)
* 004363DD Module(sqlservr+000363DD) (ncupdate+000001FA)
* 00411BBC Module(sqlservr+00011BBC) (rowinsert+0000012E)
* 00412085 Module(sqlservr+00012085) (insert+00000013)
* 00413375 Module(sqlservr+00013375) (RowsetSS::InsertRow+000001F2)
* 00411229 Module(sqlservr+00011229) (CValRow::SetDataX+00000035)
* 00411149 Module(sqlservr+00011149) (SetDataWithPop+0000001C)
* 00411400 Module(sqlservr+00011400) (CEs::GeneralEval+00000088)
* 0042AF91 Module(sqlservr+0002AF91) (CQScanScalarInsert::GetRow+00000035)
* 0043E6F6 Module(sqlservr+0003E6F6) (CQScanNLJoin::GetRow+0000010B)
* 004B341E Module(sqlservr+000B341E) (CQScanAssert::GetRow+0000001B)
* 004110B3 Module(sqlservr+000110B3) (CQueryScan::GetRow+00000014)
* 0041D3EF Module(sqlservr+0001D3EF) (CStmtQuery::ErsqExecuteQuery+00000357)
* 0041E02C Module(sqlservr+0001E02C) (CStmtDML::XretExecuteNormal+000002AE)
* 0041DE5A Module(sqlservr+0001DE5A) (CStmtDML::XretExecute+0000001C)
* 0041C3CB Module(sqlservr+0001C3CB) (CMsqlExecContext::ExecuteStmts+000003B9)
* 0041BA11 Module(sqlservr+0001BA11) (CMsqlExecContext::Execute+000001B6)
* 0041B02D Module(sqlservr+0001B02D) (CSQLSource::Execute+00000357)
* 005F257E Module(sqlservr+001F257E) (SpExecute+00000227)
* 005F4262 Module(sqlservr+001F4262) (CSpecProc::ExecuteSpecial+00000264)
* 005F3D37 Module(sqlservr+001F3D37) (CXProc::Execute+000000A3)
* 005F5F29 Module(sqlservr+001F5F29) (CSQLSource::Execute+000003C0)
* 00437EC6 Module(sqlservr+00037EC6) (execrpc+00000507)
* 00437128 Module(sqlservr+00037128) (execute_rpc+00000019)
* 0042921A Module(sqlservr+0002921A) (process_commands+00000232)
* 41072838 Module(UMS+00002838) (ProcessWorkRequests+00000272)
* 410725B3 Module(UMS+000025B3) (ThreadStartRoutine+00000098)
* 78008454 Module(MSVCRT+00008454) (endthread+000000C1)
* 7C57438B Module(KERNEL32+0000438B) (TlsSetValue+000000F0)
* ----
--
++++++++++
++++++++++
++++++++++
Stack Signature for the dump is 0x8FCB01BD
++++++++++
++++++++++
++++++++++
SQL Server Assertion: File: <R:\sql\ntdbms\storeng\drs\include\record.inl>, line=3D1447 Failed Assertion =3D 'm_SizeRec > 0 && m_SizeRec <=3D MAXDATAROW'.
++++++++++
++++++++++
++++++++++
Error: 3624, Severity: 20, State: 1.
++++++++++
++++++++++
++++++++++
Would you please help me to solve the problem.
Yours Sincerely,
Ahmad RezaYour database is corrputed.
Run DBCC CheckDB
Bojidar Alexandrov
"Ahmad Reza" <anonymous@.discussions.microsoft.com> wrote in message
news:18d8301c44bcc$b70b5000$a101280a@.phx.gbl...
Dear Sir/Madam,
Hello,
We have a SQL Server 2000 on a remote server in Texas, we
send our data over TCP/IP every 3 minutes to SQL Server
but from 1 one week ago we found an error on SQL Server so
we cannot send data to SQL Server.
Errors are as below:
Wednesday, March 21, 2012
Error: 18456, Severity: 14, State: 11.
i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.
i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.
2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
where HOSTNAME is the hostname of the pc that sql server 2005 is running.
XX.XX.XX.XX is the ip address of the client which is running component database manager tool.
what am i doing wrong here.
YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||that did it.
i dont have any clue why it works. but that did it.
thanks a million.
we should call you Mr. Geniusmeyer!!!
|||i have another problem.
i can connect to the sql server 2005 express from one laptop.
however, if i try from another laptop i get the above error.
what is wrong with the second pc.
thanks,
jeff
|||Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
no the first post was state 11. This error is state 16.
im not sure what stored user credentials are.
are you talking about on the db client machine?
|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice
Thanks in advance,
Venkat
|||
Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....
Thanks,
Regards
JD
Error: 18456, Severity: 14, State: 11.
i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.
i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.
2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
where HOSTNAME is the hostname of the pc that sql server 2005 is running.
XX.XX.XX.XX is the ip address of the client which is running component database manager tool.
what am i doing wrong here.
YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||that did it.
i dont have any clue why it works. but that did it.
thanks a million.
we should call you Mr. Geniusmeyer!!!
|||i have another problem.
i can connect to the sql server 2005 express from one laptop.
however, if i try from another laptop i get the above error.
what is wrong with the second pc.
thanks,
jeff
|||Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||
no the first post was state 11. This error is state 16.
im not sure what stored user credentials are.
are you talking about on the db client machine?
|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice
Thanks in advance,
Venkat
|||
Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....
Thanks,
Regards
JD
Error: 18456, Severity: 14, State: 11.
i am new to sql server 2005 express. I am trying to set up xp embedded database. I am trying to allow remote access to a central xp embedded database. i have the database on the sql server machine.
i am using the component database manager toll on a remote machine so that i can connect to the remote xp embedded database. when i try to connect to the db through sql server i get the following error in the log file.
2006-09-12 17:15:10.18 Logon Error: 18456, Severity: 14, State: 11.
2006-09-12 17:15:10.18 Logon Login failed for user 'HOSTNAME\Guest'. [CLIENT: XX.XX.XX.XX]
where HOSTNAME is the hostname of the pc that sql server 2005 is running.
XX.XX.XX.XX is the ip address of the client which is running component database manager tool.
what am i doing wrong here.
YOu will have to disable simple filesharing at the WIndows box, because the user will be otherwise authenticated by the Guest user.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
|||that did it.
i dont have any clue why it works. but that did it.
thanks a million.
we should call you Mr. Geniusmeyer!!!
|||i have another problem.
i can connect to the sql server 2005 express from one laptop.
however, if i try from another laptop i get the above error.
what is wrong with the second pc.
thanks,
jeff
|||Do you have stored user credentials on that machine ? is the error message the same as the one mentioned in the first post ?
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
no the first post was state 11. This error is state 16.
im not sure what stored user credentials are.
are you talking about on the db client machine?
|||Stored credentials can be found navigating to the to the Control Panel > User Accounts > Choose the User > manage you network accounts. You might have a fixed stored credential enetered there ?HTH; Jens Suessmeyer.
http://www.sqlserver2005.de
|||Simple file sharing is not at all enables on my machine. I still have this problem when I tried to connect from a sql server 2000 machine to any other version of sql server using linked server. Please advice
Thanks in advance,
Venkat
|||
Hi, have you ever received an answer or solution to this one? I am experiencing the same problem, went through all the same steps. Windows has no info on their website that I could find....
Thanks,
Regards
JD
sqlError: 18456, Severity: 14, State: 11 Valid login but server access failure
Hi
I am new to SQL server and I have been trying hard to make a client computer to remote connect to a SQL express database on host computer
I have a VB6 application that can connect to SQL server database LOCALLY without problem:
Connection String is:
my_connection.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=MyMushroom;Data Source=LAPTOP\SQLEXPRESS"
I have followed instruction on enabling remote connection function from this blog:
http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx
I then try to run the same app from the client computer, it gives me:
Login failed for user 'LAPTOP\Guest'.
After looking up the web for solution, I found that I can test the connection from the HOST computer in this way:
C:\Documents and Settings\kit>sqlcmd -E -S laptop\sqlexpress
1>
2>
The test is successful
Now I run the same command on the CLIENT computer
C:\Documents and Settings\Kit>sqlcmd -E -S laptop\sqlexpress
Msg 18456, Level 14, State 1, Server LAPTOP\SQLEXPRESS, Line 1
Login failed for user 'LAPTOP\Guest'.
Now I can sure that from the client computer it cannot make a connection to it, then I look at the errorLog from my host computer
2006-08-13 21:41:00.34 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:41:00.34 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:45:10.64 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:45:10.64 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
2006-08-13 21:48:41.80 Logon Error: 18456, Severity: 14, State: 11.
2006-08-13 21:48:41.80 Logon Login failed for user 'LAPTOP\Guest'. [CLIENT: 192.168.0.5]
Now I know it is actually Error: 18456, Severity: 14, State: 11.
From this site : http://blogs.msdn.com/sql_protocols/archive/2006/02/21/536201.aspx
11 and 12 | Valid login but server access failure |
It tells the connection string and SQL Express seem to be set up properly but the server access failed the remote connection
I have previously had SQL Server 2000 installed. I uninstalled SQL 2000 before I install SQL express but somehow the SQL Server Service Manager is still running at startup, and C:\Program Files\Microsoft SQL Server\80 and its files are still exist after uninstallation..... Could this be a problem?
The Knowledge base suggestion on "enabling remote connection" is very simple and I do not understand why it is so difficult to me just to make a remote connection test work..... please, I need your help.
If you want to use Windows Authentication you have to disable the "Simple File and printer sharing" at the "server" (even if its only WIndows XP). With this option enabled, it normally simplifies the logon process as the requestor does not have to give a user name and a password, because he will be logged on with the Guest user.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de|||I did try to disable the file sharing, and also have firewall disabled. But it still gives me the same error..... 
OK, did you disable that on the "server" (Whereever SQL Server is running on) ?
-Jens.
|||Yes, to make sure file sharing is disabled , I unlick the Simple File Sharing from Folder Option on both computers.
Both computer have file sharing disabled
filewall disabled
But I am still getting the same error.
Anything to do with MSDE 2000 instance? I have uninstalled MSDE2000 before I install SQL expresss.
What is wrong still?
By the way, I restarted both computer and still got the same error on the client computer while the hosting computer is connecting to the KIT\SQLExpress alright :
C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1>
2>
3>
4>
5>
Here is the current setting of my SQLexpress instance
SQL Server Config. Manager
Protoal: Shared Memory, TCP/IP enabled (Name Pipes and VIA disabled)
SQL server (SQLExpress) and SQL server Browser are running , startmode: automatic
For SQL Server Browser: Log on as : Bulit-in account: Network Service
For SQL Server (SQLExpress): Log on as : Bulit-in account: Network Service
Under Service - General -
Host Name: KIT
Name: SQL Server (SQLExpress)
SQL Native Config. - Client Protocols - Shard Memory 1, TCP/IP 2
SQL Server Surface Area Config.
Service Name: MSSQL$SQLEXPRESS
Display Name: SQL Server (SQLEXPRESS)
Remote COnnection: Local and Remote connection clicked - Using TCP/IP Only clicked
The client computer do not have any SQL express installed, could that be the reason?
Frankly, on the server computer , it can connect to the database on TCP/IP using SQL Management Studio
Here I attached the screen shots
http://www.megaupload.com/?d=JWN349QL
|||
I have a few questions about your setup:
- on the client machine, what account is your application running under?
- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out)
Thanks
Laurentiu
Client is running Win XP Professional SP2
Server is running Win XP pro SP2
Client machine is logged in as Admin , without password (so it goes straight into the OS when you start up the machine and bypass the log in screen)
Server machine is also logged in as Admin, with passowrd (log-in: Kit, password: Kit) , TweakUI is setup to log in automatically using the log-in/password pair.
- when you tried connecting to SQL Express locally, using sqlcmd, what was the account you actually connected as? (you can execute "select suser_name()" to find this out) :
C:\Documents and Settings\Kit>sqlcmd -E -S kit\sqlexpress
1> select suser_name()
2> go
--
KIT\Kit
(1 rows affected)
1>
Hope this will give you idea of what has gone wrong with my SQL express setting
Thank you for your response.
|||
On the Server Computer , under Control Panel -> User Accounts , there are 3 accounts: Kit (myself), SQLDebugger and Guest
Guest account is not password protected and is set to off. (I've tried to turn this account on and off but the client computer still give me the same error)
I really havae no idea what I have gone it wrong...
|||
I just realize what you meant by "on the client machine, what account is your application running under?"
It is running under Network Service
|||Locally, you connect as Kit, which seems to have server access. Remotely, you appear to execute as Network Service and when you get on the server machine, you are actually running as Guest, which does not have server access.
If you execute
CREATE LOGIN [Laptop\Guest] FROM WINDOWS
then you will grant server access to the Guest account.
But if you want your application to connect as Kit, you should run it as Kit or it should internally impersonate Kit before connecting to the server.
Thanks
Laurentiu
To Laurentiu and Jens:
Thank you for your great help and now the client can connect to the server SQL express. I have been myself studying the SQL server and exploring how SQL server work. This SQL express is very interesting and I have a lot more to learn about this "toy".
I am very appreciated to your helps.
Kit
Sunday, February 19, 2012
Error while setting up Replication
I am trying to set up replication from a remote server (YYYY) to a server
(XXXX) on my company's network. The remote server will be the publisher and
the local server will be the distributor and subscriber. It gives me the
following error when I configure the publisher and distributor :
SQL Server could not configure 'XXXX' as the Distributor for 'YYYY'.
Error 17: SQL Server does not exist or access denied.
I could log on as 'sa' to the remote server (YYYY) as well as the local
server (XXXX) via SQL Enterprise manager.
I know port #1433 is opened up. What other ports do I need to open up ? From
where ?
Please help
TIA
Mo
It might be a naming issue.
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||You have to use the netbios names of the publisher and subscriber. Register
both in EM using the netbios names. Hide the fqdn (if you need to use it) by
using a server alias using Client Network Utility.
Have you set up an administrative link password? Disable this option to make
debugging simpler.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MO" <MO@.discussions.microsoft.com> wrote in message
news:86384240-283C-42CA-A5A6-15647FDA34B8@.microsoft.com...
> I am trying to set up replication from a remote server (YYYY) to a server
> (XXXX) on my company's network. The remote server will be the publisher
and
> the local server will be the distributor and subscriber. It gives me the
> following error when I configure the publisher and distributor :
> SQL Server could not configure 'XXXX' as the Distributor for 'YYYY'.
> Error 17: SQL Server does not exist or access denied.
> I could log on as 'sa' to the remote server (YYYY) as well as the local
> server (XXXX) via SQL Enterprise manager.
> I know port #1433 is opened up. What other ports do I need to open up ?
From
> where ?
> Please help
> TIA
> Mo
>
|||Thanks Paul for the quick reply. The sql instance name is say 'AAAA' and when
I run @.@.servername it returns 'AAAA'. The windows server name is say 'WWWW'.
TIA
MO
"Paul Ibison" wrote:
> It might be a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Some of the things you mentioned are above my head.
When you say netbios names of the publisher and subscriber you mean the
windows server name ? How do I know the netbios name ?
Hide the fqdn... What is fqdn ? and how do I hide it ?
TIA
MO
"Hilary Cotter" wrote:
> You have to use the netbios names of the publisher and subscriber. Register
> both in EM using the netbios names. Hide the fqdn (if you need to use it) by
> using a server alias using Client Network Utility.
> Have you set up an administrative link password? Disable this option to make
> debugging simpler.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "MO" <MO@.discussions.microsoft.com> wrote in message
> news:86384240-283C-42CA-A5A6-15647FDA34B8@.microsoft.com...
> and
> From
>
>
|||do a master.dbo.xp_cmdshell 'echo %computername%' for the netbios name. This
should be the same as what you get when you issue a select @.@.servername
unless you have an instance.
Make sure that the results of the echo %computername% is the same as what
you registered your computer in EM as.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MO" <MO@.discussions.microsoft.com> wrote in message
news:4F03827C-055A-4783-84D0-75FE44858D77@.microsoft.com...[vbcol=seagreen]
> Some of the things you mentioned are above my head.
> When you say netbios names of the publisher and subscriber you mean the
> windows server name ? How do I know the netbios name ?
> Hide the fqdn... What is fqdn ? and how do I hide it ?
> TIA
> MO
> "Hilary Cotter" wrote:
Register[vbcol=seagreen]
it) by[vbcol=seagreen]
make[vbcol=seagreen]
server[vbcol=seagreen]
publisher[vbcol=seagreen]
the[vbcol=seagreen]
local[vbcol=seagreen]
?[vbcol=seagreen]
|||Did you forget to run the rest of the script...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
(XXXX) on my company's network. The remote server will be the publisher and
the local server will be the distributor and subscriber. It gives me the
following error when I configure the publisher and distributor :
SQL Server could not configure 'XXXX' as the Distributor for 'YYYY'.
Error 17: SQL Server does not exist or access denied.
I could log on as 'sa' to the remote server (YYYY) as well as the local
server (XXXX) via SQL Enterprise manager.
I know port #1433 is opened up. What other ports do I need to open up ? From
where ?
Please help
TIA
Mo
It might be a naming issue.
Try:
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||You have to use the netbios names of the publisher and subscriber. Register
both in EM using the netbios names. Hide the fqdn (if you need to use it) by
using a server alias using Client Network Utility.
Have you set up an administrative link password? Disable this option to make
debugging simpler.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MO" <MO@.discussions.microsoft.com> wrote in message
news:86384240-283C-42CA-A5A6-15647FDA34B8@.microsoft.com...
> I am trying to set up replication from a remote server (YYYY) to a server
> (XXXX) on my company's network. The remote server will be the publisher
and
> the local server will be the distributor and subscriber. It gives me the
> following error when I configure the publisher and distributor :
> SQL Server could not configure 'XXXX' as the Distributor for 'YYYY'.
> Error 17: SQL Server does not exist or access denied.
> I could log on as 'sa' to the remote server (YYYY) as well as the local
> server (XXXX) via SQL Enterprise manager.
> I know port #1433 is opened up. What other ports do I need to open up ?
From
> where ?
> Please help
> TIA
> Mo
>
|||Thanks Paul for the quick reply. The sql instance name is say 'AAAA' and when
I run @.@.servername it returns 'AAAA'. The windows server name is say 'WWWW'.
TIA
MO
"Paul Ibison" wrote:
> It might be a naming issue.
> Try:
> Use Master
> go
> Select @.@.Servername
> This should return your current server name but if it
> returns NULL then try:
> Use Master
> go
> Sp_DropServer 'OldName'
> GO
> Use Master
> go
> Sp_Addserver 'NewName', 'local'
> GO
> Stop and Start SQL Services
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||Some of the things you mentioned are above my head.
When you say netbios names of the publisher and subscriber you mean the
windows server name ? How do I know the netbios name ?
Hide the fqdn... What is fqdn ? and how do I hide it ?
TIA
MO
"Hilary Cotter" wrote:
> You have to use the netbios names of the publisher and subscriber. Register
> both in EM using the netbios names. Hide the fqdn (if you need to use it) by
> using a server alias using Client Network Utility.
> Have you set up an administrative link password? Disable this option to make
> debugging simpler.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "MO" <MO@.discussions.microsoft.com> wrote in message
> news:86384240-283C-42CA-A5A6-15647FDA34B8@.microsoft.com...
> and
> From
>
>
|||do a master.dbo.xp_cmdshell 'echo %computername%' for the netbios name. This
should be the same as what you get when you issue a select @.@.servername
unless you have an instance.
Make sure that the results of the echo %computername% is the same as what
you registered your computer in EM as.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"MO" <MO@.discussions.microsoft.com> wrote in message
news:4F03827C-055A-4783-84D0-75FE44858D77@.microsoft.com...[vbcol=seagreen]
> Some of the things you mentioned are above my head.
> When you say netbios names of the publisher and subscriber you mean the
> windows server name ? How do I know the netbios name ?
> Hide the fqdn... What is fqdn ? and how do I hide it ?
> TIA
> MO
> "Hilary Cotter" wrote:
Register[vbcol=seagreen]
it) by[vbcol=seagreen]
make[vbcol=seagreen]
server[vbcol=seagreen]
publisher[vbcol=seagreen]
the[vbcol=seagreen]
local[vbcol=seagreen]
?[vbcol=seagreen]
|||Did you forget to run the rest of the script...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Wednesday, February 15, 2012
Error While Depoloying Report Model Project
Hi,
I am trying to deploy my report model project to remote server which is our QA environment using Visual Studio. In my Project Property I have set the Traget Data source folder and model folder and URL. But I am getting this error any idea?
===================================
A connection could not be made to the report server "ReportServer URL for my remote server"
. (Microsoft Semantic Model Designer)
===================================
Client found response content type of '', but expected 'text/xml'.
The request failed with an empty response. (Microsoft.ReportingServices.SemanticQueryDesign)
Program Location:
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetSecureMethods()
at Microsoft.SqlServer.ReportingServices2005.RSConnection.IsSecureMethod(String methodname)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetItemType(String Item)
at Microsoft.ReportingServices.ModelDesigner.Project.ReportServiceClient.GetItemType(String item)
at Microsoft.ReportingServices.ModelDesigner.Project.ReportServiceClient.CheckAuthorized()
at Microsoft.ReportingServices.ModelDesigner.Project.ModelClientManager.GetCredentials(String url)
at Microsoft.ReportingServices.ModelDesigner.Project.ModelProjectDeployer.PrepareDeploy()
What kind of permission/role do I need to have inorder to deploy report model project on to the server. I am able to deploy same project on my local machine using visual studio.
Thanks!!!
You are not using the right address for the report server or the Report WebService is not working properly, you will have to provide the adress of the Report Server WebService address which is by default http://localhost/ReportServer (on the localhost). browse to this address in your IE to see if the address is working and Reporting Server is responding.
Jens K. Suessmeyer
http://www.sqlserver2005.de
Hi,
I found the solution actually the issue is how the folders structure.
In our QA environment we have different folders for different projects.
This is how I was trying before:
Target DataSourceFolder: Data Sources
Target ModelsFolder: Models
TargetURL: http://servername/reportserver/CRAS1
Notice the folder name at the end of the URL.(thats the project folder I wanted this Model project to be in)
This is how its now and its working:
Target DataSourceFolder: CRAS1/Data Sources
Target ModelsFolder: CRAS1/Models
TargetURL: http://servername/reportserver
I hope this helps to someone like me who does this kind of stupid mistake.
Thanks
Ashwini
Subscribe to:
Posts (Atom)