Production Report against OLAP database

We have a large number of (Crystal) Reports ( based on Stor Proc ) running
against our OLTP database (SQL Server).
Instead of reports running against OLTP database I would like to create
Cubes and create production reports against them.
Is it possible to do that? Are there any client applications which allows to
create these types of reports? We don't need real time information.
Any help is greatly appreciated."Atul Mehta" <amehta@.oaktreecap.com> schrieb im Newsbeitrag
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.

---

Atul, you don't necessarily need another Reporting Tool. You need to decide
where you want to build your -> Data Warehouse or -> Data Mart in.
Regards,
Joerg|||If you're looking for cheap and easy, office web components (pivot tables),
or cheap and tedious: ASP web pages and PTS. You might want to see if MSFT
Reporting Services is a potential solution for you.
Another option is to build a star schema reporting database, which will be
useful for building cubes as well, but may eliminate the need.
"Atul Mehta" <amehta@.oaktreecap.com> wrote in message
news:ub8DdHCvDHA.1740@.TK2MSFTNGP12.phx.gbl...

quote:

---

> We have a large number of (Crystal) Reports ( based on Stor Proc ) running
> against our OLTP database (SQL Server).
> Instead of reports running against OLTP database I would like to create
> Cubes and create production reports against them.
> Is it possible to do that? Are there any client applications which allows

---

to

quote:

---

> create these types of reports? We don't need real time information.
> Any help is greatly appreciated.
>
>
>

---

Processors

