Solved

sql error 10043

Posted on 2004-08-14
4
316 Views
Last Modified: 2008-03-06
we are running MS-SQL 2005. Its giving me error code 10043. Any idea how to fix it? After the upgrade from SQL 2000 to 2005, every thing which rely's on SQL is broke. Please help.
0
Comment
Question by:mike_gillani
  • 2
4 Comments
 
LVL 10

Accepted Solution

by:
AaronAbend earned 500 total points
ID: 11803700
Sounds like a data dictionary error. You might check the dtproperties table - it is a "user" table  but contains metadata used by SQL server. I do not have 2005 installed yet so I cannot check this myself.  
0
 
LVL 10

Expert Comment

by:AaronAbend
ID: 11803706
And when are you getting this error? When the server starts? Do you get it if your database is offline/detached?

More clarification on my first idea - I think there is a column missing from one of your old 2000 tables that SQL2005 needs to work.

0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

In this article—a derivative of my DaytaBase.org blog post (http://daytabase.org/2011/06/18/what-week-is-it/)—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
Introduction In my previous article (http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_9150-Loading-XML-Using-SSIS.html) I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

707 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now