|
|
|
|
|
Total Hits: 439 | Today: 0
|
|
Rating:
|
|
When you run an UPDATE statement, and the connection's isolation level is set to READ UNCOMMITTED, you may receive the following error message:
Error: 644, Severity: 21, State: 6
Could not find the index entry for RID '%.*hs' in index page %S_PGID, index ID %d, database '%.*ls'.
RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencin...
|
|
|
|
Total Hits: 323 | Today: 0
|
|
Rating:
|
|
If a message fails validation or routing in Microsoft BizTalk Server 2004, the BizTalk Adapter for SQL Server rolls back the transaction, and the failed message is still in the source SQL database. The SQL adapter will pick it up again, and then try to process it. The processing fails again, and the transaction rolls back again. This problem creates a continuous loop.
RESOLUTION
A supported hotfix is now available from Microsoft, but it is only intended to correct the problem t...
|
|
|
|
Total Hits: 1399 | Today: 0
|
Author: MSDN
|
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...
|
|
|
|
Total Hits: 603 | Today: 0
|
Author: MSDN
|
Rating:
|
|
When you execute the SqlTransaction.ExecuteReader function within a repeatable read transaction, the transaction is blocked and then aborted due to a deadlock. When a repeatable read transaction is blocked by a deadlock, SqlTransaction.ExecuteReader may throw incorrect exceptions and, in some situations, may return with an empty reader....
|
|
|
|
Total Hits: 901 | Today: 0
|
Author: MSDN
|
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....
|
|
|
|
Total Hits: 510 | Today: 0
|
Author: MSDN
|
Rating:
|
|
Microsoft does not support the use of Microsoft Common Language Runtime (included with the .NET Framework 1.1) for any COM Callable Wrapper or Managed Extensions for C++ in either Microsoft SQL Server 7.0 or Microsoft SQL Server 2000. This limitation for support pertains directly to the use of extended stored procedures and the use of OLE Automation for any loading of the libraries that you must load to run in the SQL Server memory space....
|
|
|
|
Total Hits: 1703 | Today: 0
|
|
Rating:
|
|
When Microsoft Data Access Components (MDAC) version 2.6 is installed, each attempt to connect to a SQL Server 7.0 or SQL Server 2000 database using an IP address (rather than the server name) may take longer than anticipated. "In certain reported cases, a "Timeout expired" error is reported to the client application and the connection attempt fails....
|
|
|
|
Total Hits: 648 | Today: 0
|
|
Rating:
|
|
When you install SQL Server 2000 Desktop Engine (MSDE 2.0), the installation may fail and roll back.
NOTE: To determine why the failure occurred, you can generate a verbose log file by using /L*v (e.g., setup.exe /L*v c:\msde_install.log). Look for "Return Value 3" to determine the cause for the failure. In the log file, you may see error messages similar to the following:
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 1010
Action ended 21:39:40: InstallFinalize. Return value 3.
Read More..
|
|
|
|
Total Hits: 907 | Today: 0
|
|
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....
|
|
|
|
Total Hits: 817 | Today: 0
|
|
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..
|
|
|
|
Total Hits: 518 | Today: 0
|
|
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....
|
|
|
|
Total Hits: 255 | Today: 0
|
|
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.
...
|
|
|
|
|
|
