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: Unable to Overwrite Read-Only Dynamic Snapshot Pre_snapshot_script     
Total Hits: 296  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

In SQL Server 2000, for merge publications with dynamic filters, you can create dynamic snapshot jobs for improved performance. However, if the snapshot job has either the @pre_snapshot_command or @post_snapshot_command parameter set, and you execute the dynamic snapshot job more than once, the job might fail and the following error message occurs

Could not copy script file '\\shiloh2\repldata\unc\scripts\script1.sql' to the snapshot generation folder....

PRB: SQL Server ODBC Driver Converts Language Events to Unicode (Q234748)     
Total Hits: 535  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When using the MDAC 2.1 or later version of the SQL Server ODBC driver (version 3.70.0623 or later) or the OLEDB provider (version 7.01.0623 or later), under some circumstances you may experience translation of character data from the client code page to the server code page, even when Autotranslation is disabled for the connection.

...

PRB: "Cannot Start More Transactions on This Session" Error Message When You Use OLE DB Provider for SQL Server in ADO.NET (Q316872)     
Total Hits: 1976  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you use Microsoft OLE DB Provider for SQL Server (OLEDBSQL) in ADO.NET, if you try to start more than one transaction in a session, you receive the following error message:

System.Data.OleDb.OleDbException: Cannot start more transactions on this session...

BUG: SqlClient Connection Pooling That Uses Integrated Security Is Slower Than OleDb (Q316757)      
Total Hits: 1277  |  Today: 0Author: MSDN      Rating:  
Read Reviews | Write Review |  Your Rating: 

Microsoft SQL Server .NET data provider (SqlClient) is slower than OLE DB .NET data provider (OleDb) when you use connection pooling with integrated security....

BUG: DTS Wizard Generates Unspecified Error Message If Database with a Period in Name is Used     
Total Hits: 1375  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

If you run the Data Transformation Services (DTS) Wizard and you specify a database that contains a period in the name as either the source or destination, the following error message appear:

Error Source: Microsoft OLE DB Provider for SQL Server

Error Description: Unspecified Error
Could not find server ''%1%'' in sysservers. Execute sp_addlinkedserver to add the server to sysservers....

FIX: Missing Views in Transactional Replication     
Total Hits: 1254  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you apply the initial snapshot of a SQL Server 2000 replication publication, the distribution agent (for snapshot or transactional publications) or merge agent (for merge publications) may fail with the following error message:

Category:SQLSERVER
Source: server_name
Number: 208
Message: Invalid object name ''V2''.
Category:AGENT
Source: AGENT
Number: 00000
Message: Unable to replicate a view or function because the referenced objects or columns are not present on the Subscriber...Read More..

FIX: Cannot Attach Database When You Change the Database Name and Use ENTER Key in the Attach Database Dialog Box     
Total Hits: 897  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you attach database files, you can specify a different name for the database other than the original name. To specify a different name for the database, use the Attach Database dialog box in the SQL Enterprise Manager and specify the new name in the Attach As option....

FIX: SQL Profiler May Return Unavailable Error Messages for a Remote Output File     
Total Hits: 386  |  Today: 0      Rating:  
Read Reviews | Write Review |  Your Rating: 

When you run a SQL Profiler trace, you may occasionally experience both of these problems when you save the output file to a remote location:
Any attempt to connect to a computer that is running SQL Server from within SQL Profiler fails with this error message:

