Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.

Hi Im having this message when i execute this proc : spU_documentos_1 3,
4, '', 'Plano de Projeto', 'Este plano de projeto foi elaborado na fase 1
do projeto para cotao eletrnica.', '2005-03-04 09:10:38', 1.1, 1, 2, 12,
'2005-05-12 09:10:38' .. it has a normal UPDATE clause. The sql dump is:
================================================== ===================
BugCheck Dump
================================================== ===================
This file is generated by Microsoft SQL Server 8.00.760
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.
Computer type is AT/AT COMPATIBLE.
Bios Version is BIOS Date: 04/02/04 13:33:00 Ver: 08.00.10
BIOS Date: 04/02/04 13:33:00 Ver: 08.00.10
Current time is 09:13:33 05/12/05.
2 Intel x86 level 15, 2992 Mhz processor(s).
Windows NT 5.0 Build 2195 CSD Service Pack 4.
Memory
MemoryLoad = 28%
Total Physical = 1022 MB
Available Physical = 732 MB
Total Page File = 2462 MB
Available Page File = 2241 MB
Total Virtual = 2047 MB
Available Virtual = 946 MB
*Stack Dump being sent to E:\Arquivos de programas\Microsoft SQL Server\80\
Tool
s\log\SQLDump0042.txt
* ************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 05/12/05 09:13:33 spid 54
*
* Exception Address = 00000000
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 191 bytes -
* spU_documentos_1 3, 4, '', 'Plano de Projeto', 'Este plano de projeto fo
* i elaborado na fase 1 do projeto para cotao eletrnica.', '2005-03-04
* 09:10:38', 1.1, 1, 2, 12, '2005-05-12 09:10:38'
*
*
* MODULE BASE END SIZE
* sqlservr 00400000 00B2CFFF 0072d000
* ntdll 78460000 784E0FFF 00081000
* KERNEL32 79720000 797D9FFF 000ba000
* ADVAPI32 792D0000 79331FFF 00062000
* RPCRT4 77120000 77190FFF 00071000
* USER32 77E10000 77E6EFFF 0005f000
* GDI32 77F40000 77F7AFFF 0003b000
* OPENDS60 41060000 41065FFF 00006000
* MSVCRT 78000000 78044FFF 00045000
* UMS 41070000 4107CFFF 0000d000
* SQLSORT 42AE0000 42B6FFFF 00090000
* MSVCIRT 780A0000 780B1FFF 00012000
* sqlevn70 41080000 41086FFF 00007000
* NETAPI32 24F10000 24F5EFFF 0004f000
* Secur32 793B0000 793BEFFF 0000f000
* NTDSAPI 77BF0000 77C00FFF 00011000
* DNSAPI 77980000 779A3FFF 00024000
* WSOCK32 24F60000 24F68FFF 00009000
* WS2_32 24F70000 24F83FFF 00014000
* WS2HELP 24F90000 24F97FFF 00008000
* WLDAP32 77950000 7797AFFF 0002b000
* NETRAP 24FA0000 24FA5FFF 00006000
* SAMLIB 24FB0000 24FBEFFF 0000f000
* ole32 77A50000 77B3EFFF 000ef000
* XOLEHLP 252A0000 252A7FFF 00008000
* MSDTCPRX 252B0000 25368FFF 000b9000
* MTXCLU 25370000 2537FFFF 00010000
* VERSION 77820000 77826FFF 00007000
* LZ32 25380000 25385FFF 00006000
* CLUSAPI 25390000 2539FFFF 00010000
* RESUTILS 253A0000 253ACFFF 0000d000
* USERENV 790D0000 79131FFF 00062000
* rnr20 77840000 7784BFFF 0000c000
* iphlpapi 77320000 77332FFF 00013000
* ICMP 77500000 77504FFF 00005000
* MPRAPI 77300000 77316FFF 00017000
* OLEAUT32 779B0000 77A4AFFF 0009b000
* ACTIVEDS 77390000 773BFFFF 00030000
* ADSLDPC 77360000 77382FFF 00023000
* RTUTILS 77830000 7783DFFF 0000e000
* SETUPAPI 783C0000 7844FFFF 00090000
* RASAPI32 774C0000 774F2FFF 00033000
* RASMAN 774A0000 774B0FFF 00011000
* TAPI32 77510000 77531FFF 00022000
* COMCTL32 253F0000 25473FFF 00084000
* SHLWAPI 25480000 254E5FFF 00066000
* DHCPCSVC 77340000 77358FFF 00019000
* winrnr 777E0000 777E7FFF 00008000
* rasadhlp 777F0000 777F4FFF 00005000
* SSNETLIB 26150000 26164FFF 00015000
* SSNMPN70 410D0000 410D5FFF 00006000
* security 268A0000 268A3FFF 00004000
* msafd 01630000 0164DFFF 0001e000
* wshtcpip 016A0000 016A6FFF 00007000
* SSmsLPCn 01770000 01776FFF 00007000
* SQLFTQRY 41020000 41051FFF 00032000
* CLBCATQ 021D0000 0225FFFF 00090000
* sqloledb 02270000 022E2FFF 00073000
* MSDART 022F0000 0230EFFF 0001f000
* comdlg32 02310000 0234DFFF 0003e000
* SHELL32 77590000 777D9FFF 0024a000
* MSDATL3 02350000 02364FFF 00015000
* oledb32 026F0000 02755FFF 00066000
* OLEDB32R 02760000 0276FFFF 00010000
* rsabase 7CA00000 7CA22FFF 00023000
* CRYPT32 79910000 79997FFF 00088000
* MSASN1 77410000 7741FFFF 00010000
* xpsqlbot 02810000 02815FFF 00006000
* xpstar 410F0000 41136FFF 00047000
* SQLRESLD 42AC0000 42AC6FFF 00007000
* SQLSVC 02840000 02856FFF 00017000
* ODBC32 02860000 02891FFF 00032000
* odbcbcp 028A0000 028A5FFF 00006000
* W95SCM 41140000 4114BFFF 0000c000
* SQLUNIRL 10000000 1002CFFF 0002d000
* WINSPOOL 77800000 7781DFFF 0001e000
* MPR 797F0000 797FFFFF 00010000
* SHFOLDER 028B0000 028B7FFF 00008000
* odbcint 02A00000 02A15FFF 00016000
* NDDEAPI 02A20000 02A26FFF 00007000
* SQLSVC 02AB0000 02AB5FFF 00006000
* xpstar 02AC0000 02AC8FFF 00009000
* dbghelp 07CF0000 07DA4FFF 000b5000
*
* Edi: 46EBA1E8: 46EBA020 00000000 00000001 0000000B 00000000
46EBA
328
* Esi: 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030
2E323
931
* Eax: 46ED35D0: 46ED2018 46ED3118 00000001 005F0000 46EAE7B0
00000
051
* Ebx: 00000060:
* Ecx: 46ED2018: 00000001 00000000 00000000 46ED35C8 00000001
01800
008
* Edx: 00000062:
* Eip: 00000000:
* Ebp: 0214EB7C: 0214EB94 00419A85 46ED36B8 46EBA068 46FC8220
46EBA
068
* SegCs: 0000001B:
* EFlags: 00010202: 00650074 0033006D 003B0032 003A0045 0057005C
004E0
049
* Esp: 0214EB50: 006B66D6 46ED35D0 46EBA388 0040ACC8 46EBA388
005E6
658
* SegSs: 00000023:
* ************************************************** ***************************
**
* ----
--
* Short Stack Dump
* 00000000 Module(sqlservr+FFC00000)
* 006B66D6 Module(sqlservr+002B66D6) (CXVariant::ClearDeep+00000047)
* 0040ACC8 Module(sqlservr+0000ACC8) (CXVariant::Clear+0000000E)
* 005E6658 Module(sqlservr+001E6658)
(CExecParamTbl::ResetTextParams+00000046)
* 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
* Location : 00000000 Module(sqlservr+FFC00000)
* Return Addr: 006B66D6 Module(sqlservr+002B66D6)
(CXVariant::ClearDeep+0000004
7)
Frame : 0214EB4C
Parameters:
[1] 46ED35D0: 46ED2018 46ED3118 00000001 005F0000 46EAE7B0 00000051
[2] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
[3] 0040ACC8: 8B5609EB 027E80F1 80F07500 80000266 83000166 C6000466
[4] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
112 bytes of stack data from 0214EADC to 0214EB4C
0214EADC: 00000019 00000000 25EBFBD4 00000200 [.........%...]
0214EAEC: 25EBFDC4 78461F55 78462AD0 784AC3D5 [...%U.Fx.*Fx..Jx]
0214EAFC: 00BD0000 784AC4C9 784AC4E0 25EBFE70 [.....Jx..Jxp..%]
0214EB0C: 00000000 00BD65C0 00000000 25EBFC44 [....e.....D..%]
0214EB1C: 7846309F 25EBFDAC 0000000E 25EBFC50 [.0Fx...%...P..%]
0214EB2C: 25EBFC74 0000001C 0000009C 25EBFDAC [t..%.........%]
0214EB3C: 00000001 00000000 25EBFD8C 79740DD6 [.........%..ty]
* Location : 006B66D6 Module(sqlservr+002B66D6)
(CXVariant::ClearDeep+0000004
7)
* Return Addr: 0040ACC8 Module(sqlservr+0000ACC8)
(CXVariant::Clear+0000000E)
Frame : 0214EB58
Parameters:
[1] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
[2] 005E6658: 8BF875FF E8006ACE FFE33DFF 83FC45FF 458B18C3 0C473BFC
[3] 46EBA120: 46EBA1B8 00000001 46EBA4D8 46EBA4E0 00000000 00000000
[4] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000000
12 bytes of stack data from 0214EB4C to 0214EB58
0214EB4C: 25EBFD84 006B66D6 46ED35D0 [...%.fk..5.F]
* Location : 0040ACC8 Module(sqlservr+0000ACC8)
(CXVariant::Clear+0000000E)
* Return Addr: 005E6658 Module(sqlservr+001E6658)
(CExecParamTbl::ResetTextPara
ms+00000046)
Frame : 0214EB60
Parameters:
[1] 46EBA120: 46EBA1B8 00000001 46EBA4D8 46EBA4E0 00000000 00000000
[2] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000000
[3] 46EBA068: 00990294 00650072 324172E1 00002050 00000001 60000000
[4] 46EBA284: 00230023 00000010 3400D008 00000000 00993560 46EBA3A0
8 bytes of stack data from 0214EB58 to 0214EB60
0214EB58: 46EBA388 0040ACC8 [...F..@..]
* Location : 005E6658 Module(sqlservr+001E6658)
(CExecParamTbl::ResetTextPara
ms+00000046)
* Return Addr: 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
Frame : 25EBFD9C
Parameters:
[1] 7974BB87: 0B7DC085 C6A8E850 C883FFFD 8B03EBFF C25D0845 8B550004
[2] 00000360:
[3] 25EBFDB8: 00000003 25EBFDD0 00BD0000 00000013 00BD0000 25A13758
[4] 7974B8DF: 0A7DC085 C950E850 C033FFFD 016A03EB 08C25D58 EC8B5500
* Location : 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
* Return Addr: 00000000 Module(sqlservr+FFC00000)
Frame : 00BD65C0
Parameters:
[1] 0000000E:
[2] 00000000:
[3] 00D36838: 00000000 00002000 00012000 00000000 0000019C 00D36978
[4] 00000000:
* ----
--
PSS @.0x46ED36B8
pspid = 54 m_dwLoginFlags = 0x0020 plsid = 1119313944
pbackground = 0
pbSid
c5db14b5 082b3546 94136f04 1a5ca389 ....+5F..o..\..
sSecFlags = 0x12 pdeadlockpri = 0 poffsets = 0x0
pss_stats = 0x0 ptickcount = 22309093
pcputickcount = 66742222410712 ploginstamp = 4450
ptimestamp = 2005-05-12 09:13:33.357 plangid = 0
pdateformat = 1 pdatefirst = 7 Language = us_english
UserName = root poptions = 0x8000020 poptions2 = 0x24020
pline = -1 pcurstepno = 0 prowcount = 0
pstatlist = 0 pcurcmd = 202 pseqstat = 0
ptextsize = 2147483646 pretstat = 0 CNestLevel = 1
@.@.procid = 843150049 pslastbatchstarttime = 2005-05-12 09:13:33.403
pmemusage = 3 hLicense = 0 tpFlags = 0x1
isolation_level = 0 fips_flag = 0x0 sSaveSecFlags = 0x0
psavedb = 0 pfetchstat = 0 pcrsrows = 0
pslastbatchtime = 2005-05-12 09:13:33.403 pubexecdb = 0
fInReplicatedProcExec = 0 pMsqlXact = 0x46ED3EB8 presSemCount = [0]
34924172
presSemCount = [0]34924172 pcputot = 0
pcputotstart = 0 pcpucmdstart = 0 pbufread = 0
pbufreadstart = 0 plogbufread = 533 plogbufreadstart = 459
pbufwrite = 0 pbufwritestart = 0 pLockTimeout =
4294967295
pUtilResultSet = 0x00000000
pec
ec_pss->pspid = 54 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x100001 ec_atomic = 0x0 pcurdb = 20
ec_lasterror = 0 ec_preverror = 0 ec_cpucur = 344
ec_cmderrs = 0 ec_timeslice = 98 ec_dbtable = 0x4334E030
ec_reswait = 0x0 ec_dbindex = -1 ec_waittype = 0x0000
Waittime = 0 ec_umsContext->m_pSched->m_id (SchedulerId) = 0x0
ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
ExecutionContext Summary @.0x46ED39E0
ec_pss->pspid = 54 ecid = 0 ec_stat = 0x0
ec_stat2 = 0x100001 ec_atomic = 0x0 pcurdb = 20
ec_lasterror = 0 ec_preverror = 0 ec_cpucur = 344
ec_cmderrs = 0 ec_timeslice = 98 ec_dbtable = 0x4334E030
ec_reswait = 0x0 ec_dbindex = -1 ec_waittype = 0x0000
Waittime = 0 ec_umsContext->m_pSched->m_id (SchedulerId) = 0x0
ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
psrvproc->eclClient = 0 psrvproc->status = 8
psrvproc->state = SRV_RUNNING psrvproc->bNewPacket =
0
psrvproc->pmo = 0x46EE2030
psrvproc->ums_context = 0x25A1AC98 psrvproc->threadId =
0x55c
client threadId = 0x0
psrvproc->pV7LoginRec
00000000: b6000000 00000000 00020000 00000000 76780300
.............vx..
00000014: 00000000 20000000 00000000 00000000 56000300 ...
.........V...
00000028: 5c000400 64000500 6e000500 78000b00 00000000 \
...d...n...x......
0000003C: 8e000a00 a2000a00 00000000 00000000 00000000
................
00000050: 00000000 00007700 .....w.
psrvproc->m_pwchLangBuff
00000000: 7370555f 646f6375 6d656e74 6f735f31 20332c20 spU_documentos_1
3,
00000014: 342c2027 272c2027 506c616e 6f206465 2050726f 4, '', 'Plano de
Pro
00000028: 6a65746f 272c2027 45737465 20706c61 6e6f2064 jeto', 'Este plano
d
0000003C: 65207072 6f6a6574 6f20666f 6920656c 61626f72 e projeto foi
elabor
00000050: 61646f20 6e612066 61736520 3120646f 2070726f ado na fase 1 do
pro
00000064: 6a65746f 20706172 6120636f 7461e7e3 6f20656c jeto para cota..o
el
00000078: 657472f4 6e696361 2e272c20 27323030 352d3033 etr.nica.', '2005-
03
0000008C: 2d303420 30393a31 303a3338 272c2031 2e312c20 -04 09:10:38',
1.1,
000000A0: 312c2032 2c203132 2c202732 3030352d 30352d31 1, 2, 12, '2005-05-
1
000000B4: 32203039 3a31303a 333827 2 09:10:38'
psrvproc->srvio.outbuff
00000000: 04010065 00360100 ff0100d4 00000000 00ff1100
...e.6...........
00000014: c5000100 0000ff01 00c00000 000000ff 0100d500
................
00000028: 00000000 ff0100ca 00000000 00aaad00 00000000
................
0000003C: 00138c00 53716c44 756d7045 78636570 74696f6e
....SqlDumpException
00000050: 48616e64 6c65723a 2050726f 63657373 20353420 Handler: Process
54
00000064: 67656e65 72617465 64206661 74616c20 65786365 generated fatal
exce
00000078: 7074696f 6e206330 30303030 30352045 58434550 ption c0000005
EXCEP
0000008C: 54494f4e 5f414343 4553535f 56494f4c 4154494f
TION_ACCESS_VIOLATIO
000000A0: 4e2e2053 514c2053 65727665 72206973 20746572 N. SQL Server is
ter
000000B4: 6d696e61 74696e67 20746869 73207072 6f636573 minating this
proces
000000C8: 732e0d0a 0541544f 4e321073 70555f64 6f63756d
s...ATON2.spU_docum
000000DC: 656e746f 735f31ff ff000100 00000000 00000000
entos_1..........
000000F0: 00000000 00000100 0000040c 00000004 00000000
................
00000104: 08000000 00000000 00040c00 00000806 96000078
...............x
00000118: 3f1a01ff 1100c100 01000000 ff0100ca 00010000 ?
...............
0000012C: 00ff0100 ca000100 00007900 000000fe 0000e000
.........y.......
00000140: 01000000 414c5445 520e5553 55415249 4f5f4944
....ALTER.USUARIO_ID
00000154: 494f4d41 0a454d50 52455341 5f494413 49445f55
IOMA.EMPRESA_ID.ID_U
00000168: 53554152 494f5f49 4e434c55 53414f0d 44415441
SUARIO_INCLUSAO.DATA
0000017C: 5f494e43 4c555341 4f144944 5f555355 4152494f
_INCLUSAO.ID_USUARIO
00000190: 5f414c54 45524143 414f0e44 4154415f 414c5445
_ALTERACAO.DATA_ALTE
000001A4: 52414341 4fa18c00 07001000 38070008 00380200
RACAO......8...8..
000001B8: 08002764 02000800 27320200 08002764 02000800
...'d...'2...'d...
000001CC: 27c80200 08002732 02000800 27c80200 08002764
'....'2...'....'d
000001E0: 02000800 27c80200 08002796 02000800 27960700
....'....'....'...
000001F4: 08003807 00080038 07000800 ..8...8...
various psrvproc flags = 0x00000100
EC @.0x46ED39E0
ec_pss->pspid = 54 ecid = 0 ec_cmderrs = 0
ec_stat = 0x0 ec_stat2 = 0x100001 ec_atomic = 0x0
ec_curdb = 20 ec_dbtable = 0x4334e030 ec_dbstat = 0x0
ec_lospin = 0x0 ec_dbindex = -1 ec_lasterror = 0
ec_save_ex_number = 0 ec_save_ex_address = 0x00000000
ec_cpucur = 344 ec_timeslice = 98 ec_next = 0x00000000
ec_prev = 0x00000000 ec_state = 1 ec_waittype = 0x0000
ec_dbstat2 = 0 ec_preverror = 0 ec_subecstat = 1
ec_subecnext = 0x00000000 ec_resSemWaitInfo = 0
ec_umsContext->m_pSched->m_id (SchedulerId) = 0x0
ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
ec_backupContext = 0x00000000 ec_dbccContext =
0x00000000
ec_allocFile = 0x00000000 ec_buftrace.Index = 21
ec_buftrace.Entry [0]
bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
bdbid = 20 breferences = 54 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [1]
bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
bdbid = 20 breferences = 35 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [2]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [3]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [4]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [5]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [6]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [7]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [8]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [9]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [10]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [11]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [12]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [13]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [14]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [15]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [16]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [17]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [18]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [19]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [20]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [21]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [22]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [23]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [24]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [25]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [26]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [27]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [28]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [29]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [30]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [31]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [32]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [33]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [34]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [35]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [36]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [37]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [38]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [39]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [40]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [41]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [42]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [43]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [44]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [45]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [46]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [47]
bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
bdbid = 20 breferences = 2116 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [48]
bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
bdbid = 20 breferences = 352 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [49]
bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
bdbid = 20 breferences = 1882 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [50]
bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [51]
bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
bdbid = 20 breferences = 1885 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [52]
bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
bdbid = 20 breferences = 62 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [53]
bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
bdbid = 20 breferences = 62 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [54]
bpage = 0x45BEC000 bhash = 0x00000000 bpageno = (1:7939)
bdbid = 20 breferences = 31 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [55]
bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
bdbid = 20 breferences = 35 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [56]
bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
bdbid = 20 breferences = 62 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [57]
bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
bdbid = 20 breferences = 62 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [58]
bpage = 0x45BEC000 bhash = 0x00000000 bpageno = (1:7939)
bdbid = 20 breferences = 31 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [59]
bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
bdbid = 20 breferences = 35 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [60]
bpage = 0x45BF0000 bhash = 0x00000000 bpageno = (1:7940)
bdbid = 20 breferences = 259 bstat = 0x9
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [61]
bpage = 0x43834000 bhash = 0x00000000 bpageno = (1:1)
bdbid = 20 breferences = 613 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [62]
bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
bdbid = 20 breferences = 54 bstat = 0xb
bspin = 0 bnext = 0x00000000
ec_buftrace.Entry [63]
bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
bdbid = 20 breferences = 54 bstat = 0xb
bspin = 0 bnext = 0x00000000
EXCEPT (null) @.0x0214F9F8
exc_number = 0 exc_severity = 0
exc_func = MSQLErrorHandler+0 Line 0+0x0
Can any one help me ? Please !!!
1) Is this repeatable, or did it just happen once?
2) What is the text of your stored procedure, and what do the tables look
like that it accesses?
In general, if you get a stack dump like this, and you are on a supported
Service Pack (and as SP4 was only released this week, SP3 will still be
supported), you can contact Microsoft Product Support Services and I think
in most cases they will help you for free. They might advice you to upgrade
to SP4 or provide you with a hotfix.
Jacco Schalkwijk
SQL Server MVP
"Plantador Ren via droptable.com" <forum@.nospam.droptable.com> wrote in
message news:4c09a2707e4c42efbf85914e6c1a0d9d@.droptable.co m...
> Hi Im having this message when i execute this proc : spU_documentos_1 3,
> 4, '', 'Plano de Projeto', 'Este plano de projeto foi elaborado na fase 1
> do projeto para cotao eletrnica.', '2005-03-04 09:10:38', 1.1, 1, 2,
> 12,
> '2005-05-12 09:10:38' .. it has a normal UPDATE clause. The sql dump is:
> ================================================== ===================
> BugCheck Dump
> ================================================== ===================
> This file is generated by Microsoft SQL Server 8.00.760
> upon detection of fatal unexpected error. Please return this file,
> the query or program that produced the bugcheck, the database and
> the error log, and any other pertinent information with a Service Request.
> Computer type is AT/AT COMPATIBLE.
> Bios Version is BIOS Date: 04/02/04 13:33:00 Ver: 08.00.10
> BIOS Date: 04/02/04 13:33:00 Ver: 08.00.10
> Current time is 09:13:33 05/12/05.
> 2 Intel x86 level 15, 2992 Mhz processor(s).
> Windows NT 5.0 Build 2195 CSD Service Pack 4.
>
> Memory
> MemoryLoad = 28%
> Total Physical = 1022 MB
> Available Physical = 732 MB
> Total Page File = 2462 MB
> Available Page File = 2241 MB
> Total Virtual = 2047 MB
> Available Virtual = 946 MB
> *Stack Dump being sent to E:\Arquivos de programas\Microsoft SQL
> Server\80\
> Tool
> s\log\SQLDump0042.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 05/12/05 09:13:33 spid 54
> *
> * Exception Address = 00000000
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 00000000
> * Input Buffer 191 bytes -
> * spU_documentos_1 3, 4, '', 'Plano de Projeto', 'Este plano de projeto
> fo
> * i elaborado na fase 1 do projeto para cotao eletrnica.', '2005-03-04
> * 09:10:38', 1.1, 1, 2, 12, '2005-05-12 09:10:38'
> *
> *
> * MODULE BASE END SIZE
> * sqlservr 00400000 00B2CFFF 0072d000
> * ntdll 78460000 784E0FFF 00081000
> * KERNEL32 79720000 797D9FFF 000ba000
> * ADVAPI32 792D0000 79331FFF 00062000
> * RPCRT4 77120000 77190FFF 00071000
> * USER32 77E10000 77E6EFFF 0005f000
> * GDI32 77F40000 77F7AFFF 0003b000
> * OPENDS60 41060000 41065FFF 00006000
> * MSVCRT 78000000 78044FFF 00045000
> * UMS 41070000 4107CFFF 0000d000
> * SQLSORT 42AE0000 42B6FFFF 00090000
> * MSVCIRT 780A0000 780B1FFF 00012000
> * sqlevn70 41080000 41086FFF 00007000
> * NETAPI32 24F10000 24F5EFFF 0004f000
> * Secur32 793B0000 793BEFFF 0000f000
> * NTDSAPI 77BF0000 77C00FFF 00011000
> * DNSAPI 77980000 779A3FFF 00024000
> * WSOCK32 24F60000 24F68FFF 00009000
> * WS2_32 24F70000 24F83FFF 00014000
> * WS2HELP 24F90000 24F97FFF 00008000
> * WLDAP32 77950000 7797AFFF 0002b000
> * NETRAP 24FA0000 24FA5FFF 00006000
> * SAMLIB 24FB0000 24FBEFFF 0000f000
> * ole32 77A50000 77B3EFFF 000ef000
> * XOLEHLP 252A0000 252A7FFF 00008000
> * MSDTCPRX 252B0000 25368FFF 000b9000
> * MTXCLU 25370000 2537FFFF 00010000
> * VERSION 77820000 77826FFF 00007000
> * LZ32 25380000 25385FFF 00006000
> * CLUSAPI 25390000 2539FFFF 00010000
> * RESUTILS 253A0000 253ACFFF 0000d000
> * USERENV 790D0000 79131FFF 00062000
> * rnr20 77840000 7784BFFF 0000c000
> * iphlpapi 77320000 77332FFF 00013000
> * ICMP 77500000 77504FFF 00005000
> * MPRAPI 77300000 77316FFF 00017000
> * OLEAUT32 779B0000 77A4AFFF 0009b000
> * ACTIVEDS 77390000 773BFFFF 00030000
> * ADSLDPC 77360000 77382FFF 00023000
> * RTUTILS 77830000 7783DFFF 0000e000
> * SETUPAPI 783C0000 7844FFFF 00090000
> * RASAPI32 774C0000 774F2FFF 00033000
> * RASMAN 774A0000 774B0FFF 00011000
> * TAPI32 77510000 77531FFF 00022000
> * COMCTL32 253F0000 25473FFF 00084000
> * SHLWAPI 25480000 254E5FFF 00066000
> * DHCPCSVC 77340000 77358FFF 00019000
> * winrnr 777E0000 777E7FFF 00008000
> * rasadhlp 777F0000 777F4FFF 00005000
> * SSNETLIB 26150000 26164FFF 00015000
> * SSNMPN70 410D0000 410D5FFF 00006000
> * security 268A0000 268A3FFF 00004000
> * msafd 01630000 0164DFFF 0001e000
> * wshtcpip 016A0000 016A6FFF 00007000
> * SSmsLPCn 01770000 01776FFF 00007000
> * SQLFTQRY 41020000 41051FFF 00032000
> * CLBCATQ 021D0000 0225FFFF 00090000
> * sqloledb 02270000 022E2FFF 00073000
> * MSDART 022F0000 0230EFFF 0001f000
> * comdlg32 02310000 0234DFFF 0003e000
> * SHELL32 77590000 777D9FFF 0024a000
> * MSDATL3 02350000 02364FFF 00015000
> * oledb32 026F0000 02755FFF 00066000
> * OLEDB32R 02760000 0276FFFF 00010000
> * rsabase 7CA00000 7CA22FFF 00023000
> * CRYPT32 79910000 79997FFF 00088000
> * MSASN1 77410000 7741FFFF 00010000
> * xpsqlbot 02810000 02815FFF 00006000
> * xpstar 410F0000 41136FFF 00047000
> * SQLRESLD 42AC0000 42AC6FFF 00007000
> * SQLSVC 02840000 02856FFF 00017000
> * ODBC32 02860000 02891FFF 00032000
> * odbcbcp 028A0000 028A5FFF 00006000
> * W95SCM 41140000 4114BFFF 0000c000
> * SQLUNIRL 10000000 1002CFFF 0002d000
> * WINSPOOL 77800000 7781DFFF 0001e000
> * MPR 797F0000 797FFFFF 00010000
> * SHFOLDER 028B0000 028B7FFF 00008000
> * odbcint 02A00000 02A15FFF 00016000
> * NDDEAPI 02A20000 02A26FFF 00007000
> * SQLSVC 02AB0000 02AB5FFF 00006000
> * xpstar 02AC0000 02AC8FFF 00009000
> * dbghelp 07CF0000 07DA4FFF 000b5000
> *
> * Edi: 46EBA1E8: 46EBA020 00000000 00000001 0000000B 00000000
> 46EBA
> 328
> * Esi: 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030
> 2E323
> 931
> * Eax: 46ED35D0: 46ED2018 46ED3118 00000001 005F0000 46EAE7B0
> 00000
> 051
> * Ebx: 00000060:
> * Ecx: 46ED2018: 00000001 00000000 00000000 46ED35C8 00000001
> 01800
> 008
> * Edx: 00000062:
> * Eip: 00000000:
> * Ebp: 0214EB7C: 0214EB94 00419A85 46ED36B8 46EBA068 46FC8220
> 46EBA
> 068
> * SegCs: 0000001B:
> * EFlags: 00010202: 00650074 0033006D 003B0032 003A0045 0057005C
> 004E0
> 049
> * Esp: 0214EB50: 006B66D6 46ED35D0 46EBA388 0040ACC8 46EBA388
> 005E6
> 658
> * SegSs: 00000023:
> *
> ************************************************** ***************************
> **
> * ----
> --
> --
> * Short Stack Dump
> * 00000000 Module(sqlservr+FFC00000)
> * 006B66D6 Module(sqlservr+002B66D6) (CXVariant::ClearDeep+00000047)
> * 0040ACC8 Module(sqlservr+0000ACC8) (CXVariant::Clear+0000000E)
> * 005E6658 Module(sqlservr+001E6658)
> (CExecParamTbl::ResetTextParams+00000046)
> * 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
> ----
> --
> * Location : 00000000 Module(sqlservr+FFC00000)
> * Return Addr: 006B66D6 Module(sqlservr+002B66D6)
> (CXVariant::ClearDeep+0000004
> 7)
> Frame : 0214EB4C
> Parameters:
> [1] 46ED35D0: 46ED2018 46ED3118 00000001 005F0000 46EAE7B0 00000051
> [2] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
> [3] 0040ACC8: 8B5609EB 027E80F1 80F07500 80000266 83000166 C6000466
> [4] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
> 112 bytes of stack data from 0214EADC to 0214EB4C
> 0214EADC: 00000019 00000000 25EBFBD4 00000200 [.........%...]
> 0214EAEC: 25EBFDC4 78461F55 78462AD0 784AC3D5 [...%U.Fx.*Fx..Jx]
> 0214EAFC: 00BD0000 784AC4C9 784AC4E0 25EBFE70 [.....Jx..Jxp..%]
> 0214EB0C: 00000000 00BD65C0 00000000 25EBFC44 [....e.....D..%]
> 0214EB1C: 7846309F 25EBFDAC 0000000E 25EBFC50 [.0Fx...%...P..%]
> 0214EB2C: 25EBFC74 0000001C 0000009C 25EBFDAC [t..%.........%]
> 0214EB3C: 00000001 00000000 25EBFD8C 79740DD6 [.........%..ty]
> ----
> --
> * Location : 006B66D6 Module(sqlservr+002B66D6)
> (CXVariant::ClearDeep+0000004
> 7)
> * Return Addr: 0040ACC8 Module(sqlservr+0000ACC8)
> (CXVariant::Clear+0000000E)
> Frame : 0214EB58
> Parameters:
> [1] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323931
> [2] 005E6658: 8BF875FF E8006ACE FFE33DFF 83FC45FF 458B18C3 0C473BFC
> [3] 46EBA120: 46EBA1B8 00000001 46EBA4D8 46EBA4E0 00000000 00000000
> [4] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000000
> 12 bytes of stack data from 0214EB4C to 0214EB58
> 0214EB4C: 25EBFD84 006B66D6 46ED35D0 [...%.fk..5.F]
> ----
> --
> * Location : 0040ACC8 Module(sqlservr+0000ACC8)
> (CXVariant::Clear+0000000E)
> * Return Addr: 005E6658 Module(sqlservr+001E6658)
> (CExecParamTbl::ResetTextPara
> ms+00000046)
> Frame : 0214EB60
> Parameters:
> [1] 46EBA120: 46EBA1B8 00000001 46EBA4D8 46EBA4E0 00000000 00000000
> [2] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000000
> [3] 46EBA068: 00990294 00650072 324172E1 00002050 00000001 60000000
> [4] 46EBA284: 00230023 00000010 3400D008 00000000 00993560 46EBA3A0
> 8 bytes of stack data from 0214EB58 to 0214EB60
> 0214EB58: 46EBA388 0040ACC8 [...F..@..]
> ----
> --
> * Location : 005E6658 Module(sqlservr+001E6658)
> (CExecParamTbl::ResetTextPara
> ms+00000046)
> * Return Addr: 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
> Frame : 25EBFD9C
> Parameters:
> [1] 7974BB87: 0B7DC085 C6A8E850 C883FFFD 8B03EBFF C25D0845 8B550004
> [2] 00000360:
> [3] 25EBFDB8: 00000003 25EBFDD0 00BD0000 00000013 00BD0000 25A13758
> [4] 7974B8DF: 0A7DC085 C950E850 C033FFFD 016A03EB 08C25D58 EC8B5500
> ----
> --
> * Location : 7800835A Module(MSVCRT+0000835A) (beginthread+0000003E)
> * Return Addr: 00000000 Module(sqlservr+FFC00000)
> Frame : 00BD65C0
> Parameters:
> [1] 0000000E:
> [2] 00000000:
> [3] 00D36838: 00000000 00002000 00012000 00000000 0000019C 00D36978
> [4] 00000000:
> * ----
> --
> --
> PSS @.0x46ED36B8
> --
> pspid = 54 m_dwLoginFlags = 0x0020 plsid = 1119313944
> pbackground = 0
> pbSid
> --
> c5db14b5 082b3546 94136f04 1a5ca389 ....+5F..o..\..
> sSecFlags = 0x12 pdeadlockpri = 0 poffsets = 0x0
> pss_stats = 0x0 ptickcount = 22309093
> pcputickcount = 66742222410712 ploginstamp = 4450
> ptimestamp = 2005-05-12 09:13:33.357 plangid = 0
> pdateformat = 1 pdatefirst = 7 Language = us_english
> UserName = root poptions = 0x8000020 poptions2 = 0x24020
> pline = -1 pcurstepno = 0 prowcount = 0
> pstatlist = 0 pcurcmd = 202 pseqstat = 0
> ptextsize = 2147483646 pretstat = 0 CNestLevel = 1
> @.@.procid = 843150049 pslastbatchstarttime = 2005-05-12 09:13:33.403
> pmemusage = 3 hLicense = 0 tpFlags = 0x1
> isolation_level = 0 fips_flag = 0x0 sSaveSecFlags = 0x0
> psavedb = 0 pfetchstat = 0 pcrsrows = 0
> pslastbatchtime = 2005-05-12 09:13:33.403 pubexecdb = 0
> fInReplicatedProcExec = 0 pMsqlXact = 0x46ED3EB8 presSemCount = [0]
> 34924172
> presSemCount = [0]34924172 pcputot = 0
> pcputotstart = 0 pcpucmdstart = 0 pbufread = 0
> pbufreadstart = 0 plogbufread = 533 plogbufreadstart = 459
> pbufwrite = 0 pbufwritestart = 0 pLockTimeout =
> 4294967295
> pUtilResultSet = 0x00000000
> pec
> --
> ec_pss->pspid = 54 ecid = 0 ec_stat = 0x0
> ec_stat2 = 0x100001 ec_atomic = 0x0 pcurdb = 20
> ec_lasterror = 0 ec_preverror = 0 ec_cpucur = 344
> ec_cmderrs = 0 ec_timeslice = 98 ec_dbtable =
> 0x4334E030
> ec_reswait = 0x0 ec_dbindex = -1 ec_waittype = 0x0000
> Waittime = 0 ec_umsContext->m_pSched->m_id (SchedulerId) =
> 0x0
> ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
>
> ExecutionContext Summary @.0x46ED39E0
> --
> ec_pss->pspid = 54 ecid = 0 ec_stat = 0x0
> ec_stat2 = 0x100001 ec_atomic = 0x0 pcurdb = 20
> ec_lasterror = 0 ec_preverror = 0 ec_cpucur = 344
> ec_cmderrs = 0 ec_timeslice = 98 ec_dbtable =
> 0x4334E030
> ec_reswait = 0x0 ec_dbindex = -1 ec_waittype = 0x0000
> Waittime = 0 ec_umsContext->m_pSched->m_id (SchedulerId) =
> 0x0
> ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
> psrvproc->eclClient = 0 psrvproc->status = 8
> psrvproc->state = SRV_RUNNING psrvproc->bNewPacket =
> 0
> psrvproc->pmo = 0x46EE2030
> psrvproc->ums_context = 0x25A1AC98 psrvproc->threadId =
> 0x55c
> client threadId = 0x0
> psrvproc->pV7LoginRec
> --
> 00000000: b6000000 00000000 00020000 00000000 76780300
> ............vx..
> 00000014: 00000000 20000000 00000000 00000000 56000300 ...
> .........V...
> 00000028: 5c000400 64000500 6e000500 78000b00 00000000 \
> ...d...n...x......
> 0000003C: 8e000a00 a2000a00 00000000 00000000 00000000
> ...............
> 00000050: 00000000 00007700 .....w.
>
>
> psrvproc->m_pwchLangBuff
> --
> 00000000: 7370555f 646f6375 6d656e74 6f735f31 20332c20 spU_documentos_1
> 3,
> 00000014: 342c2027 272c2027 506c616e 6f206465 2050726f 4, '', 'Plano de
> Pro
> 00000028: 6a65746f 272c2027 45737465 20706c61 6e6f2064 jeto', 'Este
> plano
> d
> 0000003C: 65207072 6f6a6574 6f20666f 6920656c 61626f72 e projeto foi
> elabor
> 00000050: 61646f20 6e612066 61736520 3120646f 2070726f ado na fase 1 do
> pro
> 00000064: 6a65746f 20706172 6120636f 7461e7e3 6f20656c jeto para cota..o
> el
> 00000078: 657472f4 6e696361 2e272c20 27323030 352d3033 etr.nica.',
> '2005-
> 03
> 0000008C: 2d303420 30393a31 303a3338 272c2031 2e312c20 -04 09:10:38',
> 1.1,
> 000000A0: 312c2032 2c203132 2c202732 3030352d 30352d31 1, 2, 12,
> '2005-05-
> 1
> 000000B4: 32203039 3a31303a 333827 2 09:10:38'
>
>
> psrvproc->srvio.outbuff
> --
> 00000000: 04010065 00360100 ff0100d4 00000000 00ff1100
> ...e.6...........
> 00000014: c5000100 0000ff01 00c00000 000000ff 0100d500
> ...............
> 00000028: 00000000 ff0100ca 00000000 00aaad00 00000000
> ...............
> 0000003C: 00138c00 53716c44 756d7045 78636570 74696f6e
> ...SqlDumpException
> 00000050: 48616e64 6c65723a 2050726f 63657373 20353420 Handler: Process
> 54
> 00000064: 67656e65 72617465 64206661 74616c20 65786365 generated fatal
> exce
> 00000078: 7074696f 6e206330 30303030 30352045 58434550 ption c0000005
> EXCEP
> 0000008C: 54494f4e 5f414343 4553535f 56494f4c 4154494f
> TION_ACCESS_VIOLATIO
> 000000A0: 4e2e2053 514c2053 65727665 72206973 20746572 N. SQL Server is
> ter
> 000000B4: 6d696e61 74696e67 20746869 73207072 6f636573 minating this
> proces
> 000000C8: 732e0d0a 0541544f 4e321073 70555f64 6f63756d
> s...ATON2.spU_docum
> 000000DC: 656e746f 735f31ff ff000100 00000000 00000000
> entos_1..........
> 000000F0: 00000000 00000100 0000040c 00000004 00000000
> ...............
> 00000104: 08000000 00000000 00040c00 00000806 96000078
> ...............x
> 00000118: 3f1a01ff 1100c100 01000000 ff0100ca 00010000 ?
> ...............
> 0000012C: 00ff0100 ca000100 00007900 000000fe 0000e000
> ........y.......
> 00000140: 01000000 414c5445 520e5553 55415249 4f5f4944
> ...ALTER.USUARIO_ID
> 00000154: 494f4d41 0a454d50 52455341 5f494413 49445f55
> IOMA.EMPRESA_ID.ID_U
> 00000168: 53554152 494f5f49 4e434c55 53414f0d 44415441
> SUARIO_INCLUSAO.DATA
> 0000017C: 5f494e43 4c555341 4f144944 5f555355 4152494f
> _INCLUSAO.ID_USUARIO
> 00000190: 5f414c54 45524143 414f0e44 4154415f 414c5445
> _ALTERACAO.DATA_ALTE
> 000001A4: 52414341 4fa18c00 07001000 38070008 00380200
> RACAO......8...8..
> 000001B8: 08002764 02000800 27320200 08002764 02000800
> ..'d...'2...'d...
> 000001CC: 27c80200 08002732 02000800 27c80200 08002764
> '....'2...'....'d
> 000001E0: 02000800 27c80200 08002796 02000800 27960700
> ...'....'....'...
> 000001F4: 08003807 00080038 07000800 ..8...8...
>
> various psrvproc flags = 0x00000100
>
> EC @.0x46ED39E0
> --
> ec_pss->pspid = 54 ecid = 0 ec_cmderrs = 0
> ec_stat = 0x0 ec_stat2 = 0x100001 ec_atomic = 0x0
> ec_curdb = 20 ec_dbtable = 0x4334e030 ec_dbstat = 0x0
> ec_lospin = 0x0 ec_dbindex = -1 ec_lasterror = 0
> ec_save_ex_number = 0 ec_save_ex_address = 0x00000000
> ec_cpucur = 344 ec_timeslice = 98 ec_next = 0x00000000
> ec_prev = 0x00000000 ec_state = 1 ec_waittype = 0x0000
> ec_dbstat2 = 0 ec_preverror = 0 ec_subecstat = 1
> ec_subecnext = 0x00000000 ec_resSemWaitInfo = 0
> ec_umsContext->m_pSched->m_id (SchedulerId) = 0x0
> ec_umsContext->m_workercntxt->m_id (threadId) = 0x55c
> ec_backupContext = 0x00000000 ec_dbccContext =
> 0x00000000
> ec_allocFile = 0x00000000 ec_buftrace.Index = 21
> ec_buftrace.Entry [0]
> --
> bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
> bdbid = 20 breferences = 54 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [1]
> --
> bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
> bdbid = 20 breferences = 35 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [2]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [3]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [4]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [5]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [6]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [7]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [8]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [9]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [10]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [11]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [12]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [13]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [14]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [15]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [16]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [17]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [18]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [19]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [20]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [21]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [22]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [23]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [24]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [25]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [26]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [27]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [28]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [29]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [30]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [31]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [32]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [33]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [34]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [35]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [36]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [37]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [38]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [39]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [40]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [41]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [42]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [43]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [44]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [45]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [46]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [47]
> --
> bpage = 0x4351C000 bhash = 0x00000000 bpageno = (1:11)
> bdbid = 20 breferences = 2116 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [48]
> --
> bpage = 0x458C8000 bhash = 0x00000000 bpageno = (1:4199)
> bdbid = 20 breferences = 352 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [49]
> --
> bpage = 0x4386E000 bhash = 0x00000000 bpageno = (1:43)
> bdbid = 20 breferences = 1882 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [50]
> --
> bpage = 0x439EE000 bhash = 0x00000000 bpageno = (1:38)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [51]
> --
> bpage = 0x43868000 bhash = 0x00000000 bpageno = (1:40)
> bdbid = 20 breferences = 1885 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [52]
> --
> bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
> bdbid = 20 breferences = 62 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [53]
> --
> bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
> bdbid = 20 breferences = 62 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [54]
> --
> bpage = 0x45BEC000 bhash = 0x00000000 bpageno = (1:7939)
> bdbid = 20 breferences = 31 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [55]
> --
> bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
> bdbid = 20 breferences = 35 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [56]
> --
> bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
> bdbid = 20 breferences = 62 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [57]
> --
> bpage = 0x45BE8000 bhash = 0x00000000 bpageno = (1:7938)
> bdbid = 20 breferences = 62 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [58]
> --
> bpage = 0x45BEC000 bhash = 0x00000000 bpageno = (1:7939)
> bdbid = 20 breferences = 31 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [59]
> --
> bpage = 0x45BDC000 bhash = 0x00000000 bpageno = (1:7439)
> bdbid = 20 breferences = 35 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [60]
> --
> bpage = 0x45BF0000 bhash = 0x00000000 bpageno = (1:7940)
> bdbid = 20 breferences = 259 bstat = 0x9
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [61]
> --
> bpage = 0x43834000 bhash = 0x00000000 bpageno = (1:1)
> bdbid = 20 breferences = 613 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [62]
> --
> bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
> bdbid = 20 breferences = 54 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> ec_buftrace.Entry [63]
> --
> bpage = 0x45CD8000 bhash = 0x00000000 bpageno = (1:1024)
> bdbid = 20 breferences = 54 bstat = 0xb
> bspin = 0 bnext = 0x00000000
>
> EXCEPT (null) @.0x0214F9F8
> --
> exc_number = 0 exc_severity = 0
> exc_func = MSQLErrorHandler+0 Line 0+0x0
>
> Can any one help me ? Please !!!
|||Answer :
1) It always hapend.
2) The proc is:
CREATE PROCEDURE spU_documentos_1
@.DOCUMENTO_ID INT,
@.GRUPO_DOCUMENTO_ID INT,
@.TAREFA_ID INT,
@.DOCUMENTO_NOME VARCHAR(150),
@.DOCUMENTO_DESCRICAO TEXT,
@.DOCUMENTO_DATA DATETIME,
@.DOCUMENTO_VERSAO FLOAT,
@.DOCUMENTO_VISIBILIDADE INT,
@.PROJETO_ID INT,
@.USUARIO_ID_ALTERACAO INT,
@.DATA_ALTERACAO DATETIME
AS
BEGIN TRANSACTION
UPDATE DOCUMENTOS SET
GRUPO_DOCUMENTO_ID = @.GRUPO_DOCUMENTO_ID,
TAREFA_ID = @.TAREFA_ID,
DOCUMENTO_NOME = @.DOCUMENTO_NOME,
DOCUMENTO_DESCRICAO = @.DOCUMENTO_DESCRICAO,
DOCUMENTO_DATA = @.DOCUMENTO_DATA,
DOCUMENTO_VERSAO = @.DOCUMENTO_VERSAO,
DOCUMENTO_VISIBILIDADE =@.DOCUMENTO_VISIBILIDADE,
PROJETO_ID =@.PROJETO_ID,
USUARIO_ID_ALTERACAO = @.USUARIO_ID_ALTERACAO,
DATA_ALTERACAO = @.DATA_ALTERACAO
WHERE DOCUMENTO_ID = @.DOCUMENTO_ID
IF ( @.@.ERROR < > 0 ) GOTO on_error
COMMIT TRANSACTION
RETURN (0)
on_error:
ROLLBACK TRANSACTION
RETURN(1)
Table:
CREATE TABLE [dbo].[DOCUMENTOS] (
[DOCUMENTO_ID] [int] IDENTITY (1, 1) NOT NULL ,
[GRUPO_DOCUMENTO_ID] [int] NOT NULL ,
[TAREFA_ID] [int] NULL ,
[DOCUMENTO_NOME] [varchar] (150) COLLATE Latin1_General_CI_AS NULL ,
[DOCUMENTO_NOME_REAL] [varchar] (150) COLLATE Latin1_General_CI_AS NULL ,
[DOCUMENTO_ARQUIVO_HTML] [text] COLLATE Latin1_General_CI_AS NULL ,
[DOCUMENTO_DESCRICAO] [text] COLLATE Latin1_General_CI_AS NULL ,
[DOCUMENTO_DATA] [datetime] NULL ,
[DOCUMENTO_VERSAO] [float] NULL ,
[DOCUMENTO_VISIBILIDADE] [int] NULL ,
[PROJETO_ID] [int] NULL ,
[USUARIO_ID_INCLUSAO] [int] NULL ,
[DATA_INCLUSAO] [datetime] NULL ,
[USUARIO_ID_ALTERACAO] [int] NULL ,
[DATA_ALTERACAO] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
-=-
So, how do i get in contact with microsoft for suport ?
Thanks for your answer ...
Message posted via http://www.droptable.com
|||You can check if the table is not corrupted with DBCC
CHECKTABLE('DOCUMENTOS'), that might solve the problem. If it doesn't, you
can find the local phone number for Microsoft support on the Microsoft
website.
Jacco Schalkwijk
SQL Server MVP
"Plantador Ren via droptable.com" <forum@.droptable.com> wrote in message
news:91bacf5070e846a6a95ab0cda1f81381@.droptable.co m...
> Answer :
> 1) It always hapend.
> 2) The proc is:
> CREATE PROCEDURE spU_documentos_1
> @.DOCUMENTO_ID INT,
> @.GRUPO_DOCUMENTO_ID INT,
> @.TAREFA_ID INT,
> @.DOCUMENTO_NOME VARCHAR(150),
> @.DOCUMENTO_DESCRICAO TEXT,
> @.DOCUMENTO_DATA DATETIME,
> @.DOCUMENTO_VERSAO FLOAT,
> @.DOCUMENTO_VISIBILIDADE INT,
> @.PROJETO_ID INT,
> @.USUARIO_ID_ALTERACAO INT,
> @.DATA_ALTERACAO DATETIME
> AS
> BEGIN TRANSACTION
> UPDATE DOCUMENTOS SET
> GRUPO_DOCUMENTO_ID = @.GRUPO_DOCUMENTO_ID,
> TAREFA_ID = @.TAREFA_ID,
> DOCUMENTO_NOME = @.DOCUMENTO_NOME,
> DOCUMENTO_DESCRICAO = @.DOCUMENTO_DESCRICAO,
> DOCUMENTO_DATA = @.DOCUMENTO_DATA,
> DOCUMENTO_VERSAO = @.DOCUMENTO_VERSAO,
> DOCUMENTO_VISIBILIDADE =@.DOCUMENTO_VISIBILIDADE,
> PROJETO_ID =@.PROJETO_ID,
> USUARIO_ID_ALTERACAO = @.USUARIO_ID_ALTERACAO,
> DATA_ALTERACAO = @.DATA_ALTERACAO
> WHERE DOCUMENTO_ID = @.DOCUMENTO_ID
> IF ( @.@.ERROR < > 0 ) GOTO on_error
> COMMIT TRANSACTION
> RETURN (0)
> on_error:
> ROLLBACK TRANSACTION
> RETURN(1)
> Table:
> CREATE TABLE [dbo].[DOCUMENTOS] (
> [DOCUMENTO_ID] [int] IDENTITY (1, 1) NOT NULL ,
> [GRUPO_DOCUMENTO_ID] [int] NOT NULL ,
> [TAREFA_ID] [int] NULL ,
> [DOCUMENTO_NOME] [varchar] (150) COLLATE Latin1_General_CI_AS NULL ,
> [DOCUMENTO_NOME_REAL] [varchar] (150) COLLATE Latin1_General_CI_AS NULL ,
> [DOCUMENTO_ARQUIVO_HTML] [text] COLLATE Latin1_General_CI_AS NULL ,
> [DOCUMENTO_DESCRICAO] [text] COLLATE Latin1_General_CI_AS NULL ,
> [DOCUMENTO_DATA] [datetime] NULL ,
> [DOCUMENTO_VERSAO] [float] NULL ,
> [DOCUMENTO_VISIBILIDADE] [int] NULL ,
> [PROJETO_ID] [int] NULL ,
> [USUARIO_ID_INCLUSAO] [int] NULL ,
> [DATA_INCLUSAO] [datetime] NULL ,
> [USUARIO_ID_ALTERACAO] [int] NULL ,
> [DATA_ALTERACAO] [datetime] NULL
> ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
> GO
>
> -=-
> So, how do i get in contact with microsoft for suport ?
> Thanks for your answer ...
> --
> Message posted via http://www.droptable.com