Does anybody have any experience or know of any articles between 4
dual-core vs. a 8 proc box'
I'm looking at comparing processors exclusively.
ThanksThe licensing price for 4 dual-core is 4 processors but for 8 proc., it's 8
processors. This should be a sufficient argument to chose the former over
the later.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157559259.768841.213380@.h48g2000cwc.googlegroups.com...
> Does anybody have any experience or know of any articles between 4
> dual-core vs. a 8 proc box'
> I'm looking at comparing processors exclusively.
> Thanks
>|||Money for licensing is of no concern.
Sylvain Lafontaine (fill the blanks, no spam please) wrote:
> The licensing price for 4 dual-core is 4 processors but for 8 proc., it's 8
> processors. This should be a sufficient argument to chose the former over
> the later.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
> "Ulan" <wdoman@.gmail.com> wrote in message
> news:1157559259.768841.213380@.h48g2000cwc.googlegroups.com...
> >
> > Does anybody have any experience or know of any articles between 4
> > dual-core vs. a 8 proc box'
> >
> > I'm looking at comparing processors exclusively.
> >
> > Thanks
> >|||Then you're a lucky guy or you are doing a theorytical study.
Comparing a dual core processor with two single cores mean nothing if you
don't specify the type of processor, memory, motherboard (north and south
bridges are important here) and the type of controler used for input/output
. Of course, running 32 or 64 bits will also have some effect on the
results, as well as the type of software and operating system used.
So, comparing only the processors can be tricky.
However, if you want a short answer, single core processor are older
technologies, so they should probably give you a lesser performance in
comparaison against the latest dual-core processors running at the same
frequency on a core by core basis.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...
> Money for licensing is of no concern.
>
>
> Sylvain Lafontaine (fill the blanks, no spam please) wrote:
>> The licensing price for 4 dual-core is 4 processors but for 8 proc., it's
>> 8
>> processors. This should be a sufficient argument to chose the former
>> over
>> the later.
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: http://cerbermail.com/?QugbLEWINF
>>
>> "Ulan" <wdoman@.gmail.com> wrote in message
>> news:1157559259.768841.213380@.h48g2000cwc.googlegroups.com...
>> >
>> > Does anybody have any experience or know of any articles between 4
>> > dual-core vs. a 8 proc box'
>> >
>> > I'm looking at comparing processors exclusively.
>> >
>> > Thanks
>> >
>|||Maybe, to focus my concern slightly, how does SQL 2005 handles
parallelism with dual core vs. single core architectures. With
analytical processes crunching enormous datasets, hundreds of millions
of records, we have found parallelism essential.|||SQL Server doesn't differentiate between a dual core processor and two
single core processors - they're both seen as two processors. The actual
performance is going to depend on the processor architecture - whether the
dual core shares components between the processor for example.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157571394.948255.161810@.d34g2000cwd.googlegroups.com...
>
> Maybe, to focus my concern slightly, how does SQL 2005 handles
> parallelism with dual core vs. single core architectures. With
> analytical processes crunching enormous datasets, hundreds of millions
> of records, we have found parallelism essential.
>|||Multi-cores is not hyperthreading: excerpt for the licensing purpose, there
is no real difference in performance or in functionality between a dual-core
or two single cores.
However, a dual-core will not access the memory in the same way as two
single cores because of the type of memory controler used and the L2 cache
and even then, there are differences between old dual cores and the new
models, the latest beeing able to share their L2 cache between the two
cores.
For a peformance comparaison between the latest serie of Xeon (the Woodcrest
or the 51xx) and the Opteron, see:
http://www.anandtech.com/IT/showdoc.aspx?i=2772 .
In my opinion, you don't have to compare the Woodcrest serie with any of the
previous models of Xeon, either single or dual-core.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157571394.948255.161810@.d34g2000cwd.googlegroups.com...
>
> Maybe, to focus my concern slightly, how does SQL 2005 handles
> parallelism with dual core vs. single core architectures. With
> analytical processes crunching enormous datasets, hundreds of millions
> of records, we have found parallelism essential.
>|||Thank you!!|||"Ulan" <wdoman@.gmail.com> wrote in message
news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...
> Money for licensing is of no concern.
I call "shenanigans" on that statement.
I'll assume you're on the Enterprise version. Last I checked
(more than a year ago) Ent was going for $16,000 a processor.
I don't care what kind of budget you have 4 x 16K = $64,000
is relevant. It's a concern to even a multi-million dollar budget.
If it's truly "of no concern", it's because you're planning on
running it illegally.|||Maybe he works for the Treasury Dept and they just print as much money as
they need.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sgt.Sausage" <nobody@.nowhere.com> wrote in message
news:938ee$4501f2a6$42a1e606$22924@.FUSE.NET...
> "Ulan" <wdoman@.gmail.com> wrote in message
> news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...
>> Money for licensing is of no concern.
> I call "shenanigans" on that statement.
> I'll assume you're on the Enterprise version. Last I checked
> (more than a year ago) Ent was going for $16,000 a processor.
> I don't care what kind of budget you have 4 x 16K = $64,000
> is relevant. It's a concern to even a multi-million dollar budget.
> If it's truly "of no concern", it's because you're planning on
> running it illegally.
>

Processors

