Error in Sql Server 2000 sp4

I′ve got a problem with SQL server. The server stops responding and gives me
out an error below.
Anyone can help me. When it runs this select in the database the server
keeps with 80% 100% processor up and stops responding all client requests.
Memory
MemoryLoad = 94%
Total Physical = 2047 MB
Available Physical = 116 MB
Total Page File = 8041 MB
Available Page File = 6246 MB
Total Virtual = 2047 MB
Available Virtual = 281 MB
*Stack Dump being sent to E:\Microsoft SQL Server\MSSQL\log\SQLDump0009.txt
*
************************************************** ***************************
**
*
* BEGIN STACK DUMP:
* 02/23/07 10:17:59 spid 89
*
* Exception Address = 00402836
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000004
* Input Buffer 82 bytes -
* SELECT * from ProdutosParaSiteWeb_ANALISE
Luis,
Is ProdutosParaSiteWeb_ANALISE a view? If so, examine the code for the view
for complexity. Maybe you have uncovered a SQL Server bug, but recrafting
the code could work around the problem.
If ProdutosParaSiteWeb_ANALISE is a table, or the view is very simple, then
you might be concerned with database integrity. Run as DBCC CHECKDB and see
if it reveals any errors.
RLF
"Luis" <Luis@.discussions.microsoft.com> wrote in message
news:D1CA43FA-34B2-4A2A-8D83-529913BB66AB@.microsoft.com...
> Ive got a problem with SQL server. The server stops responding and gives
> me
> out an error below.
> Anyone can help me. When it runs this select in the database the server
> keeps with 80% 100% processor up and stops responding all client requests.
> Memory
> MemoryLoad = 94%
> Total Physical = 2047 MB
> Available Physical = 116 MB
> Total Page File = 8041 MB
> Available Page File = 6246 MB
> Total Virtual = 2047 MB
> Available Virtual = 281 MB
> *Stack Dump being sent to E:\Microsoft SQL
> Server\MSSQL\log\SQLDump0009.txt
> *
> ************************************************** ***************************
> **
> *
> * BEGIN STACK DUMP:
> * 02/23/07 10:17:59 spid 89
> *
> * Exception Address = 00402836
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000004
> * Input Buffer 82 bytes -
> * SELECT * from ProdutosParaSiteWeb_ANALISE
>

Error in Sql Server 2000 sp4

I′ve got a problem with SQL server. The server stops responding and gives m
e
out an error below.
Anyone can help me. When it runs this select in the database the server
keeps with 80% 100% processor up and stops responding all client requests.
Memory
MemoryLoad = 94%
Total Physical = 2047 MB
Available Physical = 116 MB
Total Page File = 8041 MB
Available Page File = 6246 MB
Total Virtual = 2047 MB
Available Virtual = 281 MB
*Stack Dump being sent to E:\Microsoft SQL Server\MSSQL\log\SQLDump0009.txt
*
****************************************
************************************
*
**
*
* BEGIN STACK DUMP:
* 02/23/07 10:17:59 spid 89
*
* Exception Address = 00402836
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000004
* Input Buffer 82 bytes -
* SELECT * from ProdutosParaSiteWeb_ANALISELuis,
Is ProdutosParaSiteWeb_ANALISE a view? If so, examine the code for the view
for complexity. Maybe you have uncovered a SQL Server bug, but recrafting
the code could work around the problem.
If ProdutosParaSiteWeb_ANALISE is a table, or the view is very simple, then
you might be concerned with database integrity. Run as DBCC CHECKDB and see
if it reveals any errors.
RLF
"Luis" <Luis@.discussions.microsoft.com> wrote in message
news:D1CA43FA-34B2-4A2A-8D83-529913BB66AB@.microsoft.com...
> Ive got a problem with SQL server. The server stops responding and gives
> me
> out an error below.
> Anyone can help me. When it runs this select in the database the server
> keeps with 80% 100% processor up and stops responding all client requests.
> Memory
> MemoryLoad = 94%
> Total Physical = 2047 MB
> Available Physical = 116 MB
> Total Page File = 8041 MB
> Available Page File = 6246 MB
> Total Virtual = 2047 MB
> Available Virtual = 281 MB
> *Stack Dump being sent to E:\Microsoft SQL
> Server\MSSQL\log\SQLDump0009.txt
> *
> ****************************************
**********************************
***
> **
> *
> * BEGIN STACK DUMP:
> * 02/23/07 10:17:59 spid 89
> *
> * Exception Address = 00402836
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000004
> * Input Buffer 82 bytes -
> * SELECT * from ProdutosParaSiteWeb_ANALISE
>

