Product Level is Insufficient

I am receiving the following error when I try to execute an SSIS package that is saved to a structured file. I am using DTExec to execute the package.

Description: The task "Initialize Variables" cannot run on this edition of Integration Services. It requires a higher level edition.

After some research, I was able to find a supporting article in SQL Server 2005 BOL at http://msdn2.microsoft.com/en-us/library/aa337371.aspx

The issue was resolved by installing the Enterprise Edition of SQL Server Integration Services (Windows Service) on the local server (server where the package is saved and executed from). However, this goes against my original anticipation that the SSIS Windows Service would only need to be installed on a machine where I needed to store packages and/or monitor package execution. Not if I wanted to execute packages.

Unfortunately, my package is using advanced options (as identified in the BOL article previously referenced).

Am I missing something?

Sincerely,

Sean Fitzgerald

You are trying to execute these packages from a remote machine (such as your desktop and not the SQL Server), correct? You need to have a matching edition of the SSIS client tools loaded on your desktop to be able to run those packages remotely.|||You do need the SSIS installed where the packages runs.
It does not matter where the package is stored.

See my blog entries about this:
http://blogs.msdn.com/michen/archive/2006/08/11/package-exec-location.aspx
http://blogs.msdn.com/michen/archive/2006/11/11/ssis-product-level-is-insufficient.aspx

Processing AS2000 Cubes from SSIS

Hi All,

I have a scenario where I want to execute AS 2000 Cubes from a SSIS package. In my Prod environment I have two servers one with the SQL 2000 database and the AS2000 cubes on it and the other with SSIS installed on it.

What I am doing here is I have a DTS package with a process cube task in it, this DTS package is saved as a structured file and then I call this DTS package from SSIS using the Execurte 2000 package task. Just FYI the process cubes task is using local as the server reference. I want to know how this will work when I execute this DTS package from within an SSIS package running on a different server? Appreciate all help.

Thanks

The "normal" way to process AS 2000 from DTS was to use the OLAP Processing task for the job, but that only gets installed as part of AS 2000, and hence will not be available on your SSIS/DTS machine. Using local as the server reference will also fail, unless you run the DTS package on the AS server, as quite obviously the local server is not the AS server, for a package running on SSIS/DTS machine. There is no magic way to get the DTS package to run on the other machine, other than calling the package from that machine itself. I would stick with a DTS package on the AS2000 box.

|||

Thanks Darren,

Actually I do have DTS and AS2000 installed on the same server which also has SQL Server 2000 databases on it, However I am executing these DTS packages (which process the cubes using local as server reference) from SSIS packages which are running on a different server. The DTS packages are saved as structured files on the SSIS server. Hope I am explaining it properly - what my concern is, whether executing these DTS packages having process cubes task within it from a different server will work?

Appreciate your help.

Thanks

|||

I Still have this concern whether my packages will run or not, it would be better to know now rather than getting to know in prod. Any help is appreciated.

Thanks

|||No this will not work. All the AS stuff is on the wrong server, it needs to be on the server upon which the DTS package runs. If calling DTS from SSIS then that means the DTS package runs on the same server as SSIS, which is not the AS server. This is all about execution location, which for both DTS and SSIS is cleint side, they are not client/server like SQL Server.|||

Thanks Darren,

Appreciate your help.

Thanks

|||

Hi,

I have a Cube on my AS2000 server running on the same machine as my SQL server 2000. I can execute the DTS from the SQL Enterprise manager properly.

I need to implement a C# code that will enable me to execute the DTS. I already have one as follows which works on any DTS:

---

Package2Class package = new Package2Class();

object pVarPersistStgOfHost = null;

package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref pVarPersistStgOfHost);

package.Execute();

---

As I said, it works with any DTS, but as soon as I work with one which Processes Cubes, it hangs for about 2 hours, when the cube can normally be processed in 20 seconds, and crash on the following

DTS Execution error:

Do you have a clue why is it so please?

|||

I've been thinking about this some more. As I recall you can process OLAP 200 cubes remotely, well I think you could in DTS, so all you need is -

1 DTS

2 DSO

3 OLAP Task

Now in SSIS we have 1 already. 2 we can get, see the feature pack download on MS site April or November. For 3, the task, it seems that the documenattion says you need to install AS 200 to get this, well as I recall it was actually just a DTS custom task that used DSO, so why not go get the DLL, register it by hand in DTS, and give it a try -

The task DLL should be in X:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll on any SQL 2000 box with AS installed.