Does anybody have any experience or know of any articles between 4
dual-core vs. a 8 proc box'
I'm looking at comparing processors exclusively.
ThanksThe licensing price for 4 dual-core is 4 processors but for 8 proc., it's 8
processors. This should be a sufficient argument to chose the former over
the later.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157559259.768841.213380@.h48g2000cwc.googlegroups.com...
> Does anybody have any experience or know of any articles between 4
> dual-core vs. a 8 proc box'
> I'm looking at comparing processors exclusively.
> Thanks
>|||Money for licensing is of no concern.
Sylvain Lafontaine (fill the blanks, no spam please) wrote:[vbcol=seagreen]
> The licensing price for 4 dual-core is 4 processors but for 8 proc., it's
8
> processors. This should be a sufficient argument to chose the former over
> the later.
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: http://cerbermail.com/?QugbLEWINF
>
> "Ulan" <wdoman@.gmail.com> wrote in message
> news:1157559259.768841.213380@.h48g2000cwc.googlegroups.com...|||Then you're a lucky guy or you are doing a theorytical study.
Comparing a dual core processor with two single cores mean nothing if you
don't specify the type of processor, memory, motherboard (north and south
bridges are important here) and the type of controler used for input/output
. Of course, running 32 or 64 bits will also have some effect on the
results, as well as the type of software and operating system used.
So, comparing only the processors can be tricky.
However, if you want a short answer, single core processor are older
technologies, so they should probably give you a lesser performance in
comparaison against the latest dual-core processors running at the same
frequency on a core by core basis.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...
> Money for licensing is of no concern.
>
>
> Sylvain Lafontaine (fill the blanks, no spam please) wrote:
>|||Maybe, to focus my concern slightly, how does SQL 2005 handles
parallelism with dual core vs. single core architectures. With
analytical processes crunching enormous datasets, hundreds of millions
of records, we have found parallelism essential.|||SQL Server doesn't differentiate between a dual core processor and two
single core processors - they're both seen as two processors. The actual
performance is going to depend on the processor architecture - whether the
dual core shares components between the processor for example.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157571394.948255.161810@.d34g2000cwd.googlegroups.com...
>
> Maybe, to focus my concern slightly, how does SQL 2005 handles
> parallelism with dual core vs. single core architectures. With
> analytical processes crunching enormous datasets, hundreds of millions
> of records, we have found parallelism essential.
>|||Multi-cores is not hyperthreading: excerpt for the licensing purpose, there
is no real difference in performance or in functionality between a dual-core
or two single cores.
However, a dual-core will not access the memory in the same way as two
single cores because of the type of memory controler used and the L2 cache
and even then, there are differences between old dual cores and the new
models, the latest beeing able to share their L2 cache between the two
cores.
For a peformance comparaison between the latest serie of Xeon (the Woodcrest
or the 51xx) and the Opteron, see:
http://www.anandtech.com/IT/showdoc.aspx?i=2772 .
In my opinion, you don't have to compare the Woodcrest serie with any of the
previous models of Xeon, either single or dual-core.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Ulan" <wdoman@.gmail.com> wrote in message
news:1157571394.948255.161810@.d34g2000cwd.googlegroups.com...
>
> Maybe, to focus my concern slightly, how does SQL 2005 handles
> parallelism with dual core vs. single core architectures. With
> analytical processes crunching enormous datasets, hundreds of millions
> of records, we have found parallelism essential.
>|||Thank you!!|||"Ulan" <wdoman@.gmail.com> wrote in message
news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...

> Money for licensing is of no concern.
I call "shenanigans" on that statement.
I'll assume you're on the Enterprise version. Last I checked
(more than a year ago) Ent was going for $16,000 a processor.
I don't care what kind of budget you have 4 x 16K = $64,000
is relevant. It's a concern to even a multi-million dollar budget.
If it's truly "of no concern", it's because you're planning on
running it illegally.|||Maybe he works for the Treasury Dept and they just print as much money as
they need.
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
"Sgt.Sausage" <nobody@.nowhere.com> wrote in message
news:938ee$4501f2a6$42a1e606$22924@.FUSE.NET...
> "Ulan" <wdoman@.gmail.com> wrote in message
> news:1157564917.777675.299710@.p79g2000cwp.googlegroups.com...
>
> I call "shenanigans" on that statement.
> I'll assume you're on the Enterprise version. Last I checked
> (more than a year ago) Ent was going for $16,000 a processor.
> I don't care what kind of budget you have 4 x 16K = $64,000
> is relevant. It's a concern to even a multi-million dollar budget.
> If it's truly "of no concern", it's because you're planning on
> running it illegally.
>

Processing the resultset of another proc from a proc

Is it possible to retrieve the resultset of a stored procedure from another procedure in sql server 2000.
Basically I am calling proc2 from the inside of proc1.
proc2 returns 2 resultsets. I want to process these two resultsets
from within proc1.

If its possible , please provide sample code.

thanks in advance,
Alok.Yes, with temporary tables for instance. But it will be easier if you can convert proc2 to two UDF table functions. Your code will be much clearer and simpler to maintain.

process result recordset from storedproc

