|
|
|
|
|
| | Total Hits: 1759 | Today: 0 | | 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).... |
| | Total Hits: 1565 | Today: 0 | | 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'.... |
| | Total Hits: 422 | Today: 0 | | 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.
... |
| | Total Hits: 672 | Today: 0 | | 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... |
| | Total Hits: 389 | Today: 0 | | Rating: |
| |
Certain sequences of errors may cause missing results in Query Analyzer (Isqlw.exe). This is only a display issue; the actual commands execute correctly.
... |
| | Total Hits: 850 | 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: 1278 | 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: 1172 | 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: 820 | 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: 409 | Today: 0 | | Rating: |
| |
An access violation (AV) may be generated when you run a DBCC CHECKDB or DBCC CHECKTABLE statement on a table that has the following conditions:
An inrow text/image column.
A computed column based on the text/image column.
An index on the computed column.Resolution... |
| | Total Hits: 694 | Today: 0 | | 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.
... |
| | Total Hits: 1964 | Today: 0 | | 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.... |
| | Total Hits: 197 | Today: 0 | | 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... |
| | Total Hits: 540 | Today: 0 | | 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.... |
| | Total Hits: 215 | Today: 0 | | Rating: |
| |
SQL Server 2000 returns incorrect results if you use the DEFAULT keyword with a user defined function (UDF) in a SELECT statement that references a view.
... |
| | Total Hits: 323 | Today: 0 | | 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... |
| | Total Hits: 760 | Today: 0 | | 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... |
| | Total Hits: 214 | Today: 0 | | 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.... |
| | Total Hits: 420 | Today: 0 | | 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''.... |
| | Total Hits: 226 | Today: 0 | | 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.... |
|
|
|
|
|
|
|
|
|
|
|
|
|