|||

Darren,

I am using SQL Server 2000. I do not have SSIS and I have to get this sorted way before we upgrade to 2005.

1. Are there any issues with the methods LoadFromSQLServer from the class Package2Class when we invoke a DTS with OLAP Cube.

2. I have already installed Analysis Services. When I deployed my application to a test web server which has SQL client installed, I have a COM exception. Does it mean that I need to have AS2000 installed in order for LoadFromSQLServer to instantiate the correct steps object which are of type OLAP tasks?

Can you please advise me on the coding and permission stuff that will allow a code on .net 1.1 (since it is an upgrade on a legacy system) to launch a DTS on SQL2000 which processes a cube on AS2000?

Thanks

WaaZ

|||

WaaZ, I was replying to the thread from db_guy. I'm not sure why you have posted a DTS question in the SSIS forum, and it is not really the same issue anyway, as you are not using SSIS at all. A better thread would make more sense to start with, but this is a SSIS focused forum I'm afraid. I can branch into a new thread if you want.

1 - No issues with that method that would not be raised if using another execution host in the same location and context. Instead of running your application, try running DTSRUN in the same place, as the same user, and see what errors you get.

2 - To load a DTS package, you need DTS installed locally. If you use the AS Proc Task, then you need AS support and the AS task also installed locally.

|||

Thanks Darren,

Finally we decided that we will be processing the cubes using DTS and not SSIS, but I will surely try to test the stuff you mentioned , will let you know soon.

Thanks

Processing AS2000 Cubes from SSIS

Hi All,

I have a scenario where I want to execute AS 2000 Cubes from a SSIS package. In my Prod environment I have two servers one with the SQL 2000 database and the AS2000 cubes on it and the other with SSIS installed on it.

What I am doing here is I have a DTS package with a process cube task in it, this DTS package is saved as a structured file and then I call this DTS package from SSIS using the Execurte 2000 package task. Just FYI the process cubes task is using local as the server reference. I want to know how this will work when I execute this DTS package from within an SSIS package running on a different server? Appreciate all help.

Thanks

The "normal" way to process AS 2000 from DTS was to use the OLAP Processing task for the job, but that only gets installed as part of AS 2000, and hence will not be available on your SSIS/DTS machine. Using local as the server reference will also fail, unless you run the DTS package on the AS server, as quite obviously the local server is not the AS server, for a package running on SSIS/DTS machine. There is no magic way to get the DTS package to run on the other machine, other than calling the package from that machine itself. I would stick with a DTS package on the AS2000 box.

|||

Thanks Darren,

Actually I do have DTS and AS2000 installed on the same server which also has SQL Server 2000 databases on it, However I am executing these DTS packages (which process the cubes using local as server reference) from SSIS packages which are running on a different server. The DTS packages are saved as structured files on the SSIS server. Hope I am explaining it properly - what my concern is, whether executing these DTS packages having process cubes task within it from a different server will work?

Appreciate your help.

Thanks

|||

I Still have this concern whether my packages will run or not, it would be better to know now rather than getting to know in prod. Any help is appreciated.

Thanks

|||No this will not work. All the AS stuff is on the wrong server, it needs to be on the server upon which the DTS package runs. If calling DTS from SSIS then that means the DTS package runs on the same server as SSIS, which is not the AS server. This is all about execution location, which for both DTS and SSIS is cleint side, they are not client/server like SQL Server.|||

Thanks Darren,

Appreciate your help.

Thanks

|||

Hi,

I have a Cube on my AS2000 server running on the same machine as my SQL server 2000. I can execute the DTS from the SQL Enterprise manager properly.

I need to implement a C# code that will enable me to execute the DTS. I already have one as follows which works on any DTS:

---

Package2Class package = new Package2Class();

object pVarPersistStgOfHost = null;

package.LoadFromSQLServer(serverName,null,null,DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,null,null,null,packageName,ref pVarPersistStgOfHost);

package.Execute();

---

As I said, it works with any DTS, but as soon as I work with one which Processes Cubes, it hangs for about 2 hours, when the cube can normally be processed in 20 seconds, and crash on the following

DTS Execution error:

Do you have a clue why is it so please?

|||

I've been thinking about this some more. As I recall you can process OLAP 200 cubes remotely, well I think you could in DTS, so all you need is -

1 DTS

2 DSO

3 OLAP Task