hi!
I have a stored proc which aggregates some values and
returns a recordset with one record
...looking something like this:
val1 val2 val3
-- -- --
24723 26457 342579
how can I use this record for further processing
e.g. write it into an existing table (for logging)
hmm, this is probably a newbie-question
but I couldnt find the answer in BOL...
any help is greatly appreciated,
best regards,
haraldIf you want to handle only one record you can use variables to store and use
it.
For eg:
Declare @.Val1 int , @.Val2 int ...
Select @.Val1 = Val1, @.Val2 = Val2 etv...
Insert into TableName (@.Val1, @.val2 etc..
Other wise you can use a cursor for looping it.
Please refer books online.
Thank you
Baiju
"Harald Peki" <mabuse007@.yahoo.com> wrote in message
news:1109832522.363076@.news.liwest.at...
> hi!
> I have a stored proc which aggregates some values and
> returns a recordset with one record
> ...looking something like this:
> val1 val2 val3
> -- -- --
> 24723 26457 342579
> how can I use this record for further processing
> e.g. write it into an existing table (for logging)
>
> hmm, this is probably a newbie-question
> but I couldnt find the answer in BOL...
> any help is greatly appreciated,
> best regards,
> harald
>
>|||hello baiju,
thanks very much - I am aware of cursors, but hoped there would be a
easier and more elegant solution.
generally asked: isnt there a way to use the storedproc-recordset in the
same
way like the resultset of a function which returns a table?
I this case I can use a statement like this:
INSERT INTO StatsTables
SELECT * FROM dbo.adm_CountAllTables_function()
...where dbo.adm_CountAllTables_function() is - obviously ;))) - a
function...
hmm, I guess it IS the most usefull solution to change the storedproc to a
function.
Im most thankful for any further comments.
best regards,
harald
"Baiju" <baiju@.indus-systems.com> schrieb im Newsbeitrag
news:uhfN$f8HFHA.4032@.TK2MSFTNGP12.phx.gbl...
> If you want to handle only one record you can use variables to store and
use
> it.
> For eg:
> Declare @.Val1 int , @.Val2 int ...
> Select @.Val1 = Val1, @.Val2 = Val2 etv...
> Insert into TableName (@.Val1, @.val2 etc..
>
> Other wise you can use a cursor for looping it.
> Please refer books online.
>
> Thank you
> Baiju
>
> "Harald Peki" <mabuse007@.yahoo.com> wrote in message
> news:1109832522.363076@.news.liwest.at...
>|||use
insert into table_name
exec proc_name
"Harald Peki" wrote:

> hi!
> I have a stored proc which aggregates some values and
> returns a recordset with one record
> ...looking something like this:
> val1 val2 val3
> -- -- --
> 24723 26457 342579
> how can I use this record for further processing
> e.g. write it into an existing table (for logging)
>
> hmm, this is probably a newbie-question
> but I couldnt find the answer in BOL...
> any help is greatly appreciated,
> best regards,
> harald
>
>|||hi tom!

> insert into table_name
> exec proc_name
oops! great!!!
...but funny...tried that one but obviously had some syntax mistake or
something...
WORKS GREAT NOW!!
Thanks very, very much!
all systems up and running ;))
best regards,
harald
"Tomasz Borawski" <TomaszBorawski@.discussions.microsoft.com> schrieb im
Newsbeitrag news:4895E3C4-C967-46BB-99F4-54724C98CE71@.microsoft.com...
> use
> insert into table_name
> exec proc_name
>
> "Harald Peki" wrote:
>

process is blocking itself

I have a stored proc created for report and now suddenly the report is takin
g
lot of time to run. The store proc is having simple select statement with
multiple case statements.
I checked the sysprocesses table and noticed that the process is blocking
itself.
What could be reason and how to solve this issue'
ThanksSo you are saying that when you run sp_who the spid that appears in
the "blk" column is the SAME as the value in the "spid" column of the
same line?
Roy Harvey
Beacon Falls, CT
On Thu, 8 Jun 2006 12:54:02 -0700, TSQL
<TSQL@.discussions.microsoft.com> wrote:

