Search - Articles
DevASP.NET for ASP.NET, VB.NET, XML and C# (C-Sharp) Developers Tuesday, March 03, 2009
Dev Articles
Search Directory
ASP.NET
VB.Net
C-Sharp
SQL Server
 


Home >Search > Knowledge Base > SQL Server > Errors


Search:
What's New - What's Hot
You may receive the error "This document already has a DocumentElement node." - Part II     
Total Hits: 247  |  Today: 0Author: Harish      Rating:  
Read Reviews | Write Review |  Your Rating: 

In continuation to Part I of this article, we will examine how we can load the XML Fragment returned by the SQL FOR XML query, into a DataSet, to form a Well Formed XML Document....

You may receive the error "This document already has a DocumentElement node." - Part III     
Total Hits: 240  |  Today: 0Author: Harish      Rating:  
Read Reviews | Write Review |  Your Rating: 

In Part II, we examined how we can utilize the DataSet's intelligence to handle XML Format to overcome the "Document Element" issue while reading XML Data from SQL Server using FOR XML queries. We will examine a much more efficient way of handling SQL XML using the SQL XML Managed classes provided with the Microsoft SQL XML Managed Provider (Available for free download from Microsoft). Microsoft SQL XML introduces powerful set of Properties/Methods to manipulate XML Data from SQL Server FOR XML ...

PRB: SQL Server CE Delete Query with a Subquery Over a Large Table May Stop Responding (Hang) (Q303004)     
Total Hits: 642  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Delete query, with a subquery over a large table, may appear to stop responding (hang). For example, a query similar to the following may take a long time to return if the tables t1 and t2 are large:
delete from t1 where col1 in (select t2.col1 from t2 where t2.col2="something")The creation of indexes on the relevant columns of the tables may not solve the problem for this particular query....

PRB: SQL Server Enterprise Manager Startup or Service Pack Installation May Fail with "OleMainThreadWndName: regsvr32.exe-Invalid DLL Entrypoint"..     
Total Hits: 356  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you start SQL Server Enterprise Manager (SEM) or when you install a SQL Server Service Pack, this error message may occur:
OleMainThreadWndName: regsvr32.exe-Invalid DLL Entrypoint The dynamic link library is not written correctly. The stack pointer has been
left in an inconsistent state. The entrypoint should be declared as WINAPI or STDCALL. Select YES to fail the DLL load. Select NO to continue execution....

FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source (Q317979)      
Total Hits: 747  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you submit a query to a remote data source and the query contains a string longer than what is expected, the buffer could be overwritten. If you submit a query that has a string longer than expected, the query may cause a handled exception of this SQL Server thread, or may allow an attacker to run arbitrary code under the security context in which the SQL Server service is running....

PRB: Upgrade Wizard Fails with "Logins ID unable to open registry on the target computer." Error Message (Q310542)     
Total Hits: 312  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you perform an in-place or "one computer" upgrade from Microsoft SQL Server 6.5 to SQL Server 7.0 or SQL Server 2000 on a Microsoft Windows 2000-based computer, the Upgrade Wizard may fail with the following error message: The Upgrade wizard is failing to export the logins from SQL Server 6.5. ''Logins ID unable to open registry on the target computer.''...

FIX: Infinite Loop Occurs in ESQL Application That Uses Keyset Cursor (Q306096)     
Total Hits: 719  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Applications built with Microsoft Embedded SQL for C (ESQL/C) may go into an infinite loop when a KEYSET cursor opens and another connection modifies the first row on the server before the row is fetched....

