Thursday, March 29, 2012
Field overflow and Log grow
I am using SQL Server 2000.
One user database contains a table as following:
CREATE TABLE Events..Audit_Sub (
[RecID] [bigint] NOT NULL ,
[Name] [varchar] (100) NULL ,
[Value] [varchar] (1024) NULL
) ON [PRIMARY]
Sometimes the application writes to the table a record that overflows the
size of the Value field (actually because of an error in the new code, the
appilcation attempts to write about 5Kb to the Valaue field).
The fact is:
- No error is detected on SQL Server, data is written to tha table, it is
visible by select, it is just truncated to the field size (1Kb).
- In the meanwhile it appears that DB log begins growing: the things are not
directly dependent, just somewhat later the log begins growing, but no error
is found in SQL errorlog.
- Later on transaction log cannot be backup up, data are no more written to
DB, but then it is too late to understand the reason why.
The question is:
- In which way may the two things (overflow and log grow) be related?
- What really happens on SQL server when data overflow occurs? How does it
handle?
Thanks in advance,
MRMarco
> - In the meanwhile it appears that DB log begins growing: the things are
> not
> directly dependent, just somewhat later the log begins growing, but no
> error
> is found in SQL errorlog.
> - In which way may the two things (overflow and log grow) be related?
It does not matter whether or not overflow occured. the log file grows up
and it is not truncated unless you have SIMPLE recovery mode the database
set
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
create table t (c1 tinyint, c2 varchar (5))
--owerflow on c1 column
insert into t values(4545745454545,'a')
--Server: Msg 8115, Level 16, State 2, Line 1
--Arithmetic overflow error converting expression to data type tinyint.
--The statement has been terminated.
select * from t
--(0 row(s) affected)
--now insert much more characters than you defined for c2 columnn
insert into t values(1,'asgtbvtybvtg')
--Server: Msg 8152, Level 16, State 9, Line 1
--String or binary data would be truncated.
--The statement has been terminated.
select * from t
--(0 row(s) affected)
"Marco Roda" <mrtest@.amdosoft.com> wrote in message
news:e8t656$le6$1@.ss408.t-com.hr...
> Hi,
> I am using SQL Server 2000.
> One user database contains a table as following:
> CREATE TABLE Events..Audit_Sub (
> [RecID] [bigint] NOT NULL ,
> [Name] [varchar] (100) NULL ,
> [Value] [varchar] (1024) NULL
> ) ON [PRIMARY]
> Sometimes the application writes to the table a record that overflows the
> size of the Value field (actually because of an error in the new code, the
> appilcation attempts to write about 5Kb to the Valaue field).
> The fact is:
> - No error is detected on SQL Server, data is written to tha table, it is
> visible by select, it is just truncated to the field size (1Kb).
> - In the meanwhile it appears that DB log begins growing: the things are
> not
> directly dependent, just somewhat later the log begins growing, but no
> error
> is found in SQL errorlog.
> - Later on transaction log cannot be backup up, data are no more written
> to
> DB, but then it is too late to understand the reason why.
> The question is:
> - In which way may the two things (overflow and log grow) be related?
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
> Thanks in advance,
> MR
>
>
>|||Hi
At a guess you have the ANSI_WARNINGS setting off as "When OFF, data is
truncated to the size of the column and the statement succeeds. " e.g
SET ANSI_WARNINGS ON
DECLARE @.error int
CREATE TABLE #tmp ( col1 char(1) NOT NULL )
BEGIN TRANSACTION
INSERT INTO #tmp ( col1 ) values ( 'AA' )
SET @.error = @.@.ERROR
IF @.error <> 0
BEGIN
SELECT 'Transaction Rolled Back Error Status: ' + CAST(@.error as varchar(30))
ROLLBACK TRANSACTIOn
END
ELSE
BEGIN
PRINT 'Transaction Comitted'
COMMIT TRANSACTION
END
GO
SELECT * from #tmp
GO
DROP TABLE #tmp
GO
/*
Msg 8152, Level 16, State 14, Line 5
String or binary data would be truncated.
The statement has been terminated.
----
Transaction Rolled Back Error Status: 8152
(1 row(s) affected)
col1
--
(0 row(s) affected)
*/
SET ANSI_WARNINGS OFF
DECLARE @.error int
CREATE TABLE #tmp ( col1 char(1) NOT NULL )
BEGIN TRANSACTION
INSERT INTO #tmp ( col1 ) values ( 'AA' )
SET @.error = @.@.ERROR
IF @.error <> 0
BEGIN
SELECT 'Transaction Rolled Back Error Status: ' + CAST(@.error as varchar(30))
ROLLBACK TRANSACTIOn
END
ELSE
BEGIN
PRINT 'Transaction Comitted'
COMMIT TRANSACTION
END
GO
SELECT * from #tmp
GO
DROP TABLE #tmp
GO
/*
(1 row(s) affected)
Transaction Comitted
col1
--
A
(1 row(s) affected)
*/
although with your log file growing it may be that you have detected an
error and not rolled back the transaction, use DBCC OPENTRAN to view open
transactions.
John
"Marco Roda" wrote:
> Hi,
> I am using SQL Server 2000.
> One user database contains a table as following:
> CREATE TABLE Events..Audit_Sub (
> [RecID] [bigint] NOT NULL ,
> [Name] [varchar] (100) NULL ,
> [Value] [varchar] (1024) NULL
> ) ON [PRIMARY]
> Sometimes the application writes to the table a record that overflows the
> size of the Value field (actually because of an error in the new code, the
> appilcation attempts to write about 5Kb to the Valaue field).
> The fact is:
> - No error is detected on SQL Server, data is written to tha table, it is
> visible by select, it is just truncated to the field size (1Kb).
> - In the meanwhile it appears that DB log begins growing: the things are not
> directly dependent, just somewhat later the log begins growing, but no error
> is found in SQL errorlog.
> - Later on transaction log cannot be backup up, data are no more written to
> DB, but then it is too late to understand the reason why.
> The question is:
> - In which way may the two things (overflow and log grow) be related?
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
> Thanks in advance,
> MR
>
>
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uozopRApGHA.4996@.TK2MSFTNGP05.phx.gbl...
> Marco
> > - In the meanwhile it appears that DB log begins growing: the things are
> > not
> > directly dependent, just somewhat later the log begins growing, but no
> > error
> > is found in SQL errorlog.
> > - In which way may the two things (overflow and log grow) be related?
>
> It does not matter whether or not overflow occured. the log file grows up
> and it is not truncated unless you have SIMPLE recovery mode the database
> set
>
> > - What really happens on SQL server when data overflow occurs? How does
it
> > handle?
>
> create table t (c1 tinyint, c2 varchar (5))
> --owerflow on c1 column
> insert into t values(4545745454545,'a')
> --Server: Msg 8115, Level 16, State 2, Line 1
> --Arithmetic overflow error converting expression to data type tinyint.
> --The statement has been terminated.
> select * from t
> --(0 row(s) affected)
> --now insert much more characters than you defined for c2 columnn
> insert into t values(1,'asgtbvtybvtg')
> --Server: Msg 8152, Level 16, State 9, Line 1
> --String or binary data would be truncated.
> --The statement has been terminated.
> select * from t
> --(0 row(s) affected)
>
The fact is: when the application attempts writing more data, data is REALLY
WRITTEN (even if truncated), and NO ERROR is thrown.
- Why did not get error?
- May the overflow be a reason why the log is growing?
Field overflow and Log grow
I am using SQL Server 2000.
One user database contains a table as following:
CREATE TABLE Events..Audit_Sub (
[RecID] [bigint] NOT NULL ,
[Name] [varchar] (100) NULL ,
[Value] [varchar] (1024) NULL
) ON [PRIMARY]
Sometimes the application writes to the table a record that overflows the
size of the Value field (actually because of an error in the new code, the
appilcation attempts to write about 5Kb to the Valaue field).
The fact is:
- No error is detected on SQL Server, data is written to tha table, it is
visible by select, it is just truncated to the field size (1Kb).
- In the meanwhile it appears that DB log begins growing: the things are not
directly dependent, just somewhat later the log begins growing, but no error
is found in SQL errorlog.
- Later on transaction log cannot be backup up, data are no more written to
DB, but then it is too late to understand the reason why.
The question is:
- In which way may the two things (overflow and log grow) be related?
- What really happens on SQL server when data overflow occurs? How does it
handle?
Thanks in advance,
MRMarco
> - In the meanwhile it appears that DB log begins growing: the things are
> not
> directly dependent, just somewhat later the log begins growing, but no
> error
> is found in SQL errorlog.
> - In which way may the two things (overflow and log grow) be related?
It does not matter whether or not overflow occured. the log file grows up
and it is not truncated unless you have SIMPLE recovery mode the database
set
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
create table t (c1 tinyint, c2 varchar (5))
--owerflow on c1 column
insert into t values(4545745454545,'a')
--Server: Msg 8115, Level 16, State 2, Line 1
--Arithmetic overflow error converting expression to data type tinyint.
--The statement has been terminated.
select * from t
--(0 row(s) affected)
--now insert much more characters than you defined for c2 columnn
insert into t values(1,'asgtbvtybvtg')
--Server: Msg 8152, Level 16, State 9, Line 1
--String or binary data would be truncated.
--The statement has been terminated.
select * from t
--(0 row(s) affected)
"Marco Roda" <mrtest@.amdosoft.com> wrote in message
news:e8t656$le6$1@.ss408.t-com.hr...
> Hi,
> I am using SQL Server 2000.
> One user database contains a table as following:
> CREATE TABLE Events..Audit_Sub (
> [RecID] [bigint] NOT NULL ,
> [Name] [varchar] (100) NULL ,
> [Value] [varchar] (1024) NULL
> ) ON [PRIMARY]
> Sometimes the application writes to the table a record that overflows the
> size of the Value field (actually because of an error in the new code, the
> appilcation attempts to write about 5Kb to the Valaue field).
> The fact is:
> - No error is detected on SQL Server, data is written to tha table, it is
> visible by select, it is just truncated to the field size (1Kb).
> - In the meanwhile it appears that DB log begins growing: the things are
> not
> directly dependent, just somewhat later the log begins growing, but no
> error
> is found in SQL errorlog.
> - Later on transaction log cannot be backup up, data are no more written
> to
> DB, but then it is too late to understand the reason why.
> The question is:
> - In which way may the two things (overflow and log grow) be related?
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
> Thanks in advance,
> MR
>
>
>|||Hi
At a guess you have the ANSI_WARNINGS setting off as "When OFF, data is
truncated to the size of the column and the statement succeeds. " e.g
SET ANSI_WARNINGS ON
DECLARE @.error int
CREATE TABLE #tmp ( col1 char(1) NOT NULL )
BEGIN TRANSACTION
INSERT INTO #tmp ( col1 ) values ( 'AA' )
SET @.error = @.@.ERROR
IF @.error <> 0
BEGIN
SELECT 'Transaction Rolled Back Error Status: ' + CAST(@.error as varchar(30)
)
ROLLBACK TRANSACTIOn
END
ELSE
BEGIN
PRINT 'Transaction Comitted'
COMMIT TRANSACTION
END
GO
SELECT * from #tmp
GO
DROP TABLE #tmp
GO
/*
Msg 8152, Level 16, State 14, Line 5
String or binary data would be truncated.
The statement has been terminated.
----
Transaction Rolled Back Error Status: 8152
(1 row(s) affected)
col1
--
(0 row(s) affected)
*/
SET ANSI_WARNINGS OFF
DECLARE @.error int
CREATE TABLE #tmp ( col1 char(1) NOT NULL )
BEGIN TRANSACTION
INSERT INTO #tmp ( col1 ) values ( 'AA' )
SET @.error = @.@.ERROR
IF @.error <> 0
BEGIN
SELECT 'Transaction Rolled Back Error Status: ' + CAST(@.error as varchar(30)
)
ROLLBACK TRANSACTIOn
END
ELSE
BEGIN
PRINT 'Transaction Comitted'
COMMIT TRANSACTION
END
GO
SELECT * from #tmp
GO
DROP TABLE #tmp
GO
/*
(1 row(s) affected)
Transaction Comitted
col1
--
A
(1 row(s) affected)
*/
although with your log file growing it may be that you have detected an
error and not rolled back the transaction, use DBCC OPENTRAN to view open
transactions.
John
"Marco Roda" wrote:
> Hi,
> I am using SQL Server 2000.
> One user database contains a table as following:
> CREATE TABLE Events..Audit_Sub (
> [RecID] [bigint] NOT NULL ,
> [Name] [varchar] (100) NULL ,
> [Value] [varchar] (1024) NULL
> ) ON [PRIMARY]
> Sometimes the application writes to the table a record that overflows the
> size of the Value field (actually because of an error in the new code, the
> appilcation attempts to write about 5Kb to the Valaue field).
> The fact is:
> - No error is detected on SQL Server, data is written to tha table, it is
> visible by select, it is just truncated to the field size (1Kb).
> - In the meanwhile it appears that DB log begins growing: the things are n
ot
> directly dependent, just somewhat later the log begins growing, but no err
or
> is found in SQL errorlog.
> - Later on transaction log cannot be backup up, data are no more written t
o
> DB, but then it is too late to understand the reason why.
> The question is:
> - In which way may the two things (overflow and log grow) be related?
> - What really happens on SQL server when data overflow occurs? How does it
> handle?
> Thanks in advance,
> MR
>
>
>|||"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:uozopRApGHA.4996@.TK2MSFTNGP05.phx.gbl...
> Marco
>
>
> It does not matter whether or not overflow occured. the log file grows up
> and it is not truncated unless you have SIMPLE recovery mode the database
> set
>
it[vbcol=seagreen]
>
> create table t (c1 tinyint, c2 varchar (5))
> --owerflow on c1 column
> insert into t values(4545745454545,'a')
> --Server: Msg 8115, Level 16, State 2, Line 1
> --Arithmetic overflow error converting expression to data type tinyint.
> --The statement has been terminated.
> select * from t
> --(0 row(s) affected)
> --now insert much more characters than you defined for c2 columnn
> insert into t values(1,'asgtbvtybvtg')
> --Server: Msg 8152, Level 16, State 9, Line 1
> --String or binary data would be truncated.
> --The statement has been terminated.
> select * from t
> --(0 row(s) affected)
>
The fact is: when the application attempts writing more data, data is REALLY
WRITTEN (even if truncated), and NO ERROR is thrown.
- Why did not get error?
- May the overflow be a reason why the log is growing?
Friday, March 23, 2012
Feedback on Microsoft Connect Site
I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage? Almost everyone? (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.
Links to a couple new submissions that look interesting:
1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks
2. ForEach SMO Enumerator Filtering
I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high fives!
Hi M.Glenn,
Those are important - thanks for pointing them out.
:{> Andy
|||Andy, thanks for the encouragement and votes. I wonder if it's common to enter a vote for your own suggestion? I'm inclined against it, but if everyone is legitimately entitled it might be helpful...
|||I generally don't. But that's just because I forget
Jamie, If that's the only reason in your opinion that's good enough for me. I'm heading for the voting booth!
(Actually, now that I've given it a little more thought it makes sense since voting is the only way to tell Microsoft how important you think the suggestion or bug is.)
|||M.Glenn wrote:
Jamie, If that's the only reason in your opinion that's good enough for me. I'm heading for the voting booth!
(Actually, now that I've given it a little more thought it makes sense since voting is the only way to tell Microsoft how important you think the suggestion or bug is.)
I would tend to think that of the majority of bug submissions that the author deems it a high priority! ;)
Never-the-less, the voting system doesn't hold a whole lot of merit to it unless the voter gives his/her feedback to back up that vote. Microsoft has listened to plenty of my submissions without even having a single vote on them. And sometimes there are those with a large number of high votes that get closed (not fixed) because of one reason or another. So it all depends, in other words.
The moral is to be sure to leave appropriate feedback when voting so that you can leave your comments which may help clarify to Microsoft what exactly the bug is and how it impacts others.
|||Phil Brammer wrote:
Microsoft has listened to plenty of my submissions without even having a single vote on them. And sometimes there are those with a large number of high votes that get closed (not fixed) because of one reason or another. So it all depends, in other words.
The moral is to be sure to leave appropriate feedback when voting so that you can leave your comments which may help clarify to Microsoft what exactly the bug is and how it impacts others.
Good information. If that's the case, votes are not as critical as the site design seems to imply. The vote tally would probably be a bigger factor if the ratio of feedback submissions to Microsoft resources was high enough to overwhelm those resources. It sounds like they're able to review pretty much everything--another sign that SSIS is a high-priority product at Microsoft.
|||I'm a firm believer that leaving a comment is much more valuable than a vote. If I were reviewing them then I would just ignore the votes cos of course most people are gonna vote high. I would want to know WHY this is important to you, how much grief has been caused without it? How could the product best be improved?
Qualititive feedback is much better than quantitive.
-Jamie
|||I basically agree with what you guys are saying, but partly because Microsoft seems to be reviewing all submissions regardless of vote count. I would add that the vote itself is providing important qualitative information--showing at-a-glance how important the issue is for reviewers/commentators.
As for the original submitter, I could easily imagine voting a 3 or 4 on my own submission if it was cosmetic or less critical to me than other things I had in the queue. Human nature being what it is though, you guys are probably right about the temptation to give one's own submission a 5 in every case.
Feedback on Microsoft Connect Site
I don't know how many folks here log into the Microsoft Connect site occasionally to check suggestions and bugs submitted to Microsoft for SQL Server and SSIS (still called DTS on their list). A small pecentage? Almost everyone? (Possibly in this group.) Anyone can vote for feedback they think is important. Theoretically issues with the most votes will get Microsoft's attention first.
Links to a couple new submissions that look interesting:
1. SSMS/QA Style Message Logging for SSIS Execute SQL Tasks
2. ForEach SMO Enumerator Filtering
I vetted these issues in the forum first, so hopefully they're legitimate enough to warrant some useful feedback or even a few high fives!
Hi M.Glenn,
Those are important - thanks for pointing them out.
:{> Andy
|||Andy, thanks for the encouragement and votes. I wonder if it's common to enter a vote for your own suggestion? I'm inclined against it, but if everyone is legitimately entitled it might be helpful...
|||I generally don't. But that's just because I forget
|||
Jamie, If that's the only reason in your opinion that's good enough for me. I'm heading for the voting booth!
(Actually, now that I've given it a little more thought it makes sense since voting is the only way to tell Microsoft how important you think the suggestion or bug is.)
|||M.Glenn wrote:
Jamie, If that's the only reason in your opinion that's good enough for me. I'm heading for the voting booth!
(Actually, now that I've given it a little more thought it makes sense since voting is the only way to tell Microsoft how important you think the suggestion or bug is.)
I would tend to think that of the majority of bug submissions that the author deems it a high priority! ;)
Never-the-less, the voting system doesn't hold a whole lot of merit to it unless the voter gives his/her feedback to back up that vote. Microsoft has listened to plenty of my submissions without even having a single vote on them. And sometimes there are those with a large number of high votes that get closed (not fixed) because of one reason or another. So it all depends, in other words.
The moral is to be sure to leave appropriate feedback when voting so that you can leave your comments which may help clarify to Microsoft what exactly the bug is and how it impacts others.
|||Phil Brammer wrote:
Microsoft has listened to plenty of my submissions without even having a single vote on them. And sometimes there are those with a large number of high votes that get closed (not fixed) because of one reason or another. So it all depends, in other words.
The moral is to be sure to leave appropriate feedback when voting so that you can leave your comments which may help clarify to Microsoft what exactly the bug is and how it impacts others.
Good information. If that's the case, votes are not as critical as the site design seems to imply. The vote tally would probably be a bigger factor if the ratio of feedback submissions to Microsoft resources was high enough to overwhelm those resources. It sounds like they're able to review pretty much everything--another sign that SSIS is a high-priority product at Microsoft.
|||
I'm a firm believer that leaving a comment is much more valuable than a vote. If I were reviewing them then I would just ignore the votes cos of course most people are gonna vote high. I would want to know WHY this is important to you, how much grief has been caused without it? How could the product best be improved?
Qualititive feedback is much better than quantitive.
-Jamie
|||
I basically agree with what you guys are saying, but partly because Microsoft seems to be reviewing all submissions regardless of vote count. I would add that the vote itself is providing important qualitative information--showing at-a-glance how important the issue is for reviewers/commentators.
As for the original submitter, I could easily imagine voting a 3 or 4 on my own submission if it was cosmetic or less critical to me than other things I had in the queue. Human nature being what it is though, you guys are probably right about the temptation to give one's own submission a 5 in every case.
Wednesday, March 21, 2012
FC or ATA for LOG FILES?
from the data. The data will be on FC storage. Will the log files perform
optimally on FC or ATA?
Thanks in advance.
SBGFC as in FC-ATA where you're basically using cheap hardware?
I question your decision to put data and log files on such equipment in the
first place. However, as to the log files themselves, I suspect you could
put log files on an MFM drive, or an old 20MB removable platter and be fine
99.99% of the time. There just isn't that much I/O to the logs.
"SBG" <sbg@.thomasville.org> wrote in message
news:O1j$TY%23HIHA.4196@.TK2MSFTNGP04.phx.gbl...
> I'm setting up a new DB and separating the log files to storage separate
> from the data. The data will be on FC storage. Will the log files
> perform
> optimally on FC or ATA?
> Thanks in advance.
> SBG
>|||Oh, and .01% of the time is about 1 hour a year.
"Jay" <nospan@.nospam.org> wrote in message
news:eA$a3i%23HIHA.5544@.TK2MSFTNGP02.phx.gbl...
> FC as in FC-ATA where you're basically using cheap hardware?
> I question your decision to put data and log files on such equipment in
> the first place. However, as to the log files themselves, I suspect you
> could put log files on an MFM drive, or an old 20MB removable platter and
> be fine 99.99% of the time. There just isn't that much I/O to the logs.
> "SBG" <sbg@.thomasville.org> wrote in message
> news:O1j$TY%23HIHA.4196@.TK2MSFTNGP04.phx.gbl...
>> I'm setting up a new DB and separating the log files to storage separate
>> from the data. The data will be on FC storage. Will the log files
>> perform
>> optimally on FC or ATA?
>> Thanks in advance.
>> SBG
>>
>
Monday, March 19, 2012
fatal error, Any help is much appreciated!
Now I face some problems, I don't know what cause
this fatal error. I paste the log into this mail. I hope
to get help!
Any help is much appreciated!
Here are message I do not know.
When MSSQL 7 starts, a lot of messages are printed
that I do not know how deal with.
The messages format is just as following:
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
After SQLServer run about 20 hours, SQLSerer print
following messages, than the SQLServer can't work.,than I
should restart the SQLServer service to make it work
again. This situation is occurs every day. I have put the
SP4 for SQLServer 7, the problem still exists.
Here are message printed before the SQLServer aborted.:
2003-10-17 13:22:04.80 spid9 Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:18.60 spid9
SqlDumpExceptionHandler: Process 9 generated fatal
exception c0000005 EXCEPT
2003-10-17 13:22:18.60 spid9 Error: 0, Severity: 19,
State: 0
2003-10-17 13:22:19.67 spid9 Error occured during
cursor cleanup.
2003-10-17 13:22:19.67 spid9 Error occured during
cursor close.
2003-10-17 13:22:19.68 spid9 Error occured during
cursor close.
2003-10-17 13:22:19.71 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:33.53 kernel SQL Server Assertion:
File: <proc.c>, line=1931 ...
2003-10-17 13:22:33.56 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:45.75 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:22:47.12 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:59.31 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:00.68 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:23:12.87 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:14.24 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:23:26.43 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:27.77 server SQL Server is aborting.
Fatal exception c000001d caught.
Here is the full log:
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c4af4 Module(sqlservr+c4af4)
(GlobalTskMgrProc+14a)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cfb36 Module(sqlservr+cfb36)
(ckptproc+f1)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c9cec Module(sqlservr+c9cec)
(LogMgr::LogWriter+8a)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x410917b5 Module(ums+17b5)
(UmsScheduler::Suspend+e3)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cad4b Module(sqlservr+cad4b)
(lazywriter+f5)
0 x004caddb Module(sqlservr+caddb)
(BPool::LazyWriter+dd)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c6751 Module(sqlservr+c6751)
(lockMonitorThread+a7)
0 x004c6890 Module(sqlservr+c6890)
(lockMonitor+e8)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c5148 Module(sqlservr+c5148)
(init_routine+49f)
0 x004c4bee Module(sqlservr+c4bee)
(SignalProc+be)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x4106142f Module(opends60+142f)
(process_commands+107)
0 x4106127c Module(opends60+127c)
(execute_event+21a)
0 x4106256e Module(opends60+256e)
(execute_rpc+421)
0 x0053e114 Module(sqlservr+13e114)
(execrpc+78d)
0 x004fa593 Module(sqlservr+fa593)
(kill_proc+505)
0 x004f9d06 Module(sqlservr+f9d06)
(freepss+132)
0 x004f9f05 Module(sqlservr+f9f05)
(destroyPssMemory+19)
0 x004fa019 Module(sqlservr+fa019)
(PSS::~PSS+111)
0 x005bc329 Module(sqlservr+1bc329)
(ExecutionContext::Cleanup+9e)
0 x0078c4a6 Module(sqlservr+38c4a6)
(utassert_fail+390)
0 x7c4ea4e1 Module(KERNEL32+a4e1)
(RaiseException+55)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c4af4 Module(sqlservr+c4af4)
(GlobalTskMgrProc+14a)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cfb36 Module(sqlservr+cfb36)
(ckptproc+f1)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c9cec Module(sqlservr+c9cec)
(LogMgr::LogWriter+8a)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x410917b5 Module(ums+17b5)
(UmsScheduler::Suspend+e3)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cad4b Module(sqlservr+cad4b)
(lazywriter+f5)
0 x004caddb Module(sqlservr+caddb)
(BPool::LazyWriter+dd)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c6751 Module(sqlservr+c6751)
(lockMonitorThread+a7)
0 x004c6890 Module(sqlservr+c6890)
(lockMonitor+e8)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c5148 Module(sqlservr+c5148)
(init_routine+49f)
0 x004c4bee Module(sqlservr+c4bee)
(SignalProc+be)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x4106142f Module(opends60+142f)
(process_commands+107)
0 x4106127c Module(opends60+127c)
(execute_event+21a)
0 x4106256e Module(opends60+256e)
(execute_rpc+421)
0 x0053e114 Module(sqlservr+13e114)
(execrpc+78d)
0 x004fa593 Module(sqlservr+fa593)
(kill_proc+505)
0 x004f9d06 Module(sqlservr+f9d06)
(freepss+132)
0 x004f9f05 Module(sqlservr+f9f05)
(destroyPssMemory+19)
0 x004fa019 Module(sqlservr+fa019)
(PSS::~PSS+111)
0 x005bc329 Module(sqlservr+1bc329)
(ExecutionContext::Cleanup+9e)
0 x0078c4a6 Module(sqlservr+38c4a6)
(utassert_fail+390)
0 x7c4ea4e1 Module(KERNEL32+a4e1)
(RaiseException+55)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c4af4 Module(sqlservr+c4af4)
(GlobalTskMgrProc+14a)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cfb36 Module(sqlservr+cfb36)
(ckptproc+f1)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c9cec Module(sqlservr+c9cec)
(LogMgr::LogWriter+8a)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x410917b5 Module(ums+17b5)
(UmsScheduler::Suspend+e3)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cad4b Module(sqlservr+cad4b)
(lazywriter+f5)
0 x004caddb Module(sqlservr+caddb)
(BPool::LazyWriter+dd)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c6751 Module(sqlservr+c6751)
(lockMonitorThread+a7)
0 x004c6890 Module(sqlservr+c6890)
(lockMonitor+e8)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c5148 Module(sqlservr+c5148)
(init_routine+49f)
0 x004c4bee Module(sqlservr+c4bee)
(SignalProc+be)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x4106142f Module(opends60+142f)
(process_commands+107)
0 x4106127c Module(opends60+127c)
(execute_event+21a)
0 x4106256e Module(opends60+256e)
(execute_rpc+421)
0 x0053e114 Module(sqlservr+13e114)
(execrpc+78d)
0 x004fa593 Module(sqlservr+fa593)
(kill_proc+505)
0 x004f9d06 Module(sqlservr+f9d06)
(freepss+132)
0 x004f9f05 Module(sqlservr+f9f05)
(destroyPssMemory+19)
0 x004fa019 Module(sqlservr+fa019)
(PSS::~PSS+111)
0 x005bc329 Module(sqlservr+1bc329)
(ExecutionContext::Cleanup+9e)
0 x0078c44a Module(sqlservr+38c44a)
(utassert_fail+1a0)
0 x006fd620 Module(sqlservr+2fd620)
(stackTrace+255)
0 x006fd663 Module(sqlservr+2fd663)
(stackTraceException+53)
0 x7c4ea4e1 Module(KERNEL32+a4e1)
(RaiseException+55)
0 x230ade8c Module(UNKNOWN+0)
0 x0041d94b Module(sqlservr+1d94b)
(CEs::DestroyPesx+19)
0 x0041d98b Module(sqlservr+1d98b)
(CEsExec::~CEsExec+ac)
0 x0041da04 Module(sqlservr+1da04)
(CEsCompValSeg::DestroyExecValSeg+29)
0 x004382f1 Module(sqlservr+382f1)
(CValExchange<35>::Deref+b)
0 x00438310 Module(sqlservr+38310)
(CValConstXVar::`scalar deleting destructor'+17)
0 x0040bd67 Module(sqlservr+bd67) (operator
delete+15)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c4af4 Module(sqlservr+c4af4)
(GlobalTskMgrProc+14a)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cfb36 Module(sqlservr+cfb36)
(ckptproc+f1)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c9cec Module(sqlservr+c9cec)
(LogMgr::LogWriter+8a)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x410917b5 Module(ums+17b5)
(UmsScheduler::Suspend+e3)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cad4b Module(sqlservr+cad4b)
(lazywriter+f5)
0 x004caddb Module(sqlservr+caddb)
(BPool::LazyWriter+dd)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c6751 Module(sqlservr+c6751)
(lockMonitorThread+a7)
0 x004c6890 Module(sqlservr+c6890)
(lockMonitor+e8)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c5148 Module(sqlservr+c5148)
(init_routine+49f)
0 x004c4bee Module(sqlservr+c4bee)
(SignalProc+be)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x4106142f Module(opends60+142f)
(process_commands+107)
0 x4106127c Module(opends60+127c)
(execute_event+21a)
0 x4106256e Module(opends60+256e)
(execute_rpc+421)
0 x0053e114 Module(sqlservr+13e114)
(execrpc+78d)
0 x004fa593 Module(sqlservr+fa593)
(kill_proc+505)
0 x004f9d06 Module(sqlservr+f9d06)
(freepss+132)
0 x004f9f05 Module(sqlservr+f9f05)
(destroyPssMemory+19)
0 x004fa019 Module(sqlservr+fa019)
(PSS::~PSS+111)
0 x005bc329 Module(sqlservr+1bc329)
(ExecutionContext::Cleanup+9e)
0 x0078c4a6 Module(sqlservr+38c4a6)
(utassert_fail+390)
0 x7c4ea4e1 Module(KERNEL32+a4e1)
(RaiseException+55)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c4af4 Module(sqlservr+c4af4)
(GlobalTskMgrProc+14a)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cfb36 Module(sqlservr+cfb36)
(ckptproc+f1)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c9cec Module(sqlservr+c9cec)
(LogMgr::LogWriter+8a)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x410917b5 Module(ums+17b5)
(UmsScheduler::Suspend+e3)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004cad4b Module(sqlservr+cad4b)
(lazywriter+f5)
0 x004caddb Module(sqlservr+caddb)
(BPool::LazyWriter+dd)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c6751 Module(sqlservr+c6751)
(lockMonitorThread+a7)
0 x004c6890 Module(sqlservr+c6890)
(lockMonitor+e8)
0 x00401650 Module(sqlservr+1650)
(ResQueueBase::Dequeue+6d)
0 x0040175d Module(sqlservr+175d)
(ResQueueBase::Wait+36)
0 x00401479 Module(sqlservr+1479)
(ExecutionContext::WaitForSignal+192)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)...
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x004c5148 Module(sqlservr+c5148)
(init_routine+49f)
0 x004c4bee Module(sqlservr+c4bee)
(SignalProc+be)
0 x4109169a Module(ums+169a)
(UmsEvent::Wait+95)
0 x41091828 Module(ums+1828)
(UmsScheduler::Suspend+b2)
0 x41092e2f Module(ums+2e2f)
(UmsThreadScheduler::Switch+59)
0 x77f94091 Module(ntdll+14091)
(ZwWaitForSingleObject+b)
0 x7c4e987c Module(KERNEL32+987c)
(SetThreadExecutionState+227)
0 x78008454 Module(MSVCRT+8454) (endthread+c1)
0 x41093523 Module(ums+3523)
(ThreadStartRoutine+139)
0 x41092cff Module(ums+2cff)
(ProcessWorkRequests+102)
0 x4106142f Module(opends60+142f)
(process_commands+107)
0 x4106127c Module(opends60+127c)
(execute_event+21a)
0 x4106256e Module(opends60+256e)
(execute_rpc+421)
0 x0053e114 Module(sqlservr+13e114)
(execrpc+78d)
0 x004fa593 Module(sqlservr+fa593)
(kill_proc+505)
0 x004f9d06 Module(sqlservr+f9d06)
(freepss+132)
0 x004f9f05 Module(sqlservr+f9f05)
(destroyPssMemory+19)
0 x004fa019 Module(sqlservr+fa019)
(PSS::~PSS+111)
0 x005bc329 Module(sqlservr+1bc329)
(ExecutionContext::Cleanup+9e)
0 x0078c4a6 Module(sqlservr+38c4a6)
(utassert_fail+390)
0 x7c4ea4e1 Module(KERNEL32+a4e1)
(RaiseException+55)
2003-10-16 15:58:48.81 kernel Microsoft SQL Server
7.00 - 7.00.1063 (Intel X86) ...
2003-10-16 15:58:48.83 kernel Logging SQL Server
messages in file 'C:\MSSQL7\log\ERRORLOG'.
2003-10-16 15:58:48.83 kernel All rights reserved.
2003-10-16 15:58:48.83 kernel Copyright (C) 1988-1997
Microsoft Corporation.
2003-10-16 15:58:48.91 kernel SQL Server is starting
at priority class 'high'(1 CPU detected).
2003-10-16 15:58:48.91 kernel initconfig: Number of
user connections limited to 32767.
2003-10-16 15:58:49.22 kernel User Mode Scheduler
configured for thread processing
2003-10-16 15:58:50.63 kernel initdata: Warning: Could
not set working set size to 1558592 KB.
2003-10-16 15:58:50.65 server Directory Size: 64939
2003-10-16 15:58:50.69 kernel Attempting to initialize
Distributed Transaction Coordinator.
2003-10-16 15:58:50.69 spid1 Using dynamic lock
allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
2003-10-16 15:58:50.98 spid1 Failed to obtain
TransactionDispenserInterface: Result Code = 0x8004d01b
2003-10-16 15:58:51.00 spid1 Opening file C:\MSSQL7
\data\master.mdf.
2003-10-16 15:58:51.00 spid1 Starting up
database 'master'.
2003-10-16 15:58:51.03 spid1 Opening file C:\MSSQL7
\data\mastlog.ldf.
2003-10-16 15:58:51.10 spid1 Loading SQL Server's
Unicode collation.
2003-10-16 15:58:51.12 spid1 Loading SQL Server's
non-Unicode sort order and character set.
2003-10-16 15:58:51.17 spid1 3 transactions rolled
forward in database 'master' (1).
2003-10-16 15:58:51.18 spid1 0 transactions rolled
back in database 'master' (1).
2003-10-16 15:58:51.20 spid1 Opening file C:\MSSQL7
\DATA\model.mdf.
2003-10-16 15:58:51.20 spid1 Starting up
database 'model'.
2003-10-16 15:58:51.21 spid1 Opening file c:\mssql7
\data\modellog.ldf.
2003-10-16 15:58:51.29 spid1 Clearing tempdb
database.
2003-10-16 15:58:51.31 spid1 Creating file C:\MSSQL7
\DATA\TEMPDB.MDF.
2003-10-16 15:58:51.45 spid1 Closing file C:\MSSQL7
\DATA\TEMPDB.MDF.
2003-10-16 15:58:51.49 spid1 Creating file C:\MSSQL7
\DATA\TEMPLOG.LDF.
2003-10-16 15:58:51.51 spid1 Closing file C:\MSSQL7
\DATA\TEMPLOG.LDF.
2003-10-16 15:58:51.53 spid1 Opening file C:\MSSQL7
\DATA\TEMPDB.MDF.
2003-10-16 15:58:51.55 spid1 Opening file C:\MSSQL7
\DATA\TEMPLOG.LDF.
2003-10-16 15:58:51.85 spid1 Closing file C:\MSSQL7
\DATA\TEMPDB.MDF.
2003-10-16 15:58:51.97 spid1 Closing file C:\MSSQL7
\DATA\TEMPLOG.LDF.
2003-10-16 15:58:52.02 spid1 Starting up
database 'tempdb'.
2003-10-16 15:58:52.07 spid1 Opening file C:\MSSQL7
\DATA\TEMPDB.MDF.
2003-10-16 15:58:52.10 spid1 Opening file C:\MSSQL7
\DATA\TEMPLOG.LDF.
2003-10-16 15:58:52.26 kernel Using 'OPENDS60.DLL'
version '7.00.00.1063'.
2003-10-16 15:58:52.26 kernel Using 'SQLEVN70.DLL'
version '7.00.1063'.
2003-10-16 15:58:52.26 spid1 Server name
is 'ACCOUNTINGSRVR'.
2003-10-16 15:58:52.29 ods Using 'SSNMPN70.DLL'
version '7.0.694' to listen on '\\.\pipe\sql\query'.
2003-10-16 15:58:52.30 ods Using 'SSMSRP70.DLL'
version '7.0.961' to listen on 'ACCOUNTINGSRVR'.
2003-10-16 15:58:52.30 ods Using 'SSMSSO70.DLL'
version '7.0.1063' to listen on '1433'.
2003-10-16 15:58:52.31 spid8 Opening file C:\MSSQL7
\DATA\DATA_DATA.MDF.
2003-10-16 15:58:52.31 spid8 Starting up
database 'DATA'.
2003-10-16 15:58:52.31 spid7 Opening file C:\MSSQL7
\DATA\pubs.mdf.
2003-10-16 15:58:52.31 spid7 Starting up
database 'pubs'.
2003-10-16 15:58:52.31 spid6 Opening file C:\MSSQL7
\DATA\msdbdata.mdf.
2003-10-16 15:58:52.31 spid6 Starting up
database 'msdb'.
2003-10-16 15:58:52.36 spid9 Opening file C:\MSSQL7
\DATA\DATA_09_DATA.MDF.
2003-10-16 15:58:52.36 spid9 Starting up
database 'DATA_09'.
2003-10-16 15:58:52.49 spid7 Opening file c:\mssql7
\DATA\pubs_log.ldf.
2003-10-16 15:58:52.50 spid6 Opening file c:\mssql7
\DATA\msdblog.ldf.
2003-10-16 15:58:52.54 spid9 Opening file C:\MSSQL7
\DATA\DATA_09_LOG.LDF.
2003-10-16 15:58:52.56 spid8 Opening file C:\MSSQL7
\DATA\DATA_LOG.LDF.
2003-10-16 15:58:52.70 spid7 Opening file C:\MSSQL7
\DATA\Screens_DATA.MDF.
2003-10-16 15:58:52.70 spid7 Starting up
database 'Screens'.
2003-10-16 15:58:52.87 spid7 Opening file C:\MSSQL7
\DATA\Screens_LOG.LDF.
2003-10-16 15:58:53.10 spid6 Starting up
database 'msllockdb'.
2003-10-16 15:58:53.11 spid6 Opening file C:\MSSQL7
\DATA\msllockdb_DATA.MDF.
2003-10-16 15:58:53.14 spid7 Opening file c:\mssql7
\DATA\GenericScreens_data.mdf.
2003-10-16 15:58:53.14 spid7 Starting up
database 'GenericScreens'.
2003-10-16 15:58:53.19 spid6 Opening file C:\MSSQL7
\DATA\msllockdb_LOG.LDF.
2003-10-16 15:58:53.21 spid7 Opening file c:\mssql7
\DATA\GenericScreens_log.ldf.
2003-10-16 15:58:53.24 spid8 Opening file C:\MSSQL7
\DATA\PWE_DATA.MDF.
2003-10-16 15:58:53.24 spid8 Starting up
database 'PWE'.
2003-10-16 15:58:53.33 spid8 Opening file C:\MSSQL7
\DATA\PWE_LOG.LDF.
2003-10-16 15:58:53.57 kernel udopen: Operating system
error 2(The system cannot find the file specified.)
2003-10-16 15:58:53.57 spid8 Opening file C:\MSSQL7
\data\test_Data.MDF.
2003-10-16 15:58:53.57 spid8 Starting up
database 'test'.
2003-10-16 15:58:53.58 kernel FCB::Open failed: Could
not open device C:\MSSQL7\data\test_Data.MDF for virt
2003-10-16 15:58:53.60 spid8 Device activation
error. The physical file name 'C:\MSSQL7\data\test_Data.MD
2003-10-16 15:58:53.64 kernel FCB::Open failed: Could
not open device C:\MSSQL7\data\test2_Data.MDF for vir
2003-10-16 15:58:53.64 kernel udopen: Operating system
error 2(The system cannot find the file specified.)
2003-10-16 15:58:53.64 spid8 Opening file C:\MSSQL7
\data\test2_Data.MDF.
2003-10-16 15:58:53.64 spid8 Starting up
database 'test2'.
2003-10-16 15:58:53.66 spid8 Opening file C:\MSSQL7
\DATA\DATA_10_DATA.MDF.
2003-10-16 15:58:53.66 spid8 Starting up
database 'DATA_10'.
2003-10-16 15:58:53.66 spid8 Device activation
error. The physical file name 'C:\MSSQL7\data\test2_Data.M
2003-10-16 15:58:53.74 spid8 Opening file C:\MSSQL7
\DATA\DATA_10_LOG.LDF.
2003-10-16 15:58:53.89 spid8 Opening file C:\MSSQL7
\DATA\DATA_11_DATA.MDF.
2003-10-16 15:58:53.89 spid8 Starting up
database 'DATA_11'.
2003-10-16 15:58:53.94 spid8 Opening file C:\MSSQL7
\DATA\DATA_11_LOG.LDF.
2003-10-16 15:58:55.10 spid6 Opening file C:\MSSQL7
\data\distribution.MDF.
2003-10-16 15:58:55.10 spid6 Starting up
database 'distribution'.
2003-10-16 15:58:55.21 spid6 Opening file C:\MSSQL7
\data\distribution.LDF.
2003-10-16 15:58:55.22 spid7 Opening file C:\MSSQL7
\data\mmtempmerge_Data.MDF.
2003-10-16 15:58:55.22 spid7 Starting up
database 'mmtempmerge'.
2003-10-16 15:58:55.30 spid7 Opening file C:\MSSQL7
\data\mmtempmerge_Log.LDF.
2003-10-16 15:58:55.53 spid7 Opening file C:\MSSQL7
\data\TempMergeTables_Data.MDF.
2003-10-16 15:58:55.53 spid7 Starting up
database 'TempMergeTables'.
2003-10-16 15:58:55.60 spid7 Opening file C:\MSSQL7
\data\TempMergeTables_Log.LDF.
2003-10-16 15:58:57.33 spid1 Recovery complete.
2003-10-16 15:58:57.34 spid1 'iso_1' (ID = 1).
2003-10-16 15:58:57.34 spid1 SQL Server's non-
Unicode character set is:
2003-10-16 15:58:57.34 spid1 'nocase_iso'
(ID = 52).
2003-10-16 15:58:57.34 spid1 SQL Server's non-
Unicode sort order is:
2003-10-16 15:58:57.34 spid1 comparison
style = 196609.
2003-10-16 15:58:57.34 spid1 'English' (ID = 1033).
2003-10-16 15:58:57.34 spid1 SQL Server's Unicode
collation is:
2003-10-16 15:58:57.74 spid1 Launched startup
procedure 'sp_MSrepl_startup'
2003-10-16 15:59:00.89 spid8 Using 'xpsqlbot.dll'
version '1998.11.13' to execute extended stored procedu
2003-10-16 16:00:00.91 spid9 Using 'xpstar.dll'
version '2000.28.09' to execute extended stored procedure
2003-10-16 16:01:01.84 spid10 Using 'xpsql70.dll'
version '2000.28.09' to execute extended stored procedure
2003-10-16 22:25:12.40 kernel
BackupMedium::ReportIoError: write failure on backup
device 'E:\MSSQL7\bak\DA
2003-10-16 22:25:13.46 backup Database backed up with
following information: Database: distribution, creati
2003-10-16 22:25:21.20 backup Database backed up with
following information: Database: GenericScreens, crea
2003-10-16 22:25:25.25 backup Database backed up with
following information: Database: master, creation dat
2003-10-16 22:25:26.09 backup Database backed up with
following information: Database: model, creation date
2003-10-16 22:25:28.71 backup Database backed up with
following information: Database: msdb, creation date
2003-10-16 22:25:30.43 backup Database backed up with
following information: Database: msllockdb, creation
2003-10-16 22:25:31.22 backup Database backed up with
following information: Database: pubs, creation date
2003-10-16 22:25:31.77 backup Database backed up with
following information: Database: PWE, creation date a
2003-10-16 22:25:39.25 backup Database backed up with
following information: Database: Screens, creation da
2003-10-16 22:25:48.85 backup Database backed up with
following information: Database: TempMergeTables, cre
2003-10-17 13:22:04.80 spid9 Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:18.60 spid9
SqlDumpExceptionHandler: Process 9 generated fatal
exception c0000005 EXCEPT
2003-10-17 13:22:18.60 spid9 Error: 0, Severity: 19,
State: 0
2003-10-17 13:22:19.67 spid9 Error occured during
cursor cleanup.
2003-10-17 13:22:19.67 spid9 Error occured during
cursor close.
2003-10-17 13:22:19.68 spid9 Error occured during
cursor close.
2003-10-17 13:22:19.71 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:33.53 kernel SQL Server Assertion:
File: <proc.c>, line=1931 ...
2003-10-17 13:22:33.56 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:45.75 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:22:47.12 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:22:59.31 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:00.68 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:23:12.87 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:14.24 server Using 'sqlimage.dll'
version '4.0.5'...
2003-10-17 13:23:26.43 server SqlDumpExceptionHandler:
Process 1692 generated fatal exception c000001d EXCE
2003-10-17 13:23:27.77 server SQL Server is aborting.
Fatal exception c000001d caught.Assuming that you have searched Knowledgebase and are on current service pack, you should open a
case with MS Support for situations like this.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Ping" <chenpingnet@.hotmail.com> wrote in message news:056101c39512$236027c0$a301280a@.phx.gbl...
> Hi
> Now I face some problems, I don't know what cause
> this fatal error. I paste the log into this mail. I hope
> to get help!
> Any help is much appreciated!
> Here are message I do not know.
> When MSSQL 7 starts, a lot of messages are printed
> that I do not know how deal with.
> The messages format is just as following:
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> After SQLServer run about 20 hours, SQLSerer print
> following messages, than the SQLServer can't work.,than I
> should restart the SQLServer service to make it work
> again. This situation is occurs every day. I have put the
> SP4 for SQLServer 7, the problem still exists.
> Here are message printed before the SQLServer aborted.:
> 2003-10-17 13:22:04.80 spid9 Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:18.60 spid9
> SqlDumpExceptionHandler: Process 9 generated fatal
> exception c0000005 EXCEPT
> 2003-10-17 13:22:18.60 spid9 Error: 0, Severity: 19,
> State: 0
> 2003-10-17 13:22:19.67 spid9 Error occured during
> cursor cleanup.
> 2003-10-17 13:22:19.67 spid9 Error occured during
> cursor close.
> 2003-10-17 13:22:19.68 spid9 Error occured during
> cursor close.
> 2003-10-17 13:22:19.71 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:33.53 kernel SQL Server Assertion:
> File: <proc.c>, line=1931 ...
> 2003-10-17 13:22:33.56 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:45.75 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:22:47.12 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:59.31 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:00.68 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:23:12.87 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:14.24 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:23:26.43 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:27.77 server SQL Server is aborting.
> Fatal exception c000001d caught.
>
> Here is the full log:
>
>
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c4af4 Module(sqlservr+c4af4)
> (GlobalTskMgrProc+14a)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cfb36 Module(sqlservr+cfb36)
> (ckptproc+f1)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c9cec Module(sqlservr+c9cec)
> (LogMgr::LogWriter+8a)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x410917b5 Module(ums+17b5)
> (UmsScheduler::Suspend+e3)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cad4b Module(sqlservr+cad4b)
> (lazywriter+f5)
> 0 x004caddb Module(sqlservr+caddb)
> (BPool::LazyWriter+dd)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c6751 Module(sqlservr+c6751)
> (lockMonitorThread+a7)
> 0 x004c6890 Module(sqlservr+c6890)
> (lockMonitor+e8)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c5148 Module(sqlservr+c5148)
> (init_routine+49f)
> 0 x004c4bee Module(sqlservr+c4bee)
> (SignalProc+be)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x4106142f Module(opends60+142f)
> (process_commands+107)
> 0 x4106127c Module(opends60+127c)
> (execute_event+21a)
> 0 x4106256e Module(opends60+256e)
> (execute_rpc+421)
> 0 x0053e114 Module(sqlservr+13e114)
> (execrpc+78d)
> 0 x004fa593 Module(sqlservr+fa593)
> (kill_proc+505)
> 0 x004f9d06 Module(sqlservr+f9d06)
> (freepss+132)
> 0 x004f9f05 Module(sqlservr+f9f05)
> (destroyPssMemory+19)
> 0 x004fa019 Module(sqlservr+fa019)
> (PSS::~PSS+111)
> 0 x005bc329 Module(sqlservr+1bc329)
> (ExecutionContext::Cleanup+9e)
> 0 x0078c4a6 Module(sqlservr+38c4a6)
> (utassert_fail+390)
> 0 x7c4ea4e1 Module(KERNEL32+a4e1)
> (RaiseException+55)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c4af4 Module(sqlservr+c4af4)
> (GlobalTskMgrProc+14a)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cfb36 Module(sqlservr+cfb36)
> (ckptproc+f1)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c9cec Module(sqlservr+c9cec)
> (LogMgr::LogWriter+8a)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x410917b5 Module(ums+17b5)
> (UmsScheduler::Suspend+e3)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cad4b Module(sqlservr+cad4b)
> (lazywriter+f5)
> 0 x004caddb Module(sqlservr+caddb)
> (BPool::LazyWriter+dd)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c6751 Module(sqlservr+c6751)
> (lockMonitorThread+a7)
> 0 x004c6890 Module(sqlservr+c6890)
> (lockMonitor+e8)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c5148 Module(sqlservr+c5148)
> (init_routine+49f)
> 0 x004c4bee Module(sqlservr+c4bee)
> (SignalProc+be)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x4106142f Module(opends60+142f)
> (process_commands+107)
> 0 x4106127c Module(opends60+127c)
> (execute_event+21a)
> 0 x4106256e Module(opends60+256e)
> (execute_rpc+421)
> 0 x0053e114 Module(sqlservr+13e114)
> (execrpc+78d)
> 0 x004fa593 Module(sqlservr+fa593)
> (kill_proc+505)
> 0 x004f9d06 Module(sqlservr+f9d06)
> (freepss+132)
> 0 x004f9f05 Module(sqlservr+f9f05)
> (destroyPssMemory+19)
> 0 x004fa019 Module(sqlservr+fa019)
> (PSS::~PSS+111)
> 0 x005bc329 Module(sqlservr+1bc329)
> (ExecutionContext::Cleanup+9e)
> 0 x0078c4a6 Module(sqlservr+38c4a6)
> (utassert_fail+390)
> 0 x7c4ea4e1 Module(KERNEL32+a4e1)
> (RaiseException+55)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c4af4 Module(sqlservr+c4af4)
> (GlobalTskMgrProc+14a)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cfb36 Module(sqlservr+cfb36)
> (ckptproc+f1)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c9cec Module(sqlservr+c9cec)
> (LogMgr::LogWriter+8a)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x410917b5 Module(ums+17b5)
> (UmsScheduler::Suspend+e3)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cad4b Module(sqlservr+cad4b)
> (lazywriter+f5)
> 0 x004caddb Module(sqlservr+caddb)
> (BPool::LazyWriter+dd)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c6751 Module(sqlservr+c6751)
> (lockMonitorThread+a7)
> 0 x004c6890 Module(sqlservr+c6890)
> (lockMonitor+e8)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c5148 Module(sqlservr+c5148)
> (init_routine+49f)
> 0 x004c4bee Module(sqlservr+c4bee)
> (SignalProc+be)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x4106142f Module(opends60+142f)
> (process_commands+107)
> 0 x4106127c Module(opends60+127c)
> (execute_event+21a)
> 0 x4106256e Module(opends60+256e)
> (execute_rpc+421)
> 0 x0053e114 Module(sqlservr+13e114)
> (execrpc+78d)
> 0 x004fa593 Module(sqlservr+fa593)
> (kill_proc+505)
> 0 x004f9d06 Module(sqlservr+f9d06)
> (freepss+132)
> 0 x004f9f05 Module(sqlservr+f9f05)
> (destroyPssMemory+19)
> 0 x004fa019 Module(sqlservr+fa019)
> (PSS::~PSS+111)
> 0 x005bc329 Module(sqlservr+1bc329)
> (ExecutionContext::Cleanup+9e)
> 0 x0078c44a Module(sqlservr+38c44a)
> (utassert_fail+1a0)
> 0 x006fd620 Module(sqlservr+2fd620)
> (stackTrace+255)
> 0 x006fd663 Module(sqlservr+2fd663)
> (stackTraceException+53)
> 0 x7c4ea4e1 Module(KERNEL32+a4e1)
> (RaiseException+55)
> 0 x230ade8c Module(UNKNOWN+0)
> 0 x0041d94b Module(sqlservr+1d94b)
> (CEs::DestroyPesx+19)
> 0 x0041d98b Module(sqlservr+1d98b)
> (CEsExec::~CEsExec+ac)
> 0 x0041da04 Module(sqlservr+1da04)
> (CEsCompValSeg::DestroyExecValSeg+29)
> 0 x004382f1 Module(sqlservr+382f1)
> (CValExchange<35>::Deref+b)
> 0 x00438310 Module(sqlservr+38310)
> (CValConstXVar::`scalar deleting destructor'+17)
> 0 x0040bd67 Module(sqlservr+bd67) (operator
> delete+15)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c4af4 Module(sqlservr+c4af4)
> (GlobalTskMgrProc+14a)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cfb36 Module(sqlservr+cfb36)
> (ckptproc+f1)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c9cec Module(sqlservr+c9cec)
> (LogMgr::LogWriter+8a)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x410917b5 Module(ums+17b5)
> (UmsScheduler::Suspend+e3)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cad4b Module(sqlservr+cad4b)
> (lazywriter+f5)
> 0 x004caddb Module(sqlservr+caddb)
> (BPool::LazyWriter+dd)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c6751 Module(sqlservr+c6751)
> (lockMonitorThread+a7)
> 0 x004c6890 Module(sqlservr+c6890)
> (lockMonitor+e8)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c5148 Module(sqlservr+c5148)
> (init_routine+49f)
> 0 x004c4bee Module(sqlservr+c4bee)
> (SignalProc+be)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x4106142f Module(opends60+142f)
> (process_commands+107)
> 0 x4106127c Module(opends60+127c)
> (execute_event+21a)
> 0 x4106256e Module(opends60+256e)
> (execute_rpc+421)
> 0 x0053e114 Module(sqlservr+13e114)
> (execrpc+78d)
> 0 x004fa593 Module(sqlservr+fa593)
> (kill_proc+505)
> 0 x004f9d06 Module(sqlservr+f9d06)
> (freepss+132)
> 0 x004f9f05 Module(sqlservr+f9f05)
> (destroyPssMemory+19)
> 0 x004fa019 Module(sqlservr+fa019)
> (PSS::~PSS+111)
> 0 x005bc329 Module(sqlservr+1bc329)
> (ExecutionContext::Cleanup+9e)
> 0 x0078c4a6 Module(sqlservr+38c4a6)
> (utassert_fail+390)
> 0 x7c4ea4e1 Module(KERNEL32+a4e1)
> (RaiseException+55)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c4af4 Module(sqlservr+c4af4)
> (GlobalTskMgrProc+14a)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cfb36 Module(sqlservr+cfb36)
> (ckptproc+f1)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c9cec Module(sqlservr+c9cec)
> (LogMgr::LogWriter+8a)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x410917b5 Module(ums+17b5)
> (UmsScheduler::Suspend+e3)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004cad4b Module(sqlservr+cad4b)
> (lazywriter+f5)
> 0 x004caddb Module(sqlservr+caddb)
> (BPool::LazyWriter+dd)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c6751 Module(sqlservr+c6751)
> (lockMonitorThread+a7)
> 0 x004c6890 Module(sqlservr+c6890)
> (lockMonitor+e8)
> 0 x00401650 Module(sqlservr+1650)
> (ResQueueBase::Dequeue+6d)
> 0 x0040175d Module(sqlservr+175d)
> (ResQueueBase::Wait+36)
> 0 x00401479 Module(sqlservr+1479)
> (ExecutionContext::WaitForSignal+192)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)...
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x004c5148 Module(sqlservr+c5148)
> (init_routine+49f)
> 0 x004c4bee Module(sqlservr+c4bee)
> (SignalProc+be)
> 0 x4109169a Module(ums+169a)
> (UmsEvent::Wait+95)
> 0 x41091828 Module(ums+1828)
> (UmsScheduler::Suspend+b2)
> 0 x41092e2f Module(ums+2e2f)
> (UmsThreadScheduler::Switch+59)
> 0 x77f94091 Module(ntdll+14091)
> (ZwWaitForSingleObject+b)
> 0 x7c4e987c Module(KERNEL32+987c)
> (SetThreadExecutionState+227)
> 0 x78008454 Module(MSVCRT+8454) (endthread+c1)
> 0 x41093523 Module(ums+3523)
> (ThreadStartRoutine+139)
> 0 x41092cff Module(ums+2cff)
> (ProcessWorkRequests+102)
> 0 x4106142f Module(opends60+142f)
> (process_commands+107)
> 0 x4106127c Module(opends60+127c)
> (execute_event+21a)
> 0 x4106256e Module(opends60+256e)
> (execute_rpc+421)
> 0 x0053e114 Module(sqlservr+13e114)
> (execrpc+78d)
> 0 x004fa593 Module(sqlservr+fa593)
> (kill_proc+505)
> 0 x004f9d06 Module(sqlservr+f9d06)
> (freepss+132)
> 0 x004f9f05 Module(sqlservr+f9f05)
> (destroyPssMemory+19)
> 0 x004fa019 Module(sqlservr+fa019)
> (PSS::~PSS+111)
> 0 x005bc329 Module(sqlservr+1bc329)
> (ExecutionContext::Cleanup+9e)
> 0 x0078c4a6 Module(sqlservr+38c4a6)
> (utassert_fail+390)
> 0 x7c4ea4e1 Module(KERNEL32+a4e1)
> (RaiseException+55)
> 2003-10-16 15:58:48.81 kernel Microsoft SQL Server
> 7.00 - 7.00.1063 (Intel X86) ...
> 2003-10-16 15:58:48.83 kernel Logging SQL Server
> messages in file 'C:\MSSQL7\log\ERRORLOG'.
> 2003-10-16 15:58:48.83 kernel All rights reserved.
> 2003-10-16 15:58:48.83 kernel Copyright (C) 1988-1997
> Microsoft Corporation.
> 2003-10-16 15:58:48.91 kernel SQL Server is starting
> at priority class 'high'(1 CPU detected).
> 2003-10-16 15:58:48.91 kernel initconfig: Number of
> user connections limited to 32767.
> 2003-10-16 15:58:49.22 kernel User Mode Scheduler
> configured for thread processing
> 2003-10-16 15:58:50.63 kernel initdata: Warning: Could
> not set working set size to 1558592 KB.
> 2003-10-16 15:58:50.65 server Directory Size: 64939
> 2003-10-16 15:58:50.69 kernel Attempting to initialize
> Distributed Transaction Coordinator.
> 2003-10-16 15:58:50.69 spid1 Using dynamic lock
> allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks
> 2003-10-16 15:58:50.98 spid1 Failed to obtain
> TransactionDispenserInterface: Result Code = 0x8004d01b
> 2003-10-16 15:58:51.00 spid1 Opening file C:\MSSQL7
> \data\master.mdf.
> 2003-10-16 15:58:51.00 spid1 Starting up
> database 'master'.
> 2003-10-16 15:58:51.03 spid1 Opening file C:\MSSQL7
> \data\mastlog.ldf.
> 2003-10-16 15:58:51.10 spid1 Loading SQL Server's
> Unicode collation.
> 2003-10-16 15:58:51.12 spid1 Loading SQL Server's
> non-Unicode sort order and character set.
> 2003-10-16 15:58:51.17 spid1 3 transactions rolled
> forward in database 'master' (1).
> 2003-10-16 15:58:51.18 spid1 0 transactions rolled
> back in database 'master' (1).
> 2003-10-16 15:58:51.20 spid1 Opening file C:\MSSQL7
> \DATA\model.mdf.
> 2003-10-16 15:58:51.20 spid1 Starting up
> database 'model'.
> 2003-10-16 15:58:51.21 spid1 Opening file c:\mssql7
> \data\modellog.ldf.
> 2003-10-16 15:58:51.29 spid1 Clearing tempdb
> database.
> 2003-10-16 15:58:51.31 spid1 Creating file C:\MSSQL7
> \DATA\TEMPDB.MDF.
> 2003-10-16 15:58:51.45 spid1 Closing file C:\MSSQL7
> \DATA\TEMPDB.MDF.
> 2003-10-16 15:58:51.49 spid1 Creating file C:\MSSQL7
> \DATA\TEMPLOG.LDF.
> 2003-10-16 15:58:51.51 spid1 Closing file C:\MSSQL7
> \DATA\TEMPLOG.LDF.
> 2003-10-16 15:58:51.53 spid1 Opening file C:\MSSQL7
> \DATA\TEMPDB.MDF.
> 2003-10-16 15:58:51.55 spid1 Opening file C:\MSSQL7
> \DATA\TEMPLOG.LDF.
> 2003-10-16 15:58:51.85 spid1 Closing file C:\MSSQL7
> \DATA\TEMPDB.MDF.
> 2003-10-16 15:58:51.97 spid1 Closing file C:\MSSQL7
> \DATA\TEMPLOG.LDF.
> 2003-10-16 15:58:52.02 spid1 Starting up
> database 'tempdb'.
> 2003-10-16 15:58:52.07 spid1 Opening file C:\MSSQL7
> \DATA\TEMPDB.MDF.
> 2003-10-16 15:58:52.10 spid1 Opening file C:\MSSQL7
> \DATA\TEMPLOG.LDF.
> 2003-10-16 15:58:52.26 kernel Using 'OPENDS60.DLL'
> version '7.00.00.1063'.
> 2003-10-16 15:58:52.26 kernel Using 'SQLEVN70.DLL'
> version '7.00.1063'.
> 2003-10-16 15:58:52.26 spid1 Server name
> is 'ACCOUNTINGSRVR'.
> 2003-10-16 15:58:52.29 ods Using 'SSNMPN70.DLL'
> version '7.0.694' to listen on '\\.\pipe\sql\query'.
> 2003-10-16 15:58:52.30 ods Using 'SSMSRP70.DLL'
> version '7.0.961' to listen on 'ACCOUNTINGSRVR'.
> 2003-10-16 15:58:52.30 ods Using 'SSMSSO70.DLL'
> version '7.0.1063' to listen on '1433'.
> 2003-10-16 15:58:52.31 spid8 Opening file C:\MSSQL7
> \DATA\DATA_DATA.MDF.
> 2003-10-16 15:58:52.31 spid8 Starting up
> database 'DATA'.
> 2003-10-16 15:58:52.31 spid7 Opening file C:\MSSQL7
> \DATA\pubs.mdf.
> 2003-10-16 15:58:52.31 spid7 Starting up
> database 'pubs'.
> 2003-10-16 15:58:52.31 spid6 Opening file C:\MSSQL7
> \DATA\msdbdata.mdf.
> 2003-10-16 15:58:52.31 spid6 Starting up
> database 'msdb'.
> 2003-10-16 15:58:52.36 spid9 Opening file C:\MSSQL7
> \DATA\DATA_09_DATA.MDF.
> 2003-10-16 15:58:52.36 spid9 Starting up
> database 'DATA_09'.
> 2003-10-16 15:58:52.49 spid7 Opening file c:\mssql7
> \DATA\pubs_log.ldf.
> 2003-10-16 15:58:52.50 spid6 Opening file c:\mssql7
> \DATA\msdblog.ldf.
> 2003-10-16 15:58:52.54 spid9 Opening file C:\MSSQL7
> \DATA\DATA_09_LOG.LDF.
> 2003-10-16 15:58:52.56 spid8 Opening file C:\MSSQL7
> \DATA\DATA_LOG.LDF.
> 2003-10-16 15:58:52.70 spid7 Opening file C:\MSSQL7
> \DATA\Screens_DATA.MDF.
> 2003-10-16 15:58:52.70 spid7 Starting up
> database 'Screens'.
> 2003-10-16 15:58:52.87 spid7 Opening file C:\MSSQL7
> \DATA\Screens_LOG.LDF.
> 2003-10-16 15:58:53.10 spid6 Starting up
> database 'msllockdb'.
> 2003-10-16 15:58:53.11 spid6 Opening file C:\MSSQL7
> \DATA\msllockdb_DATA.MDF.
> 2003-10-16 15:58:53.14 spid7 Opening file c:\mssql7
> \DATA\GenericScreens_data.mdf.
> 2003-10-16 15:58:53.14 spid7 Starting up
> database 'GenericScreens'.
> 2003-10-16 15:58:53.19 spid6 Opening file C:\MSSQL7
> \DATA\msllockdb_LOG.LDF.
> 2003-10-16 15:58:53.21 spid7 Opening file c:\mssql7
> \DATA\GenericScreens_log.ldf.
> 2003-10-16 15:58:53.24 spid8 Opening file C:\MSSQL7
> \DATA\PWE_DATA.MDF.
> 2003-10-16 15:58:53.24 spid8 Starting up
> database 'PWE'.
> 2003-10-16 15:58:53.33 spid8 Opening file C:\MSSQL7
> \DATA\PWE_LOG.LDF.
> 2003-10-16 15:58:53.57 kernel udopen: Operating system
> error 2(The system cannot find the file specified.)
> 2003-10-16 15:58:53.57 spid8 Opening file C:\MSSQL7
> \data\test_Data.MDF.
> 2003-10-16 15:58:53.57 spid8 Starting up
> database 'test'.
> 2003-10-16 15:58:53.58 kernel FCB::Open failed: Could
> not open device C:\MSSQL7\data\test_Data.MDF for virt
> 2003-10-16 15:58:53.60 spid8 Device activation
> error. The physical file name 'C:\MSSQL7\data\test_Data.MD
> 2003-10-16 15:58:53.64 kernel FCB::Open failed: Could
> not open device C:\MSSQL7\data\test2_Data.MDF for vir
> 2003-10-16 15:58:53.64 kernel udopen: Operating system
> error 2(The system cannot find the file specified.)
> 2003-10-16 15:58:53.64 spid8 Opening file C:\MSSQL7
> \data\test2_Data.MDF.
> 2003-10-16 15:58:53.64 spid8 Starting up
> database 'test2'.
> 2003-10-16 15:58:53.66 spid8 Opening file C:\MSSQL7
> \DATA\DATA_10_DATA.MDF.
> 2003-10-16 15:58:53.66 spid8 Starting up
> database 'DATA_10'.
> 2003-10-16 15:58:53.66 spid8 Device activation
> error. The physical file name 'C:\MSSQL7\data\test2_Data.M
> 2003-10-16 15:58:53.74 spid8 Opening file C:\MSSQL7
> \DATA\DATA_10_LOG.LDF.
> 2003-10-16 15:58:53.89 spid8 Opening file C:\MSSQL7
> \DATA\DATA_11_DATA.MDF.
> 2003-10-16 15:58:53.89 spid8 Starting up
> database 'DATA_11'.
> 2003-10-16 15:58:53.94 spid8 Opening file C:\MSSQL7
> \DATA\DATA_11_LOG.LDF.
> 2003-10-16 15:58:55.10 spid6 Opening file C:\MSSQL7
> \data\distribution.MDF.
> 2003-10-16 15:58:55.10 spid6 Starting up
> database 'distribution'.
> 2003-10-16 15:58:55.21 spid6 Opening file C:\MSSQL7
> \data\distribution.LDF.
> 2003-10-16 15:58:55.22 spid7 Opening file C:\MSSQL7
> \data\mmtempmerge_Data.MDF.
> 2003-10-16 15:58:55.22 spid7 Starting up
> database 'mmtempmerge'.
> 2003-10-16 15:58:55.30 spid7 Opening file C:\MSSQL7
> \data\mmtempmerge_Log.LDF.
> 2003-10-16 15:58:55.53 spid7 Opening file C:\MSSQL7
> \data\TempMergeTables_Data.MDF.
> 2003-10-16 15:58:55.53 spid7 Starting up
> database 'TempMergeTables'.
> 2003-10-16 15:58:55.60 spid7 Opening file C:\MSSQL7
> \data\TempMergeTables_Log.LDF.
> 2003-10-16 15:58:57.33 spid1 Recovery complete.
> 2003-10-16 15:58:57.34 spid1 'iso_1' (ID => 1).
> 2003-10-16 15:58:57.34 spid1 SQL Server's non-
> Unicode character set is:
> 2003-10-16 15:58:57.34 spid1 'nocase_iso'
> (ID = 52).
> 2003-10-16 15:58:57.34 spid1 SQL Server's non-
> Unicode sort order is:
> 2003-10-16 15:58:57.34 spid1 comparison
> style = 196609.
> 2003-10-16 15:58:57.34 spid1 'English' (ID => 1033).
> 2003-10-16 15:58:57.34 spid1 SQL Server's Unicode
> collation is:
> 2003-10-16 15:58:57.74 spid1 Launched startup
> procedure 'sp_MSrepl_startup'
> 2003-10-16 15:59:00.89 spid8 Using 'xpsqlbot.dll'
> version '1998.11.13' to execute extended stored procedu
> 2003-10-16 16:00:00.91 spid9 Using 'xpstar.dll'
> version '2000.28.09' to execute extended stored procedure
> 2003-10-16 16:01:01.84 spid10 Using 'xpsql70.dll'
> version '2000.28.09' to execute extended stored procedure
> 2003-10-16 22:25:12.40 kernel
> BackupMedium::ReportIoError: write failure on backup
> device 'E:\MSSQL7\bak\DA
> 2003-10-16 22:25:13.46 backup Database backed up with
> following information: Database: distribution, creati
> 2003-10-16 22:25:21.20 backup Database backed up with
> following information: Database: GenericScreens, crea
> 2003-10-16 22:25:25.25 backup Database backed up with
> following information: Database: master, creation dat
> 2003-10-16 22:25:26.09 backup Database backed up with
> following information: Database: model, creation date
> 2003-10-16 22:25:28.71 backup Database backed up with
> following information: Database: msdb, creation date
> 2003-10-16 22:25:30.43 backup Database backed up with
> following information: Database: msllockdb, creation
> 2003-10-16 22:25:31.22 backup Database backed up with
> following information: Database: pubs, creation date
> 2003-10-16 22:25:31.77 backup Database backed up with
> following information: Database: PWE, creation date a
> 2003-10-16 22:25:39.25 backup Database backed up with
> following information: Database: Screens, creation da
> 2003-10-16 22:25:48.85 backup Database backed up with
> following information: Database: TempMergeTables, cre
> 2003-10-17 13:22:04.80 spid9 Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:18.60 spid9
> SqlDumpExceptionHandler: Process 9 generated fatal
> exception c0000005 EXCEPT
> 2003-10-17 13:22:18.60 spid9 Error: 0, Severity: 19,
> State: 0
> 2003-10-17 13:22:19.67 spid9 Error occured during
> cursor cleanup.
> 2003-10-17 13:22:19.67 spid9 Error occured during
> cursor close.
> 2003-10-17 13:22:19.68 spid9 Error occured during
> cursor close.
> 2003-10-17 13:22:19.71 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:33.53 kernel SQL Server Assertion:
> File: <proc.c>, line=1931 ...
> 2003-10-17 13:22:33.56 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:45.75 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:22:47.12 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:22:59.31 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:00.68 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:23:12.87 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:14.24 server Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-10-17 13:23:26.43 server SqlDumpExceptionHandler:
> Process 1692 generated fatal exception c000001d EXCE
> 2003-10-17 13:23:27.77 server SQL Server is aborting.
> Fatal exception c000001d caught.
>