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: SQL Server 2000 ODBC Driver Fails to Return SQL Server 7.0 Server Names (Q299765)     
Total Hits: 269  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

From a client computer that has Microsoft Data Access Components (MDAC) 2.6 and SQL Server ODBC Driver version 2000.80.194, if you try to retrieve all of the server names by calling the SQLBrowseConnect() ODBC API function, you will not receive any SQL Server 7.0 (or earlier) server names. You will only receive the SQL Server 2000 server list....

FIX: Combination of GROUP BY with HAVING Clause and LEFT OUTER JOIN with Derived Table Produces Incorrect Result (Q308458)     
Total Hits: 422  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If all of the following conditions are true for a query, extra rows may return for certain data sets:
  • You include GROUP BY and HAVING clauses.

  • You use a LEFT OUTER JOIN.

  • You incorporate derived tables.

  • You use an aggregate.
...

FIX: SP1 Regression: Running FREETEXT Queries May Cause a MS Search Resource Leak (Q308718)     
Total Hits: 200  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Execution of full-text queries with the FREETEXT predicate may cause a memory leak over time in the MS Search process. In testing, under high stress with a large number of full-text queries, the memory leak was approximately 200 KB over 35 hours....

FIX: Synchronization May Fail After You Use Large Text or Image Data (Q304072)     
Total Hits: 246  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you use text or image data in a Microsoft SQL Server 2000 Windows CE edition version 1.1 (SQL Server CE) database, the following error message may occur when you use the merge replication object: Source: Microsoft SQL Server 2000 Windows CE Edition Error Number: 80072F7F Native Number: 28032 Error Description: Run Failure initializing internet functionality SSCE_M_FAILUREINITIALIZINGINTERNET...

FIX: SQL Server CE eVB CompactDatabase Unable to Fix Corrupted Database (Q306452)     
Total Hits: 598  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A corrupted database may produce the following error message in the Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) Query Analyzer if you attempt to open a connection: Error: 0x80004005 E_FAIL Minor Error: (25017) Description: Unspecified Error The error code is SSCE_M_DATABASECORRUPTED (Non-database file or database file corrupted). A Microsoft embedded Visual Basic (eVB) application that uses the CompactDatabase method is not able to compact a corrupted SQL Server CE database. An ...

FIX: ESQL/C Precompiler May Cause Access Violation When It Processes a Complex ESQL Project (Q315559)     
Total Hits: 284  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When the ESQL/C precompiler processes a complex ESQL project, the precompiler may generate an Access Violation (AV) and the following error messages may occur: SQL Server 2000 The instruction at "0x0040defe" referenced memory at "XXXX". The memory could not be "read".SQL Server 7.0 The instruction at "0x0040df70" referenced memory at "XXXX". The memory could not be "read". NOTE: The address of the offending instructions (0x0040defe and 0x0040df70) are always the same. However, the target address...

FIX: Incorrect Results with Uncorrelated Subquery If You Use an Aggregate Function and NULL Values in the WHERE Clause (Q310472)     
Total Hits: 266  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

A SELECT query may return an incorrect result if an uncorrelated subquery in the WHERE clause contains the MIN or MAX function and more than one IS NULL in the WHERE clause of the subquery....

FIX: SQLPutData May Result in Leak of Buffer Pool Memory (Q307540)     
Total Hits: 289  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

An ODBC application that uses the SQLPutData API may cause a leak of buffer pool memory with each invocation. This buffer pool memory cannot be reclaimed and over time may cause SQL Server to run out of buffer pool memory. This condition can cause the SQL Server program to stop responding (hang). One of the most visible symptoms of the problem is Error 17803 as seen in the SQL Server error log....

FIX: SQL Profiler Trace Has Extraneous Values in Mode Column (Q308715)     
Total Hits: 197  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

The Mode column receives data for events other than Lock and Scan events.

...

BUG: Bcp.exe Executes Query Twice When QueryOut Argument Used (Q309555)     
Total Hits: 457  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

Exporting rows from a table by using the bcp utility takes longer
than expected when you specify the QueryOut argument to provide
selective criteria when retrieving rows....

FIX: Linked Index Server Query Through OLE DB Provider with OR Clause Reports Error 7349 (Q281185)     
Total Hits: 403  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If these conditions are true:
  • You have a linked server that uses a provider, which supports the IRowsetIndex interface.

  • A query is run using the four part naming convention.

  • The query contains an OR in the WHERE clause.

This error message occurs:Server: Msg 7349, Level 16, State 2, Line 1 OLE DB provider '''' could not set range for table''[]..[].[]'' because of column ''''.Could no...

PRB: Poor Performance on a Heap (Q297861)     
Total Hits: 394  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

One or more of the following symptoms may accompany poor performance
during inserts to a large table on SQL Server:
  • Unexplained high CPU usage by SQL Server, sometimes up to 100%

  • SQL Profiler or SHOWPLAN indicates that singleton inserts have wide variations in performance.

  • The number of reads is out of proportion to the number or size of the indexes and triggers on the table.

  • Sporadic timeouts.

  • The FreeSpace Scans/Sec counter fro...

FIX: Use of a Dynamic API Server Cursor with a NOLOCK Hint Causes Error 1047 (Q310935)     
Total Hits: 229  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you open a Dynamic API server cursor with a NOLOCK optimizer hint, this error message occurs:
Server: Msg 1047, Level 15, State 1, Line 1 Conflicting locking hints specified....

FIX: GetExecutionErrorInfo and OnError Event May Not Return All Errors (Q251229)     
Total Hits: 468  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When a Data Transformation Service (DTS) Package step fails, the OnError event and the GetExecutionErrorInfo method may not provide all the error messages, even though the DTS Wizard, DTSRun tool, and the Designer UI report the full error detail....


1  2  3  4  5  


Disclaimer - Privacy
© 2002-2017 DevASP.net