Now in SSIS we have 1 already. 2 we can get, see the feature pack download on MS site April or November. For 3, the task, it seems that the documenattion says you need to install AS 200 to get this, well as I recall it was actually just a DTS custom task that used DSO, so why not go get the DLL, register it by hand in DTS, and give it a try -

The task DLL should be in X:\Program Files\Microsoft Analysis Services\Bin\msmdtsp.dll on any SQL 2000 box with AS installed.

|||

Darren,

I am using SQL Server 2000. I do not have SSIS and I have to get this sorted way before we upgrade to 2005.

1. Are there any issues with the methods LoadFromSQLServer from the class Package2Class when we invoke a DTS with OLAP Cube.

2. I have already installed Analysis Services. When I deployed my application to a test web server which has SQL client installed, I have a COM exception. Does it mean that I need to have AS2000 installed in order for LoadFromSQLServer to instantiate the correct steps object which are of type OLAP tasks?

Can you please advise me on the coding and permission stuff that will allow a code on .net 1.1 (since it is an upgrade on a legacy system) to launch a DTS on SQL2000 which processes a cube on AS2000?

Thanks

WaaZ

|||

WaaZ, I was replying to the thread from db_guy. I'm not sure why you have posted a DTS question in the SSIS forum, and it is not really the same issue anyway, as you are not using SSIS at all. A better thread would make more sense to start with, but this is a SSIS focused forum I'm afraid. I can branch into a new thread if you want.

1 - No issues with that method that would not be raised if using another execution host in the same location and context. Instead of running your application, try running DTSRUN in the same place, as the same user, and see what errors you get.

2 - To load a DTS package, you need DTS installed locally. If you use the AS Proc Task, then you need AS support and the AS task also installed locally.

|||

Thanks Darren,

Finally we decided that we will be processing the cubes using DTS and not SSIS, but I will surely try to test the stuff you mentioned , will let you know soon.

Thanks

processadmin role

I'm trying to allow my developers the ability to modify/execute their jobs and dts packages in production...without giving away the security farm so to speak.

Is the processadmin role a possibility?

BOL and the net only seems to say this role allows user to "manage process"...duh.

Your thoughts and advice would be great appreciated.The processadmin server role conveys the ability to kill a process (SPID) in SQL Server. Can't say as I would be comfy with a lot of people with that ability, myself.

In order to create/delete jobs, they will need access to the msdb database (by default all users do), and permissions on the following stored procedures, which also default to public:

sp_add_job
sp_add_jobschedule
sp_add_jobserver
sp_add_jobstep
sp_delete_job
sp_delete_jobschedule
sp_delete_jobserver
sp_delete_jobstep
sp_start_job
sp_stop_job
sp_update_job
sp_update_jobschedule
sp_update_jobstep|||If I give them this kind of access in msdb, won't it give them job and dts access to all databases?|||Jobs and DTS packages are stored only in the msdb database, so yes. That's just the way the system is set up. If their user ids can access all databases, you would have had that, anyway. I am not sure if a user can try to specify a different user to run a job.

process could not execute 'sp_repldone/sp_replcounters.. Another log reader is replicatin

Hilary, Paul.
I have read some of your threads on some sites
regarding this. You had suggested that maybe
restarting sql agent/server would resolve this.
I tried that with no luck. I have yet to reboot
the server, because it's in a production
enviroment. I will try that this weekend at
night. However, i was wondering. I get this
error quit a bit on all publications going
through this particular distributor. resources
are fine on both the publisher and distributor.
Is there anything else I can check to resolve
this. reinitializing isn't an option.
Thanks guys..
comb
stop the sql server agent. If this does not solve the problem, stop it,
issue a sp_replflush and then restart it.
If this does not clear the problem, enable logging and post the error
message you get back here.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
"Combfilter" <adsf@.asdf.com> wrote in message
news:MPG.1bc491484347f0de9896b5@.news.newsreader.co m...
> Hilary, Paul.
> I have read some of your threads on some sites
> regarding this. You had suggested that maybe
> restarting sql agent/server would resolve this.
> I tried that with no luck. I have yet to reboot
> the server, because it's in a production
> enviroment. I will try that this weekend at
> night. However, i was wondering. I get this
> error quit a bit on all publications going
> through this particular distributor. resources
> are fine on both the publisher and distributor.
> Is there anything else I can check to resolve
> this. reinitializing isn't an option.
> Thanks guys..
> comb

process could not execute 'sp_repldone/sp_replcounters'