Server does not exist or access denied.
  • Any attempt to write to an output file fails with this error message:


  • The specified network name is no longer available.
    ...

    FIX: DMO BulkCopy Fails to Copy Data When Column Names Contain the Space Character     
    Total Hits: 793  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    Using the SQL Distributed Management Objects (DMO) BulkCopy object to
    import data into a SQL Server table that contains a column with a space embedded in the column name may fail with no rows copied.

    ...

    PRB: Unexpected Warning About Eliminating NULLs from Aggregate (Q317312)     
    Total Hits: 2048  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    If you run a query that contains an aggregate function in the subquery, and if the subquery returns a non-NULL column, it may be possible for the query as a whole to generate the following warning message:Msg 8153 Warning: Null value is eliminated by an aggregate or other SET operation....

    PRB: SQL Server CE OLE DB Provider Specific Properties Give Compilation Error (Q307530)     
    Total Hits: 278  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    An attempt to use a Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) provider specific property in a Microsoft embedded Visual C++ OLE DB program causes a compilation error. For example, if you try to create a password-protected database through OLE DB, and you pass the DBPROP_SSCEOLEDB_DBPASSWORD provider-specific property, the following error message occurs:
    error C2065: ''DBPROP_SSCEOLEDB_DBPASSWORD'' : undeclared identifier...

    PRB: SQL Server CE Delete Query with a Subquery Over a Large Table May Stop Responding (Hang) (Q303004)     
    Total Hits: 638  |  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....

    FIX: Queue Reader Agent Fails with "Invalid Cursor State" Error Message     
    Total Hits: 395  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    The Queue Reader Agent may fail with an error message similar to the following:
    Failed while applying queued message to publisher
    Server: PUBLISHER, Database QueuedPublisher : ODBC Error:Invalid cursor state
    Worker Thread 556 : Aborted Queue Transaction...

    FIX: sp_MSdependencies May Run for a Long Time to Script Tables and Views     
    Total Hits: 853  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    With a large database that has 6,000 tables and 15,000 views, the
    sysdepends system table may have close to 500,000 rows. An attempt to script 10 tables by using only DROP and CREATE table statements took several minutes on an 8-processor computer. The most time was spent on sp_MSdependencies stored procedure, which does not seem necessary because the dependency objects were not requested. According to this speed, to script all the tables and views may take over 10 days, which is a serious p...

    BUG: sp_resolve_logins Stored Procedure Fails If Executed During Log Shipping Role Change     
    Total Hits: 519  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    During a Log Shipping role change an attempt to execute the
    sp_resolve_logins stored procedure fails. The following error message occurs when you execute the
    sp_resolve_logins stored procedure from a recently recovered secondary database:
    Server: Msg 208, Level 16, State 1, Line 1
    Invalid object name ''syslogins''....

    BUG: DTC Transaction Allows Commits While SQL Server Shuts Down     
    Total Hits: 228  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    If SQL Server is in the process of a shut down, and you attempt to commit a Distributed Transaction Coordinator (DTC) transaction, the DTC transaction is successfully committed instead of rolling back....

    FIX: AUTO-SHRINK Option or DBCC SHRINKDATABASE May Slow Down SQL Server 2000 Performance (Q296386)     
    Total Hits: 1852  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    If a database is full or nearly full, and a large number of the tables in the database do not have clustered indexes, the AUTO-SHRINK database option or DBCC SHRINKDATABASE command may cause severe performance degradation for SQL Server 2000. The performance may degrade to the point where queries do not return results in a timely fashion. It takes longer for new connections to connect, resulting in connection timeouts. SQL Server 2000 may appear to stop responding (hang)....

    BUG: ODBC Driver Incorrectly Shows Linked Data as #DELETED (Q248602)     
    Total Hits: 311  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    When you use Microsoft Access 97 and the SQL Server ODBC driver version 2.65.xx to link a table on a SQL Server specifically configured as follows:
    Character Set: 850 (MultiLingual)
    Sort Order: Binary Order (bin_cp850)
    Unicode Collation: Binary Unicode Collation (ID = 33280)
    the linked table shows valid data rows. After you upgrade to Microsoft Access 2000, which uses the SQL Server ODBC driver version 3.70.06.23, the linked table data is incorrectly shown as #DELETED....

    FIX: ADO Returns No Resultset for Prepared Parameterized Query Involving CHAR Data with SQLOLEDB (Q311313)     
    Total Hits: 372  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    ActiveX Data Objects (ADO) may return no data with the SQLOLEDB provided under the following conditions:
    • The Prepared property on the command object is set to TRUE.

    • The query has a parameterized LIKE clause.

    • The column included with the LIKE clause is defined as CHAR (and not as VARCHAR) at the back end.

    • The parameter value has fewer characters than the back-end column size.

    • You are connecting to either a Microsoft SQL Server 7.0 or SQL Server 2000 database. If it is a SQL Server 2000 database, the Defer Prepare property is set to FALS..Read More..

    FIX: SQL Server Driver Fails to Connect over TCP/IP Using Three Parameters in Address Keyword (Q311836)     
    Total Hits: 2167  |  Today: 0      Rating:  
    Read Reviews | Write Review |  Your Rating: 

    A connection to a back-end SQL Server database may fail with the following error:[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).[Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]SQL Server does not exist or access denied. This error occurs under the following conditions:
    • You are using the Microsoft ODBC Driver for SQL Server 2000 that comes with Microsoft Data Access Components (MDAC) version 2.6, 2.6 SP1, 2.6 SP2, or 2.7.

    • The TCP/IP protocol is used; in other words, the Network keyword is set to DBMSSOCN.

    • The Address keyword ..Read More..


    1  2  3  4  5  Next >> 


    Disclaimer - Privacy
    © 2002-2017 DevASP.net