|
Home > Archive > microsoft.public.sqlserver.server > November 2002 > Error on Database Design
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Error on Database Design
|
|
| Steven Thomas 2002-11-20, 10:24 am |
| I am recieving the following error in the event log when
ever I try to design a table from Enterprise Manager:
language_exec: Process 54 generated an access violation.
SQL Server is terminating this process..
It is followed by a stack dump that starts:
Using 'dbghelp.dll' version '4.0.5'
*Stack Dump being sent to d:\MSSQL\log\SQL00028.dmp
*
******************************
****************************
*********************
*
* BEGIN STACK DUMP:
* 11/20/02 09:48:24 spid 60
*
* Exception Address = 00401EA0 (RecBase::Resize +
00000005 Line 0+00000000)
* Exception Code = c0000005
EXCEPTION_ACCESS_VIOLATION
* Access Violation occurred reading address 00000000
* Input Buffer 1192 bytes -
* select xp.name, cast(xp.[value] as nvarchar(4000)),
cast(SQL_VARIANT_PRO
* PERTY(xp.[value], 'BaseType') as nvarchar(256)), cast
(SQL_VARIANT_PROPER
* TY(xp.[value], 'MaxLength') as int), cast
(SQL_VARIANT_PROPERTY(xp.[value
* ], 'Precision') as int), cast(SQL_VARIANT_PROPERTY(xp.
[value], 'Scale')
* as int)from ::fn_listextendedproperty(NULL
, N'user',
N'dbo', N'table', N
* 'SafetyActionCouncilMembers', NULL, NULL) xp where
xp.name in (N'MS_Desc
* ription', N'MS_Filter', N'MS_OrderBy',
N'MS_SubdatasheetName', N'MS_Link
* ChildFields', N'MS_LinkMasterFields',
N'MS_SubdatasheetHeight', N'MS_Sub
* datasheetExpanded')
*
*
* MODULE BASE END
SIZE
* sqlservr 00400000 00B19FFF
0071a000
* ntdll 77F80000 77FFAFFF
0007b000
* KERNEL32 77E80000 77F34FFF
000b5000
******************************
***************************/
Does anyone have ideas what could be wrong?
| |
| msnews 2002-11-20, 11:23 am |
| What about your maching particulars: version of the OS, version of SQL etc.
That could be usefull
"Steven Thomas" <stmthoma@gapac.com> wrote in message
news:bee501c290b0$516ce4d0$89f
82ecf@TK2MSFTNGXA01...
> I am recieving the following error in the event log when
> ever I try to design a table from Enterprise Manager:
>
> language_exec: Process 54 generated an access violation.
> SQL Server is terminating this process..
>
> It is followed by a stack dump that starts:
>
> Using 'dbghelp.dll' version '4.0.5'
> *Stack Dump being sent to d:\MSSQL\log\SQL00028.dmp
> *
> ******************************
****************************
> *********************
> *
> * BEGIN STACK DUMP:
> * 11/20/02 09:48:24 spid 60
> *
> * Exception Address = 00401EA0 (RecBase::Resize +
> 00000005 Line 0+00000000)
> * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 00000000
> * Input Buffer 1192 bytes -
> * select xp.name, cast(xp.[value] as nvarchar(4000)),
> cast(SQL_VARIANT_PRO
> * PERTY(xp.[value], 'BaseType') as nvarchar(256)), cast
> (SQL_VARIANT_PROPER
> * TY(xp.[value], 'MaxLength') as int), cast
> (SQL_VARIANT_PROPERTY(xp.[value
> * ], 'Precision') as int), cast(SQL_VARIANT_PROPERTY(xp.
> [value], 'Scale')
> * as int)from ::fn_listextendedproperty(NULL
, N'user',
> N'dbo', N'table', N
> * 'SafetyActionCouncilMembers', NULL, NULL) xp where
> xp.name in (N'MS_Desc
> * ription', N'MS_Filter', N'MS_OrderBy',
> N'MS_SubdatasheetName', N'MS_Link
> * ChildFields', N'MS_LinkMasterFields',
> N'MS_SubdatasheetHeight', N'MS_Sub
> * datasheetExpanded')
> *
> *
> * MODULE BASE END
> SIZE
> * sqlservr 00400000 00B19FFF
> 0071a000
> * ntdll 77F80000 77FFAFFF
> 0007b000
> * KERNEL32 77E80000 77F34FFF
> 000b5000
> ******************************
***************************/
>
> Does anyone have ideas what could be wrong?
>
| |
| Steven Thomas 2002-11-20, 11:23 am |
| I am running:
Windows 2000 server
SQL 2000 sp2
4 x 200 mhz Pent Pros
Compaq 6000
1 Gig Ram
I get this error from multiple client machines. I do not
however get this error on all of the SQL Servers I have
installed
I even ran this query:
SELECT *
FROM ::fn_listextendedproperty(NULL
, NULL, NULL, NULL,
NULL, NULL, NULL)
And got these results:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]
ConnectionCheckForData (CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I also got the same stack dump in the ErrorLog.
Anyone have any Ideas?
| |
| msnews 2002-11-20, 11:23 am |
| What are the client machines?
"Steven Thomas" <stmthoma@gapac.com> wrote in message
news:bb7d01c290b7$40ca9b70$8df
82ecf@TK2MSFTNGXA02...
> I am running:
> Windows 2000 server
> SQL 2000 sp2
> 4 x 200 mhz Pent Pros
> Compaq 6000
> 1 Gig Ram
>
> I get this error from multiple client machines. I do not
> however get this error on all of the SQL Servers I have
> installed
>
> I even ran this query:
> SELECT *
> FROM ::fn_listextendedproperty(NULL
, NULL, NULL, NULL,
> NULL, NULL, NULL)
>
> And got these results:
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]
> ConnectionCheckForData (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
>
> Connection Broken
>
> I also got the same stack dump in the ErrorLog.
>
> Anyone have any Ideas?
| |
| Steven Thomas 2002-11-20, 11:23 am |
| It is running on a windows 2000 server. I am running SQL 2K sp2.
4x200mhz processor box with 1gig ram.
I get this error from multiple client machines. I do not however get
this error on all of the SQL Servers I have installed
I even ran this query:
SELECT *
FROM ::fn_listextendedproperty(NULL
, NULL, NULL, NULL, NULL, NULL,
NULL)
And got these results:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionChe
ckForData
(CheckforData()).
Server: Msg 11, Level 16, State 1, Line 0
General network error. Check your network documentation.
Connection Broken
I also got the same stack dump in the ErrorLog.
Anyone have any Ideas?
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| msnews 2002-11-20, 12:23 pm |
| compare the network setup on the sql server that you fail to connect to with
enterprise manager against the ones that work. My guess is there is
something different there.
"Steven Thomas" <sthomas.cs93@gtalumni.org> wrote in message
news:#VqJkkLkCHA.2668@tkmsftngp11...
> It is running on a windows 2000 server. I am running SQL 2K sp2.
> 4x200mhz processor box with 1gig ram.
>
> I get this error from multiple client machines. I do not however get
> this error on all of the SQL Servers I have installed
>
> I even ran this query:
> SELECT *
> FROM ::fn_listextendedproperty(NULL
, NULL, NULL, NULL, NULL, NULL,
> NULL)
>
> And got these results:
> [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionChe
ckForData
> (CheckforData()).
> Server: Msg 11, Level 16, State 1, Line 0
> General network error. Check your network documentation.
>
> Connection Broken
>
> I also got the same stack dump in the ErrorLog.
>
> Anyone have any Ideas?
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| Steven Thomas 2002-11-20, 12:23 pm |
| I get the error from both the Enterprise manager on the
server itself and from my desktop which is a:
Dell Optiplex GX110
Windows XP sp1
PIII 750 mhz
384 mgs RAM.
| |
| Steven Thomas 2002-11-20, 12:23 pm |
|
I am running a Dell Optiplex GX110
PIII 750 Mhz
284 Mg Ram
Windows XP Professional
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Stefan 2002-11-20, 4:23 pm |
| Steven,
Do you get these error messages when logged on as sa or as another user ? I
had a similar issue when running sp_helpdb; I had to drop the user from the
database and add it.
On the other hand, did you check the database for corruption ?
"Steven Thomas" <stmthoma@gapac.com> wrote in message
news:bee501c290b0$516ce4d0$89f
82ecf@TK2MSFTNGXA01...
> I am recieving the following error in the event log when
> ever I try to design a table from Enterprise Manager:
>
> language_exec: Process 54 generated an access violation.
> SQL Server is terminating this process..
>
> It is followed by a stack dump that starts:
>
> Using 'dbghelp.dll' version '4.0.5'
> *Stack Dump being sent to d:\MSSQL\log\SQL00028.dmp
> *
> ******************************
****************************
> *********************
> *
> * BEGIN STACK DUMP:
> * 11/20/02 09:48:24 spid 60
> *
> * Exception Address = 00401EA0 (RecBase::Resize +
> 00000005 Line 0+00000000)
> * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 00000000
> * Input Buffer 1192 bytes -
> * select xp.name, cast(xp.[value] as nvarchar(4000)),
> cast(SQL_VARIANT_PRO
> * PERTY(xp.[value], 'BaseType') as nvarchar(256)), cast
> (SQL_VARIANT_PROPER
> * TY(xp.[value], 'MaxLength') as int), cast
> (SQL_VARIANT_PROPERTY(xp.[value
> * ], 'Precision') as int), cast(SQL_VARIANT_PROPERTY(xp.
> [value], 'Scale')
> * as int)from ::fn_listextendedproperty(NULL
, N'user',
> N'dbo', N'table', N
> * 'SafetyActionCouncilMembers', NULL, NULL) xp where
> xp.name in (N'MS_Desc
> * ription', N'MS_Filter', N'MS_OrderBy',
> N'MS_SubdatasheetName', N'MS_Link
> * ChildFields', N'MS_LinkMasterFields',
> N'MS_SubdatasheetHeight', N'MS_Sub
> * datasheetExpanded')
> *
> *
> * MODULE BASE END
> SIZE
> * sqlservr 00400000 00B19FFF
> 0071a000
> * ntdll 77F80000 77FFAFFF
> 0007b000
> * KERNEL32 77E80000 77F34FFF
> 000b5000
> ******************************
***************************/
>
> Does anyone have ideas what could be wrong?
>
| |
| Tibor Karaszi 2002-11-21, 2:23 am |
| Stack dumps etc are SQL Server bugs. Search KB, consider applying service packs etc. If that
doesn't fix things, open a case with MS PSS.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Steven Thomas" <stmthoma@gapac.com> wrote in message
news:bee501c290b0$516ce4d0$89f
82ecf@TK2MSFTNGXA01...
> I am recieving the following error in the event log when
> ever I try to design a table from Enterprise Manager:
>
> language_exec: Process 54 generated an access violation.
> SQL Server is terminating this process..
>
> It is followed by a stack dump that starts:
>
> Using 'dbghelp.dll' version '4.0.5'
> *Stack Dump being sent to d:\MSSQL\log\SQL00028.dmp
> *
> ******************************
****************************
> *********************
> *
> * BEGIN STACK DUMP:
> * 11/20/02 09:48:24 spid 60
> *
> * Exception Address = 00401EA0 (RecBase::Resize +
> 00000005 Line 0+00000000)
> * Exception Code = c0000005
> EXCEPTION_ACCESS_VIOLATION
> * Access Violation occurred reading address 00000000
> * Input Buffer 1192 bytes -
> * select xp.name, cast(xp.[value] as nvarchar(4000)),
> cast(SQL_VARIANT_PRO
> * PERTY(xp.[value], 'BaseType') as nvarchar(256)), cast
> (SQL_VARIANT_PROPER
> * TY(xp.[value], 'MaxLength') as int), cast
> (SQL_VARIANT_PROPERTY(xp.[value
> * ], 'Precision') as int), cast(SQL_VARIANT_PROPERTY(xp.
> [value], 'Scale')
> * as int)from ::fn_listextendedproperty(NULL
, N'user',
> N'dbo', N'table', N
> * 'SafetyActionCouncilMembers', NULL, NULL) xp where
> xp.name in (N'MS_Desc
> * ription', N'MS_Filter', N'MS_OrderBy',
> N'MS_SubdatasheetName', N'MS_Link
> * ChildFields', N'MS_LinkMasterFields',
> N'MS_SubdatasheetHeight', N'MS_Sub
> * datasheetExpanded')
> *
> *
> * MODULE BASE END
> SIZE
> * sqlservr 00400000 00B19FFF
> 0071a000
> * ntdll 77F80000 77FFAFFF
> 0007b000
> * KERNEL32 77E80000 77F34FFF
> 000b5000
> ******************************
***************************/
>
> Does anyone have ideas what could be wrong?
>
|
|
|
|
|