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 > Bugs and Fixes > Bugs and Fixes


Search:
What's New - What's Hot
FIX: Log Reader Agent Fails with 18767 and 18762 Error Messages (Q316783)     
Total Hits: 466  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Log Reader Agent may fail with the following error messages: The specified begin LSN (%ls) for replication log scan occurs before replbeginlsn (%ls). (Source: (Data source); Error number: 18767)-or-Invalid begin LSN (%ls) for commit record (%ls). Check DBTABLE. (Source: (Data source); Error number: 18762)...

BUG: SQL Server 2000 Evaluation Edition Fails to Extract (Q316046)     
Total Hits: 301  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You cannot extract the files in the SQL Server 2000 Evaluation version that you download from the Web site if the free disk space on your hard drive is less than 500 MB above a multiple of 4 GB.For example, if the free space on your hard drive is between 4 GB and 4.5 GB, or 8 GB and 8.5 GB, or 12 GB and 12.5GB, and so on, the following error message occurs after you run Sqleval.exe: There is not enough space on drive C:\ to extract this package. Please free up 515.82MB and click Retry....

FIX: Unchecked Buffer May Occur When You Connect to Remote Data Source (Q317979)      
Total Hits: 748  |  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....

INF: List of Bugs Fixed by SQL Server 2000 Windows CE Edition 1.1 Service Packs (Q316497)     
Total Hits: 199  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

This article provides information about the bugs fixed by SQL Server 2000 Windows CE Edition 1.1 service packs. Because service packs are cumulative, subsequent service packs also fix the bugs fixed by previous service packs.
...

BUG: VSS Database Truncates Stored Procedures Larger Than 4 KB (Q313993)     
Total Hits: 727  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you check in stored procedures that are larger than 4 KB, anything after the 4 KB limit is truncated in the Visual SourceSafe (VSS) database. The stored procedure is never truncated in the SQL Server database.

...

FIX: Rebuildm and Setup Do Not Expose All the SQL Collations (Q312990)     
Total Hits: 366  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

You cannot change the SQL Collation in SQL Server 2000 with the Rebuild Master Utility or the SQL Server 2000 Setup from the current SQL Collation to any of the following SQL Collations:
  • SQL_Estonian_CP1257_CI_AS

  • SQL_Estonian_CP1257_CS_AS

  • SQL_Latin1_General_CP1257_CI_AS

  • SQL_Latvian_CP1257_CI_AS

  • SQL_Latvian_CP1257_CS_AS

  • SQL_Lithuanian_CP1257_CI_AS

  • SQL_Lithuanian_CP1257_CS_AS

  • SQL_Danish_Pref_CP1_CI_AS

FIX: Transaction Log of Snapshot Published Database Cannot Be Truncated (Q306769)     
Total Hits: 252  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The transaction log of a database, with a snapshot publication, does not truncate if the database is also a Subscriber to a transactional replication publication. The capability to truncate the log should exist because the publication is a snapshot publication. When an attempt to truncate the transaction log occurs, the following error message displays because the publication is a snapshot publication and there is no Log Reader Agent:The log was not truncated because records at the beginning of ...

FIX: Infinite Loop Occurs in ESQL Application That Uses Keyset Cursor (Q306096)     
Total Hits: 720  |  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....

FIX: "ODBC SQL Server Driver" Error Message When You Use the MDAC 2.6 ODBC Driver from SP1 or SP2     
Total Hits: 1600  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you attempt to execute a SELECT statement with parameters by using the ODBC driver for SQL Server 2000 that is included in Microsoft Data Access Components (MDAC) version 2.6 Service Pack 1 (SP1) or Service Pack 2 (SP2), you may receive an error message similar to the following:

[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near 'Y'....

BUG: DTS Separates the Columns of Text at Invalid Trail Byte of DBCS (Q312089)     
Total Hits: 685  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use the Data Transformation Services (DTS) Delimited option to import a text file with double-byte character set (DBCS) characters, DTS may erroneously parse the columns at trailing bytes of DBCS characters.This problem occurs when all of the following conditions are true:
  • The encoding of the text file is either ANSI or OEM.

  • You use a single-byte character set (SBCS) character as a column delimiter. For example: vertical bar ( 0x7c )

  • The trailing byte of...

PRB: Error Message "Unspecified Error" When Executing a DTS Package Modified Dynamically (Q238367)     
Total Hits: 540  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When Executing a DTS (Data Transformation Server) package modified dynamically in code, you might see the following error message: Unspecified Error" -2147958789 from package.Execute method.The DTS ScriptPackage tool also fails with the same error when you try to script that package....

PRB: SQL Application Role Errors with OLE DB Resource Pooling (Q229564)     
Total Hits: 2591  |  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: Optimizer Uses Scan with Multiple OR Clauses on Composite Index (Q223423)     
Total Hits: 205  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Queries with multiple OR clauses, based on the fields in a composite index, may display slow execution times as the optimizer does not use the index for the query, but instead uses a scan. This only happens when the query is executed from within a stored procedure, or executed through an ODBC application.

...

FIX: SQLDescribeCol Returns Wrong Column Size in a Union Query with Parameters (Q308211)     
Total Hits: 214  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

SQLDescribeCol returns the wrong column length if all of the following conditions are met:
  • The query consists of a union of two or more SELECT statements.

  • One of the WHERE clauses contains parameters.

  • The first of the two unioned queries returns a constant for a column (for example, SELECT ''ABC'') and the other returns a column(for example, SELECT col1).
...

BUG: Unable to Change Identity Range of Publisher If You Use Auto Identity Range (Q310540)     
Total Hits: 232  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you set up a table and you use Auto Identity Range to manage the table, you cannot use SQL Enterprise Manager or the sp_changemergearticle stored procedure to change the publisher''s range.

...

FIX: Open of DTS Package Fails with Type Mismatch Error Message (Q310473)     
Total Hits: 712  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you try to open a Data Transformation Services (DTS) package from SQL Server Enterprise Manager that was previously saved to either SQL Server or a structured storage file, you may receive the following error message: Error Source: Microsoft Data Transformation Services (DTS) Package Error Description: Type mismatch.Followed by this error message:The selected package cannot be opened. The DTS Designer has been closed.Alternately, if you open the DTS package programmatically, the LoadFromSQL...

BUG: SP_ADD_JOBSTEP Does Not Recognize Server Names Longer Than 30 Characters (Q310639)     
Total Hits: 686  |  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: 1321  |  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....

FIX: Memory and Handle Leak When You Use MSXML Inside SQL Server Stored Procedure (Q303114)     
Total Hits: 565  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use Microsoft XML (MSMXL) inside a SQL Server stored procedure through the SQL Server OLE automation stored procedures (sp_OACreate, etc...), and use a client application that opens and closes connections and executes the stored procedure, you will see a persistently rising handle and memory leak inside of SQL Server.
If you open a single connection to SQL Server, and call the exact same stored procedure over and over, you do not see any handle or memory leaks....

FIX: Upgrade from SQL Server 7.0 May Abort with Messages.sql and You Cannot Connect to SQL Server (Q300676)     
Total Hits: 711  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you upgrade a server from Microsoft SQL Server 7.0 to SQL Server 2000, the setup may fail when it executes the Messages.sql script. To identify this issue, review these logs:

The Sqlstp.log log file.
The Sqlstp.log file (located on %SystemRoot%\ or C:\Winnt\) may contain a line just before the one that runs Messages.sql, which indicates the SQL Server services started and the exit code indicates success. However, the MSSQLServer service is not started....


1  2  3  4  5  Next >> 


Disclaimer - Privacy
© 2002-2017 DevASP.net