PRB: SQL Application Role Errors with OLE DB Resource Pooling (Q229564)     
Total Hits: 2590  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you enable a SQL Server application role on a Microsoft ActiveX Data Objects (ADO) connection to SQL Server, you may receive the following error message when you connect to SQL Server 7.0: sp_setapprole was not invoked correctly. Refer to the documentation for more information.When you connect to SQL Server 2000, the error may appear as follows:[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation This error occurs when sp_setapprole is called on...

BUG: SP_ADD_JOBSTEP Does Not Recognize Server Names Longer Than 30 Characters (Q310639)     
Total Hits: 685  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you use the msdb..sp_add_jobstep stored procedure to add a job
step, if the server name (NetBIOS name + \Instance name) exceeds 30
characters, msdb..sp_add_jobstep may fail with the following error: Error 14234: The specified ''@server'' is invalid" (valid values are returned by sp_helpserver).For example, this error may be returned when you configure a replication distribution server or when you run the Create Job Wizard on a server with a name that exceeds 30 characters....

PRB: SQL Server 2000 Installation or Local Connections Fail with "SSL Security error :ConnectionOpen (SECDoClientHandshake())" Error Message (Q309398)     
Total Hits: 1320  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you try to install Microsoft SQL Server 2000 on a computer that has certificates, installation can fail and you may receive the following error message:
[Microsoft][ODBC SQL Server Driver][Shared Memory]SSL Security error [Microsoft][ODBC SQL Server Driver][Shared Memory]ConnectionOpen (SECDoClientHandshake()).SQL Server configuration failed.
-or-
When you add certificates to a server that already has SQL Server installed, local connections fail....

PRB: SQL Server 2000 Views Not Replicated to Microsoft Access Through Merge Replication (Q318241)     
Total Hits: 107  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQL Server 2000 views are not replicated to Microsoft Access 2002 or Microsoft Access 2000 databases through Merge Replication. The Merge Agent reports "succeeded" but does not replicate views to the Microsoft Access subscription database. No errors are logged....

0x8000FFFF 'Catastrophic failure' Message with SQL Server ODBC Driver (Q243349)     
Total Hits: 347  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The following error may be generated by the Microsoft SQL Server ODBC driver, especially when you are using the ODBC driver in connection-pooled environments such as Internet Information Server (IIS):

Error 0x8000FFFF Catastrophic failure
The typical symptoms are that the driver is used successfully for a varying amount of time, but the error then occurs when you attempt to open a connection object.

This problem occurs with the 3.70.0690 build of the Microsoft SQL Server ODBC driver (Sqlsrv32.dll) but does not occur with earlier builds. Also, the problem does not occur when..Read More..

BUG: NOT FOR REPLICATION Clause Causes SQL Server CE Replication to Fail (Q300597)     
Total Hits: 1052  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A Microsoft SQL Server™ 2000 Windows® CE Edition Subscriber produces the following error messages when you invoke the merge process:
RESULT:NUMBER = 80040E14 NATIVE_ERROR = 25501, SSCE_M_QP_BADPARSE
You may also receive the following additional native error messages:
28557 (SSCE_M_UNUSABLEDATABASE):
"The database is in an unusable state. Delete it and recreate it.
"28560 (SSCE_M_EXECUTEFAILED):
"OLE DB Execute Method failed; bad or invalid SQL statement"...

PRB: Error Message 3266 Occurs When Microsoft Tape Backup Format Cannot be Read (Q290787)     
Total Hits: 1233  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you perform a database backup to disk or tape, or a restore from disk or tape, the following error message may occur:SQL Server 7.0 Server: Msg 3266, Level 16, State 1, Line 1 The Microsoft Tape Format (MTF) soft filemark database on backup device ''devicename'' cannot be read, inhibiting random access. Server: Msg 3013, Level 16, State 1, Line 1 Backup or restore operation terminating abnormally. SQL Server 2000 Server: Msg 3266, Level 16, State 1, Line 1 The backup data in ...

FIX: Join of Multiple Tables May Fail with E_OUTOFMEMORY Error Message (Q315109)     
Total Hits: 865  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You may encounter the following error message when you execute a SELECT query that joins multiple tables:
Error: 0x8007000e E_OUTOFMEMORY Minor Error: (0)
Description: Interface defining error: IID_ICommand

...

FIX: Error Message 8624 "Internal SQL Server" Occurs with Cold Index Retrieval OLE DB Provider (Q309568)     
Total Hits: 1565  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you perform a query against a linked server, this error message may occur:Server: Msg 8624, Level 16, State 25, Line 7 Internal SQL Server error....

BUG: DBCC DBREINDEX Can Cause Error 8623 on Indexed View (Q310714)     
Total Hits: 235  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The DBCC DBREINDEX statement can cause the following error: Error
8623, Level 16, State 5, Line 1
Internal Query Processor Error: The query processor could not produce a query plan. Contact your primary support provider for more information.This error can occur when all of the following conditions are met:

  • You run DBCC DBREINDEX on an indexed view without the optional index name parameter.

  • The indexed view also has a nonclustered index built on it.

  • The ...

FIX: RPC Clients Unable to Login to SQL Server with Windows Authentication (Q311111)     
Total Hits: 345  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Under the following conditions, a client application cannot connect to SQL Server:
  • The client uses the client components of SQL Server 7.0 (MDAC 2.1), or later.

  • The client wants to connect through Multiprotocol (Remote Procedure Call [RPC]).

  • The server is configured to use "Windows only" authentication.
...

PRB: SQL Server Setup in a Cluster Environment Encounters an Access Violation If You Have a Long Computer Name (Q289828)     
Total Hits: 201  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A SQL Server Setup in a cluster encounters an access violation after an account is assigned to perform a remote installation in a Microsoft Clustering Services (MSCS) environment if following are true:
  • With SQL Server 2000 Enterprise Edition, all the nodes in the cluster are configured as possible nodes of the virtual server.

  • The computer name of the primary domain controller (PDC) of the domain in which the cluster resides contains 14 or 15 characters.

BUG: SP1 Regression: Uninstalling SQL Server 2000 Does Not Remove the MSSQLServerADHelper Service (Q308853)     
Total Hits: 578  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

MSSQLServerADHelper is a service installed by the SQL Server Setup program that handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications that are running on the computer. There is only one MSSQLServerADHelper service on a computer for all of the instances of Microsoft SQL Server 2000.On computers that are running SQL Server 2000 Service Pack 1 (SP1), uninstalling all the instances of Microsoft SQL Server 2000 does n...



Disclaimer - Privacy
© 2002-2017 DevASP.net