Error in Sql Server 2000 sp4

I´ve got a problem with SQL server. The server stops responding and gives me
out an error below.
Anyone can help me. When it runs this select in the database the server
keeps with 80% 100% processor up and stops responding all client requests.
Memory
MemoryLoad = 94%
Total Physical = 2047 MB
Available Physical = 116 MB
Total Page File = 8041 MB
Available Page File = 6246 MB
Total Virtual = 2047 MB
Available Virtual = 281 MB
*Stack Dump being sent to E:\Microsoft SQL Server\MSSQL\log\SQLDump0009.txt
*
*****************************************************************************
**
*
* BEGIN STACK DUMP:
* 02/23/07 10:17:59 spid 89
*
* Exception Address = 00402836
* Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred writing address 00000004
* Input Buffer 82 bytes -
* SELECT * from ProdutosParaSiteWeb_ANALISELuis,
Is ProdutosParaSiteWeb_ANALISE a view? If so, examine the code for the view
for complexity. Maybe you have uncovered a SQL Server bug, but recrafting
the code could work around the problem.
If ProdutosParaSiteWeb_ANALISE is a table, or the view is very simple, then
you might be concerned with database integrity. Run as DBCC CHECKDB and see
if it reveals any errors.
RLF
"Luis" <Luis@.discussions.microsoft.com> wrote in message
news:D1CA43FA-34B2-4A2A-8D83-529913BB66AB@.microsoft.com...
> I´ve got a problem with SQL server. The server stops responding and gives
> me
> out an error below.
> Anyone can help me. When it runs this select in the database the server
> keeps with 80% 100% processor up and stops responding all client requests.
> Memory
> MemoryLoad = 94%
> Total Physical = 2047 MB
> Available Physical = 116 MB
> Total Page File = 8041 MB
> Available Page File = 6246 MB
> Total Virtual = 2047 MB
> Available Virtual = 281 MB
> *Stack Dump being sent to E:\Microsoft SQL
> Server\MSSQL\log\SQLDump0009.txt
> *
> *****************************************************************************
> **
> *
> * BEGIN STACK DUMP:
> * 02/23/07 10:17:59 spid 89
> *
> * Exception Address = 00402836
> * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred writing address 00000004
> * Input Buffer 82 bytes -
> * SELECT * from ProdutosParaSiteWeb_ANALISE
>

Error in MSDE setup

When I install MSDE, I am getting an error and the installation stops. In
the log file that is created it looks like this:
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 10:31:21: InstallFinalize. Return value 3.
When I look in the server log, it gives me the same message. "Refer to the
server error logs and setup error logs for more information." Big help!
My setup.ini file looks like this:
[Options]
INSTANCENAME = "CDC"
SAPWD = "CDC2003"
I checked the Windows event log and found this:
The MSSQL$CDC service failed to start due to the following error:
MSSQL$CDC is not a valid Win32 application.
I think this is the problem, but have no idea what is going on or how to fix
this.
Any ideas?
Thanks
LanceTurns out there is a problems with some MS products that if there is a file
on the root of C drive called "Program" then it fails when it trys to start
the service.
Lance
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:uiWTb.7265$IF1.3090@.fed1read01...
> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to
fix
> this.
> Any ideas?
> Thanks
> Lance
>

