|
|
|
|
|
Total Hits: 211 | 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: 129 | Today: 0
|
|
Rating:
|
|
If the first row passed to the Bookmark Lookup operator is locked, a query that contains the READPAST locking hint returns an incorrect number of rows. Refer to the "More Information" section for an example....
|
|
|
|
Total Hits: 103 | 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: 395 | Today: 1
|
|
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: 130 | 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: 1235 | 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: 299 | Today: 0
|
|
Rating:
|
|
When you install SQL Server 2000 as a named instance and create an alias for that instance (which can be seen on the Alias tab in the SQL Server Client Network Utility), the installation of SP1 on that instance may sometimes fail with the following error message: Setup failed to configure the server. Refer to the server error logs and C:\WINNT\sqlstp.log for more information.The following error message is also seen:Error running script: sp1_serv_uni.sql (1)When the error occurs, the following error message is logged in the Sp1_serv_uni.out file for a SQL Server 2000 SP1 installation, and in Sq..Read More..
|
|
|
|
Total Hits: 123 | Today: 0
|
|
Rating:
|
|
If you run the DBCC DBREINDEX command on a nonclustered index and the following conditions are true, it can cause a handled access violation exception in the CColumnGroupProperties::CColumnGroupProperties function of SQL Server 2000, which is reported in the SQL Server error log and terminates the client connection that ran the query.The conditions are as follows:
- The nonclustered index is based on an indexed view.
- The indexed view contains an aggregate function in the sel...
|
|
|
|
Total Hits: 1029 | 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: 210 | Today: 0
|
|
Rating:
|
|
When Executing a DTS (Data Transformation Server) package modified dynamically in code, you might see the following error message: Unspecified Error" -2147958789 from package.Execute method.The DTS ScriptPackage tool also fails with the same error when you try to script that package....
|
|
|
|
Total Hits: 2007 | Today: 1
|
|
Rating:
|
|
When you enable a SQL Server application role on a Microsoft ActiveX Data Objects (ADO) connection to SQL Server, you may receive the following error message when you connect to SQL Server 7.0: sp_setapprole was not invoked correctly. Refer to the documentation for more information.When you connect to SQL Server 2000, the error may appear as follows:[DBNETLIB][ConnectionRead (WrapperRead()).]General network error. Check your network documentation This error occurs when sp_setapprole is called on...
|
|
|
|
Total Hits: 139 | 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: 1212 | Today: 0
|
|
Rating:
|
|
When you perform a query against a linked server, this error message may occur:Server: Msg 8624, Level 16, State 25, Line 7 Internal SQL Server error....
|
|
|
|
Total Hits: 369 | 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: 339 | Today: 0
|
|
Rating:
|
|
When you use the msdb..sp_add_jobstep stored procedure to add a job
step, if the server name (NetBIOS name + \Instance name) exceeds 30
characters, msdb..sp_add_jobstep may fail with the following error: Error 14234: The specified ''@server'' is invalid" (valid values are returned by sp_helpserver).For example, this error may be returned when you configure a replication distribution server or when you run the Create Job Wizard on a server with a name that exceeds 30 characters....
|
|
|
|
Total Hits: 444 | Today: 1
|
|
Rating:
|
|
The following error message may occur when you execute a multidimensional expressions (MDX) query that contains the NON EMPTY clause against a virtual cube. An unexpected internal error has occurred.The error message may occur if both of the following conditions are true:
- TheNon Empty Behavior property of the "calculated member"
equals the name of its parent measure dimension.
- You execute a MDX query with a NON EMPTY clause and a calculated member on the virtual cube...
|
|
|
|
Total Hits: 277 | Today: 0
|
|
Rating:
|
|
MSSQLServerADHelper is a service installed by the SQL Server Setup program that handles the Active Directory objects for all instances of the SQL Server relational database engine and all Analysis Manager applications that are running on the computer. There is only one MSSQLServerADHelper service on a computer for all of the instances of Microsoft SQL Server 2000.On computers that are running SQL Server 2000 Service Pack 1 (SP1), uninstalling all the instances of Microsoft SQL Server 2000 does n...
|
|
|
|
Total Hits: 678 | Today: 0
|
|
Rating:
|
|
When the database is set to compatibility level 70, a SELECT statement issued against a view that is built on multiple other views may result in the following error:
ODBC: Msg 0, Level 19, State 1
SqlDumpExceptionHandler: Process 51 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
An access violation (AV) will also be recorded in the SQL Server error log.
...
|
|
|
|
Total Hits: 1397 | Today: 3
|
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: 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..
|
|
|
|
|
|