>I have a stored proc created for report and now suddenly the report is taki
ng
>lot of time to run. The store proc is having simple select statement with
>multiple case statements.
>I checked the sysprocesses table and noticed that the process is blocking
>itself.
>What could be reason and how to solve this issue'
>Thanks|||You're running SQL 2000 with SP4 installed:
http://support.microsoft.com/defaul...KB;EN-US;906344
TSQL wrote:
> I have a stored proc created for report and now suddenly the report is tak
ing
> lot of time to run. The store proc is having simple select statement with
> multiple case statements.
> I checked the sysprocesses table and noticed that the process is blocking
> itself.
> What could be reason and how to solve this issue'
> Thanks|||Yes Exactly.
I ran -
select * from sysprocesses
where physical_io>25 or cpu>15 or memusage>15
order by blocked desc
"Roy Harvey" wrote:

> So you are saying that when you run sp_who the spid that appears in
> the "blk" column is the SAME as the value in the "spid" column of the
> same line?
> Roy Harvey
> Beacon Falls, CT
>
> On Thu, 8 Jun 2006 12:54:02 -0700, TSQL
> <TSQL@.discussions.microsoft.com> wrote:
>
>|||seems wierd. Try it with
OPYION (MAXDOP 1) and
and recompile the stored procedure.
Can you post the script?
--
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/|||SQL 2000 latches quite often block other latch request from the same
SPID by design (which Tracy also acknowledged; see
http://support.microsoft.com/default.aspx/kb/906344). With SP4
Microsoft have started displaying those latch blocks (in addition to the
lock blocks) in the blocked column of sysprocesses, so now it looks like
a SPID is blocking itself (which, I guess, technically, it is) but in
fact it's usually just waiting on a page to be read into memory due to
slow I/O.
*mike hodgson*
http://sqlnerd.blogspot.com
Omnibuzz wrote:

>seems wierd. Try it with
>OPYION (MAXDOP 1) and
>and recompile the stored procedure.
>Can you post the script?
>|||Thanks Mike, Tracy. Went through the article. Makes sense. Makes a lot of
sense.
-Omnibuzz (The SQL GC)
http://omnibuzz-sql.blogspot.com/

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@.SQ
droptable.com...
> 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 00000
051
> [2] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323
931
> [3] 0040ACC8: 8B5609EB 027E80F1 80F07500 80000266 83000166 C6000
466
> [4] 46EBA388: 04012300 46ED35D0 00000000 00000001 00100030 2E323
931
> 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 2E323
931
> [2] 005E6658: 8BF875FF E8006ACE FFE33DFF 83FC45FF 458B18C3 0C473
BFC
> [3] 46EBA120: 46EBA1B8 00000001 46EBA4D8 46EBA4E0 00000000 00000
000
> [4] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000
000
> 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 00000
000
> [2] 46ED36B8: 00000036 00000000 009809E7 00009652 00000000 00000
000
> [3] 46EBA068: 00990294 00650072 324172E1 00002050 00000001 60000
000
> [4] 46EBA284: 00230023 00000010 3400D008 00000000 00993560 46EBA
3A0
> 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 8B550
004
> [2] 00000360:
> [3] 25EBFDB8: 00000003 25EBFDD0 00BD0000 00000013 00BD0000 25A13
758
> [4] 7974B8DF: 0A7DC085 C950E850 C033FFFD 016A03EB 08C25D58 EC8B5
500
> ----
--
> --
> * 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 00D36
978
> [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 N
ULL ,
[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@.SQ
droptable.com...
> 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

Process 54 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION.

Hi I´m 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 cotação eletrônica.', '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 cotação eletrônica.', '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 SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in
message news:4c09a2707e4c42efbf85914e6c1a0d9d@.SQLMonster.com...
> Hi I´m 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 cotação eletrônica.', '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 cotação eletrônica.', '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.sqlmonster.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 SQLMonster.com" <forum@.SQLMonster.com> wrote in message
news:91bacf5070e846a6a95ab0cda1f81381@.SQLMonster.com...
> 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.sqlmonster.com