Error in MSDE setup

When I install MSDE, I am getting an error and the installation stops. In
the log file that is created it looks like this:
Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
"SQL_Latin1_General_CP1_CI_AS""
Setup failed to configure the server. Refer to the server error logs and
setup error logs for more information.
Action ended 10:31:21: InstallFinalize. Return value 3.
When I look in the server log, it gives me the same message. "Refer to the
server error logs and setup error logs for more information." Big help!
My setup.ini file looks like this:
[Options]
INSTANCENAME = "CDC"
SAPWD = "CDC2003"
I checked the Windows event log and found this:
The MSSQL$CDC service failed to start due to the following error:
MSSQL$CDC is not a valid Win32 application.
I think this is the problem, but have no idea what is going on or how to fix
this.
Any ideas?
Thanks
LanceTurns out there is a problems with some MS products that if there is a file
on the root of C drive called "Program" then it fails when it trys to start
the service.
Lance
"Lance Geeck" <lgeeck@.cox.net> wrote in message
news:uiWTb.7265$IF1.3090@.fed1read01...

quote:

---

> When I install MSDE, I am getting an error and the installation stops. In
> the log file that is created it looks like this:
> Executing "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "CDC29999" -Q
> "SQL_Latin1_General_CP1_CI_AS""
> Setup failed to configure the server. Refer to the server error logs and
> setup error logs for more information.
> Action ended 10:31:21: InstallFinalize. Return value 3.
> When I look in the server log, it gives me the same message. "Refer to the
> server error logs and setup error logs for more information." Big help!
> My setup.ini file looks like this:
> [Options]
> INSTANCENAME = "CDC"
> SAPWD = "CDC2003"
> I checked the Windows event log and found this:
> The MSSQL$CDC service failed to start due to the following error:
> MSSQL$CDC is not a valid Win32 application.
> I think this is the problem, but have no idea what is going on or how to

---

fix

quote:

---

> this.
> Any ideas?
> Thanks
> Lance
>

---

Error handling?!

Hi
I have the following problem.
When I execute a statement i get an error and my statement stops running
but there is errorhandling.
Does anyone knows why i don't get the print statement?
15 is a wrong number to generate the error.
Thanks, John
DDL:
DECLARE @.intError INTEGER
SELECT CONVERT(VARCHAR, GETDATE(), 15)
SELECT @.intError = @.@.ERROR
IF @.intError != 0
PRINT 'Error occured!'
ELSE
PRINT 'No Error...'
Result:
Server: Msg 281, Level 16, State 1, Line 3
15 is not a valid style number when converting from datetime to a
character string.
Server: Msg 8114, Level 16, State 1, Line 3
Error converting data type datetime to varchar.
========================================
======================
Johnny van Cadsand news ( ) cadsand ! demon ! nl
A computer beat me at chess once.
But, it was no match for me at kick boxing.On Sun, 29 May 2005 11:25:14 -0000, Johnny van Cadsand wrote:

>Hi
>I have the following problem.
>When I execute a statement i get an error and my statement stops running
>but there is errorhandling.
>Does anyone knows why i don't get the print statement?
(snip)
Hi Johnny,
For some errors, SQL Server will immediately terminate the batch. These
will never be catched by your error handling routine.
More information:
http://www.sommarskog.se/error-handling-I.html
http://www.sommarskog.se/error-handling-II.html
Best, Hugo
--
(Remove _NO_ and _SPAM_ to get my e-mail address)|||Hugo Kornelis wrote :

> On Sun, 29 May 2005 11:25:14 -0000, Johnny van Cadsand wrote:
>
> (snip)
> Hi Johnny,
> For some errors, SQL Server will immediately terminate the batch.
> These will never be catched by your error handling routine.
> More information:
> http://www.sommarskog.se/error-handling-I.html
> http://www.sommarskog.se/error-handling-II.html
> Best, Hugo
Thanks...
Johnny van Cadsand news ( ) cadsand ! demon ! nl