I have had to fully restored my publisher database. Since then my
transaactional replication no longer works with the 'Log Reader' failing to
start and reporting the error message "The process could not execute
'sp_repldone/sp_replcounters' on ServerName".
I have run via Enterprise Manager 'Validate Subscriptions' and
'Re-initialize All Subscriptions' but the Log Reader still fails. Should I
simply re-start the server or run sp_replrestart?
Any assistance would be greatly appreciated.
Kind regards
Robert
the fastest way to fix this is to drop and recreate your subscription.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Robert Paynter" <Robert Paynter@.discussions.microsoft.com> wrote in message
news:AD6E580D-02D3-4722-8AA0-E33979A1F0FD@.microsoft.com...
> I have had to fully restored my publisher database. Since then my
> transaactional replication no longer works with the 'Log Reader' failing
to
> start and reporting the error message "The process could not execute
> 'sp_repldone/sp_replcounters' on ServerName".
> I have run via Enterprise Manager 'Validate Subscriptions' and
> 'Re-initialize All Subscriptions' but the Log Reader still fails. Should
I
> simply re-start the server or run sp_replrestart?
> Any assistance would be greatly appreciated.
> Kind regards
> Robert
|||Hi Hilary
Many thanks for your reply. Just so I am clear in Enterprise Manager I
would delete the existing pulication and create a 'New Publication'
Also could I ask a related question ..... On the destination server the
existing Subcription (Enterprise Manager\Replication\Subscriptions\....)
does not delete when a publication is deleted via Enterprise Manager. In the
past I have investiigated how to delete old subscriptions without success.
Is there a way of doing this of which you are aware?
Again thank you for your kind assistance.
Kind regards
Rob
"Hilary Cotter" wrote:

> the fastest way to fix this is to drop and recreate your subscription.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Robert Paynter" <Robert Paynter@.discussions.microsoft.com> wrote in message
> news:AD6E580D-02D3-4722-8AA0-E33979A1F0FD@.microsoft.com...
> to
> I
>
>
|||Yes, if you script out your publication first it will be easier for you to
rebuild it.
Yes, there are two reasons why you get these orphaned subscribers, well
three actually, the third involves Paul Ibison and a big bottle of Scotch,
but he has sworn me to secrecy on this one.
If you restore an unpublished database onto a published database you can
orphan your subscribers. If you drop a pull subscription through a script on
the publisher only you can orphan them.
I can normally right click on the subscription and then delete it. If not I
manually remove the entry from mssubscription_properties.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Robert Paynter" <RobertPaynter@.discussions.microsoft.com> wrote in message
news:E433EA9D-8239-4256-908C-9CA841D24DF1@.microsoft.com...
> Hi Hilary
> Many thanks for your reply. Just so I am clear in Enterprise Manager I
> would delete the existing pulication and create a 'New Publication'
> Also could I ask a related question ..... On the destination server the
> existing Subcription (Enterprise Manager\Replication\Subscriptions\....)
> does not delete when a publication is deleted via Enterprise Manager. In
the[vbcol=seagreen]
> past I have investiigated how to delete old subscriptions without success.
> Is there a way of doing this of which you are aware?
> Again thank you for your kind assistance.
> Kind regards
> Rob
> "Hilary Cotter" wrote:
message[vbcol=seagreen]
failing[vbcol=seagreen]
Should[vbcol=seagreen]
|||Hi Hilary
Again I would like to thank you for your reply and the time you give to do
this. I shall proceed with fixing the problem as advised and we'll be able
to get the subscription database functioning again.
Again many thanks.
Kind regards
Rob
"Hilary Cotter" wrote:

> Yes, if you script out your publication first it will be easier for you to
> rebuild it.
> Yes, there are two reasons why you get these orphaned subscribers, well
> three actually, the third involves Paul Ibison and a big bottle of Scotch,
> but he has sworn me to secrecy on this one.
> If you restore an unpublished database onto a published database you can
> orphan your subscribers. If you drop a pull subscription through a script on
> the publisher only you can orphan them.
> I can normally right click on the subscription and then delete it. If not I
> manually remove the entry from mssubscription_properties.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Robert Paynter" <RobertPaynter@.discussions.microsoft.com> wrote in message
> news:E433EA9D-8239-4256-908C-9CA841D24DF1@.microsoft.com...
> the
> message
> failing
> Should
>
>

Process Admin

Can I give a developer the ability to execute DTS pkgs without this server wide permission?If that user has underlying permission on the tables then no need to have any server-wide permissions. Refer to KBA http://support.microsoft.com/kb/269074 for more information.

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