|
|
|
|
|
| | Total Hits: 906 | 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: 184 | Today: 0 | | Rating: |
| |
SQL Enterprise Manager (SEM) does not display tables that have a special character in their name from the Taskpad view. You can see this problem when you display all the tables from a given database.
To navigate to the Taskpad view, click a database name in Enterprise Manager, and then click Taskpad view on the View menu.... |
| | Total Hits: 172 | Today: 0 | | Rating: |
| |
There are two issues regarding virtual cubes and incorrect results returned from a Multidimensional Expression (MDX). The first issue is when you use the NON EMPTY keyword in a MDX query against a virtual cube and that virtual cube has fewer levels then one of the underlying cubes. The MDX query returns incorrect or empty values. The second issue is if you have a security role defined for a dimension with server side enforcement. If you then query a virtual cube that has the dimension as part of... |
| | Total Hits: 202 | Today: 0 | | Rating: |
| |
SQL Server 7.0 and SQL Server 2000 provide a mechanism for performing distributed queries against an OLE DB provider. This can be done by using the new OpenQuery or OpenRowset function. For example,the following SQL statement performs a query against an OLE DB provider called MyProv by using the command... |
| | Total Hits: 253 | Today: 0 | | 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.... |
| | Total Hits: 253 | Today: 0 | | 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.... |
| | Total Hits: 278 | Today: 0 | | 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.... |
| | Total Hits: 186 | Today: 0 | | Rating: |
| |
The Mode column receives data for events other than Lock and Scan events.
... |
| | Total Hits: 442 | Today: 0 | | 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.... |
| | Total Hits: 391 | Today: 0 | | 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... |
| | Total Hits: 380 | Today: 0 | | 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...
|
| | Total Hits: 218 | Today: 0 | | 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.... |
| | Total Hits: 221 | Today: 0 | | Rating: |
| |
If you install an instance of Microsoft SQL Server 2000 Desktop Engine on a computer that already has the SQL Server 7.0 client tools installed, the installation fails during the SkuIt custom action and the following error message appears in the setup log file:Loading extended custom action library sqlcax.dll Starting custom action SkuIt
An internal error occurred during install (failed to load package id).
Contact Microsoft Technical Support.Action ended 15:35:19:
InstallFinalize. Ret... |
| | Total Hits: 448 | Today: 0 | | 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|