Enterprise Manager error when designing tables

• smthomas

  Grasshopper

  Points: 11

  More actions

  November 19, 2002 at 7:17 am

  #63220

  I am running a Windows 2000 server with SQL 2000 SP2 loaded on it. When I open Enterprise manager, either from the server or my desktop, and try to design a table my connection is broken. When I review the SQL error log I get a stack dump preceded by this error "language_exec: Process 54 generated an access violation. SQL Server is terminating this process..".

  Here is the begining of the stack dump

  * Exception Address = 00401EA0 (RecBase::Resize + 00000005 Line 0+00000000)

  * Exception Code = c0000005 EXCEPTION_ACCESS_VIOLATION

  * Access Violation occurred reading address 00000000

  * Input Buffer 1168 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

  * 'ByProductsData', NULL, NULL) xp where xp.name in (N'MS_Description', N'

  * MS_Filter', N'MS_OrderBy', N'MS_SubdatasheetName', N'MS_LinkChildFields'

  * , N'MS_LinkMasterFields', N'MS_SubdatasheetHeight', N'MS_SubdatasheetExp

  * anded')

  *

  *

  Any Ideas what is wrong?

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736270

  More actions

  November 19, 2002 at 9:04 am

  #441728

  Bad install. I'd reinstall the tools.

  Steve Jones

  sjones@sqlservercentral.com

  http://www.sqlservercentral.com/columnists/sjones

• sthomas

  Newbie

  Points: 1

  More actions

  November 20, 2002 at 10:23 am

  #441854

  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 on other machines

  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?

  Edited by - sthomas on 11/20/2002 10:32:14 AM

• Simon Sabin

  SSCrazy Eights

  Points: 8142

  More actions

  November 20, 2002 at 2:44 pm

  #441890

  Try reapplying the latest service pack.

  Can you run

  select * from ::fn_listextendedproperty(NULL, N'user', N'dbo', N'table', N'ByProductsData', NULL, NULL)

  Simon Sabin

  Co-author of SQL Server 2000 XML Distilled

  http://www.amazon.co.uk/exec/obidos/ASIN/1904347088

  
  Simon Sabin
  SQL Server MVP
  
  http://sqlblogcasts.com/blogs/simons