| 35817 | The Sqldumper.exe utility cannot generate a filtered SQL Server dump file when you use the Remote Desktop Connection service or Terminal Services to connect to a Windows 2000 Server-based computer in SQL Server 2000 |
| 35818 | The sp_droparticle stored procedure performs very slowly if the @immediate_sync property is set to TRUE in SQL Server 2000 Service Pack 4 |
| 35819 | Error message when you use the sp_addarticle stored procedure to add articles to an existing transactional replication publication in SQL Server 2000: “Cannot create a file when that file already exists” |
|
|
| 35820 | You may receive an assertion or database corruption may occur when you use the bcp utility or the Bulk Insert Transact-SQL command to import data in SQL Server 2000 |
| 35821 | A hotfix for Microsoft SQL Server 2000 Service Pack 4 may not update all the necessary files on an x64-based computer |
| 35822 | An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problems |
| 35823 | Database corruption occurs after you run the alter table Transact-SQL command to change a column from not null to null in Microsoft SQL Server 2000 |
| 35824 | Space is not released after you delete some rows from a table in SQL Server 2000 |
| 35825 | You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000 |
| 35826 | The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005 |
| 35827 | The effects of U.S. daylight saving time changes on the databases of some SQL Server editions |
| 35828 | The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005 |
| 35829 | In SQL Server 2000, the synchronization process is slow, and the CPU usage is high on the computer that is configured as the Distributor |
| 35830 | Error messages when you try to update table rows or insert table rows into a table in SQL Server 2000: 644 or 2511 |
| 35831 | You cannot connect to a local instance of SQL Server on a Windows XP-based computer or on a Windows 2000-based computer when you use localhost in the pipe name |
| 35832 | The merge agent fails intermittently when you use merge replication that uses a custom resolver after you install SQL Server 2000 Service Pack 4 |
| 35833 | Error 17883 is logged in the SQL Server error log, and the instance of SQL Server 2000 temporarily stops responding |
| 35834 | The password that you specify in a BACKUP statement appears in the SQL Server Errorlog file or in the Application event log if the BACKUP statement does not run in SQL Server 2000 |
| 35835 | The remote instance of SQL Server 2000 does not stop when you use SQL Server Management Studio on the server that is running SQL Server 2005 |
| 35836 | How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 |
| 35837 | CPU utilization may approach 100 percent on a computer that is running SQL Server 2000 after you run the BACKUP DATABASE statement or the BACKUP LOG statement |
| 35838 | SQL Server 2000 stops responding when you cancel a query or when a query time-out occurs, and error messages are logged in the SQL Server error log file |
| 35839 | Data in a subscriber of a merge publication in SQL Server 2000 differs from the data in the publisher |
| 35840 | Error message when you use XML functionalities against an instance of SQL Server 2000 after you upgrade an instance of SQL Server 2000 to SQL Server 2005: Failed to load msxmlsql.dll |
| 35841 | Error message when you run a full-text query in SQL Server 2000: Error: 17883, Severity: 1, State: 0 |
| 35842 | The instance of SQL Server 2000 performs slowly when you use SQL Profiler to perform a client-side trace of the events in the instance |
| 35843 | You may receive an access violation error message when you import data by using the Bulk Insert command in SQL Server 2000 |
| 35844 | Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: This application has failed to start because SQLResourceLoader.dll was not found |
| 35845 | Error message when you try to apply a hotfix on a SQL Server 2000-based computer that is configured as a MSCS node: An error in updating your system has occurred |
| 35846 | You cannot uninstall a SQL Server 2000 IA-64 hotfix and an error message is logged in the setup log file |
| 35847 | SQL Server performance counters may not appear when you use System Monitor to monitor the performance counters on a remote computer that is running SQL Server 2000 |
| 35848 | Error message when you run a distributed transaction on a SQL Server 2005-based or SQL Server 2000-based failover cluster: Resource Manager creation failed: result code = 0x8004d102 |
| 35849 | You must perform a full database backup before you back up the transaction log for a database in SQL Server 2005 and in SQL Server 2000 |
| 35850 | You may receive inconsistent comparison results when you compare strings by using a width sensitive collation in SQL Server 2000 |
| 35851 | You may experience one or more symptoms when you run a CREATE INDEX statement on an instance of SQL Server 2000 |
| 35852 | Error message when you try to change the SQL Server Agent proxy account in SQL Server 2000: The system cannot find the path specified |
| 35853 | You cannot connect to a named instance of SQL Server 2000 by using the shared memory protocol after you remove the default instance |
| 35854 | A different number of rows may be returned in the result set every time that you run a complex full-text search query in SQL Server 2000 |
| 35855 | Error message when you configure an immediate updating transactional replication in SQL Server 2000: Implicit conversion from datatype 'text' to 'nvarchar' is not allowed |
| 35856 | Error message when you schedule a Replication Merge Agent job to run after you install SQL Server 2000 Service Pack 4: The process could not enumerate changes at the 'Subscriber' |
| 35857 | A profiler trace in SQL Server 2000 may stop logging events unexpectedly, and you may receive the following error message: Failed to read trace data |
| 35858 | SQL Server significantly increases the unused space for some tables |
| 35859 | The query performance may be slow when you query data from a view in SQL Server 2000 |
| 35860 | The IIS process that runs the SQL Server 2000 Windows CE Edition 2.0 Server Agent may stop unexpectedly |
| 35861 | You cannot uninstall SQL Server 2000 build 2187 when SQL Server 2000 build 2187 is configured as a Microsoft Cluster Service (MSCS) node |
| 35862 | Hotfix files may not be copied to remote nodes when you install a 32-bit hotfix, and hotfix files may not be removed from remote nodes on a computer that is running SQL Server 2000 in an MSCS environment |
| 35863 | The synchronization process may take a long time when you synchronize merge replication publications in SQL Server 2000 |
| 35864 | Use of detours by a third-party solution is not supported with SQL Server |
| 35865 | You may receive an access violation error message when you run a linked server query that includes a subquery |
| 35866 | Query performance may decrease when you try to run a query in a parallel plan in SQL Server 2000 |
| 35867 | A SQL Server 2000 session may be blocked for the whole time that a Snapshot Agent job runs |
| 35869 | Error message when you try to run a query on a linked server in SQL Server 2000 |
| 35870 | Error message when you replicate a table to a SQL Server destination by using snapshot replication in SQL Server 2000: Bulk-copy commit failed (bcp_batch) ODBC message: SQLSTATE 37000, native error 4813 |
| 35871 | A memory leak occurs when you run a remote query by using a linked server in SQL Server 2000 |
| 35872 | Error message when you run the SQLDiag utility or the PSSDiag utility: Exception creating Perfmon log |
| 35873 | The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000 |
| 35874 | The query may return incorrect results, and the execution plan for the query may contain a Table Spool operator in SQL Server 2000 |
| 35875 | You may notice a decrease in performance when you run a query that uses the UNION ALL operator in SQL Server 2000 Service Pack 4 |
| 35876 | Each query takes a long time to compile when you execute a single query or when you execute multiple concurrent queries in SQL Server 2000 |
| 35877 | The bcp utility does not return the correct value of the %ERRORLEVEL% variable on some errors in SQL Server 2000 |
| 35878 | Hotfix files are not removed when you try to uninstall a SQL Server 2000 64-bit hotfix or a SQL Server 2000 Analysis Services 64-bit hotfix that you installed by using Windows Installer 2.0 |
| 35879 | An access violation may occur intermittently in the CQList::Remove function when you run a query in SQL Server 2000 |
| 35880 | The Audit Logout event does not appear in the trace results file when you run a profiler trace against a linked server instance in SQL Server 2000 |
| 35881 | SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer |
| 35882 | Error message when you try to install SQL Server 2000: Unable to validate product key |
| 35883 | The SQL Server process may end unexpectedly when you turn on trace flag -T1204 and a profiler trace is capturing the Lock:DeadLock Chain event in SQL Server 2000 SP4 |
| 35884 | You may experience heap corruption, and SQL Server 2000 may shut down with fatal access violations when you try to browse files in SQL Server 2000 Enterprise Manager on a Windows Server 2003 R2 x64-based computer |
| 35885 | You receive an access violation error message when you try to perform a read of a large binary large object column in SQL Server 2000 |
| 35886 | You cannot remotely connect to a named instance of SQL Server 2000 by using the TCP/IP protocol |
| 35887 | Error message when you use SQL Server 2000: Time out occurred while waiting for buffer latch type 3 |
| 35888 | How to configure SQL Server 2000 to use non-uniform memory access (NUMA) |
| 35889 | The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005 |
| 35890 | The database status changes to Suspect when you perform a bulk copy in a transaction and then roll back the transaction in SQL Server 2000 |
| 35891 | SQL Server 2000 may take a long time to complete the synchronization phase when you create a merge publication |
| 35892 | Error message when you run SQL Server 2000: Failed assertion = 'lockFound == TRUE' |
| 35893 | The DBCC SHRINKFILE statement has no effect when you run it after you run the DBCC SHRINKFILE statement together with the EMPTYFILE option in SQL Server 2000 |
| 35894 | Requirements for SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases |
| 35895 | You receive an error message when you run the Log Shipping Alert Job - Restore job in SQL Server 2000 |
| 35896 | The latest report in the archive is printed instead of the snapshot of the archived report in SQL Server 2000 |
| 35897 | The transaction takes longer than expected to finish when you try to insert rows into a SQL Server 2000 database |
| 35898 | Error message when you run a complex insert query or a stored procedure in SQL Server 2000: Internal SQL Server error |
| 35899 | The SQL Server database crashes, and you receive an error message when you run a complex query against SQL Server 2000 |
| 35900 | Error message when you install SQL Server 2005: Beta components detected |
| 35901 | An access violation may occur when you run a query on a table that has a multicolumn index in SQL Server 2000 |
| 35902 | Programs that use other instances of SQL Server 2000, MSDE 2000, or SQL Server 2000 Desktop Engine (Windows) may fail when you remove an instance of SQL Server 2000, MSDE 2000, or SQL Server 2000 Desktop Engine (Windows) |
| 35903 | A query may run more slowly against SQL Server 2000 post-SP3 hotfix build 8.00.0988 than a query that you run against SQL Server 2000 post-SP3 hotfix builds that are earlier than build 8.00.0988 |
| 35904 | You can enable the lock pages in memory permissions to prevent SQL Server 2005 64-bit buffer pool memory from being paged out of physical memory |
| 35905 | You may receive an error message, and the SQL Server process may crash when you copy or transfer SQL Server 2000 data |
| 35906 | SQL Server 2000 64-bit eagerly acquires the amount of memory that is specified in the min server memory configuration option |
| 35907 | You may intermittently experience an access violation error when a query is executed in a parallel plan and the execution plan contains either a HASH JOIN operation or a Sort operation in SQL Server 2000 |
| 35908 | Describes the problem where an error message is generated when you use SQL Server 2005 Reporting Services or SQL Server 2000 Reporting Services to generate HTML reports in Microsoft Operations Manager 2005. Install hotfix to resolve this problem. |
| 35909 | Discusses ownership chaining in SQL Server 2000. Also describes how chaining is broken if you use the Execute command with parentheses characters (( )). |
| 35910 | When a SAVE TRANSACTION statement is attempted within a distributed transaction, the following error message occurs: Error: 627 level 16 cannot use Save Transaction within a distributed transaction. To allow application migration from Microsoft... |
| 35911 | Describes a problem that occurs when you try to perform a Bulk Import operation to transfer data from a file to a SQL Server table, and an access violation exception occurs. Includes a hotfix that you can install to resolve the problem. |
| 35912 | If the TMP environment variable is changed to a nonexisting directory, SQL Server Profiler may fail to run a new trace, and will result in the following message: Failed to start a new trace SQL Server Profiler allocates temporary storage files... |
| 35913 | This article discusses a fix for a problem that causes extended stored procedures to take a long time to run under stress conditions when multiple users run extended stored procedures at the same time. |
| 35914 | If a transactional publication has a table with a self-referencing foreign key, and the table article is configured to include declared referential integrity in a snapshot, the Distribution Agent fails while trying to reapply the snapshot after... |
| 35915 | The initial snapshot may fail when applied at the subscriber if the publication contains an article that uses a user defined function as a computed column. The error message that occurs is: Error 208: 'Invalid object name %function_name%' The... |
| 35916 | When you configure a replication job not to run continuously, and you then run the job, the job history displays that the job is complete. However, the replication job might still appear to run continuously, and the agent process for the... |
| 35917 | This step-by-step article describes how to implement bidirectional transactional replication. This article also discusses the issues that are involved in implementing bidirectional transactional replication. back to the top Bidirectional... |
| 35918 | Fixes a problem in SQL Server 2000 where you receive an access violation when you use the READPAST lock hint to query a table. |
| 35919 | Fixes a problem where you receive an error message when you repeatedly create and destroy an out-of-process COM objects within the same batch or stored procedure in SQL Server 2000. |
| 35920 | When you use the Microsoft SQL Server CE Query Analyzer tool to connect to a SQL Server CE database and you run the following query, the data types are represented by numbers instead of by a description: SELECT data_type FROM... |
| 35921 | Describes how to move Microsoft Provisioning Server (MPS) databases to a clustered virtual SQL Server 2000 named instance. |
| 35922 | SQL Server 2000 might produce an incorrect cardinality estimate for outer joins. For queries that involve an outer join, this incorrect cardinality estimation can lead to query plans that perform poorly. Service pack information Microsoft SQL... |
| 35923 | In read-committed transaction isolation level, which is the default in SQL Server, the Intent share (IS) lock on data pages that are held by a transaction may not be released, even after the commit or rollback, of the same. This behavior is... |
| 35924 | Explains that you cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive. Provides a method to work around this issue. |
| 35925 | Error messages are logged in the SQL Server error log when you use SQL Server 2000 on a computer that is running Windows 2000 Server Service Pack 4 or Windows Server 2003 |
| 35926 | You may receive error messages when you use linked servers in SQL Server 2000 on a 64-bit Itanium processor |
| 35927 | How to obtain the SQL Server Runtime license |
| 35928 | Merge replication results are incorrect or merge replication fails when you try to use merge replication to merge SQL Server 2005 Mobile Edition data with SQL Server 2000 data |
| 35929 | Key factors to consider when evaluating third-party file cache systems with SQL Server |
| 35930 | You receive an access violation error message when a user-defined function is in a high-stress scenario in SQL Server 2000 |
| 35931 | Microsoft SQL Server I/O subsystem requirements for the tempdb database |
| 35932 | You receive an error message when a Visual Basic application opens a dynamic cursor on a GROUP BY query in SQL Server 2000 Service Pack 4 |
| 35933 | You may experience slow server performance when you start a trace in an instance of SQL Server 2000 that runs on a computer that has more than four processors |
| 35934 | A view is corrupted after you run the DBCC DBREINDEX Transact-SQL statement to rebuild the clustered index on a view in SQL Server 2000 |
| 35935 | Warning message when you try to deploy a SQL Server CE 2.0 application in Visual Studio 2005: The program is from an unknown publisher You should install it only if you trust its publisher |
| 35936 | Error message when you try to install SQL Server 2000 Service Pack 4 on a SQL Server 2000 cluster: Scm.exe -Silent 1 -Action 1 -Service MSSQLSERVER -StartupOptions \-T4022 \-T4010 \-m |
| 35937 | A 17883 error may occur you run a query that uses a hash join in SQL Server 2000 |
| 35938 | You may receive an error message when you try to use a Japanese user name or a Korean user name to connect to an Analysis Services server |
| 35939 | The MSDE writer is not included when you try to use the Vssadmin.exe tool to list subscribed volume shadow copy writers |
| 35940 | An access violation may occur when you try to run a Transact-SQL query in SQL Server 2000 |
| 35941 | Error message 17883 may be logged in the error log when you try to manually update table statistics in SQL Server 2000 |
| 35942 | You may receive incorrect results when you run a Transact-SQL query in SQL Server 2000 |
| 35943 | You may receive an error message when you set the database collation to Thai_CI_AS and you try to run a Transact-SQL update query in SQL Server 2000 |
| 35944 | How to build an OLE DB application for SQL Server CE in Visual Studio 2005 |
| 35945 | Error message when you open SQL Server Enterprise Manager after you uninstall the SQL Server 2005 Backward Compatibility Components: Snap-in failed to initialize |
| 35946 | Error message when you run the SQL Server Upgrade Wizard to upgrade SQL Server 6.5 to SQL Server 2000 SP4: Couldn't create or register the SQLUpgrade DSN |
| 35947 | Error message when you use a loopback linked server to run a distributed query in SQL Server 2000: Could not perform the requested operation because the minimum query memory is not available |
| 35948 | Error message when you run the sp_databases stored procedure in SQL Server 2000: Arithmetic overflow error converting expression to data type int |
| 35949 | You may receive an Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action error message when you run a SQL Server Agent job in SQL Server 2000 |
| 35950 | Automatic checkpoints on some SQL Server 2000 databases do not run as expected |
| 35951 | No rows may be returned, and you may receive an error message when you try to import SQL Profiler trace files into tables by using the fn_trace_gettable function in SQL Server 2000 |
| 35952 | When you query a view that was created by using the VIEW_METADATA option, an access violation may occur in SQL Server 2000 |
| 35953 | Microsoft does not certify that third-party products will work with SQL Server |
| 35954 | You receive an error message when you try to rebuild the master database after you have installed hotfix builds in SQL Server 2000 SP4 64-bit |
| 35955 | You receive an error message when you try to delete records by running a Delete Transact-SQL statement in SQL Server 2000 |
| 35956 | An error message is logged, and new diagnostics do not capture the thread stack when the SQL Server User Mode Scheduler (UMS) experiences a nonyielding thread in SQL Server 2000 Service Pack 4 |
| 35957 | An error occurs when you try to access the Analysis Services performance monitor counter object after you apply Windows Server 2003 SP1 |
| 35958 | Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Server |
| 35959 | The SQL Server service cannot start when you change a protocol parameter for a clustered instance of SQL Server 2000 or of SQL Server 2005 to a value that is not valid |
| 35960 | Early implementations of the Merge Agent did not use the sp_executesql system stored procedure during the execution of statements that could be repeatedly run each time the Merge Agent ran. To improve the chances of re-using an existing plan (and... |
| 35961 | Fixes an issue where you receive an error message when you try to run a full-text search on an instance of SQL Server 2000 that is running on a Windows 2000-based computer. |
| 35962 | Error message when you use the Volume Shadow Copy Service (VSS) to back up SQL Server 2000 database files or SQL Server 2000 Desktop Engine (MSDE) database files: 'MSDEWriter' has reported an error 0x800423f4 |
| 35963 | It takes a long time for the SQL Server service to start on a Windows Server 2003-based computer |
| 35964 | Error message when you run an UPDATE statement that uses two JOIN hints to update a table in SQL Server 2000: Internal SQL Server error |
| 35965 | SQL Server incorrectly returns rows that have a NULL value when you try to filter non-Unicode data columns for records from a table |
| 35966 | You may not be able to apply SQL Server 2000 64-bit post SP4 hotfix build 8.0.2156 or a later build after you use Windows Installer 2.0 to apply a SQL Server 2000 post SP4 hotfix that is earlier than build 8.0.2155 |
| 35967 | You may receive an error message after you set the DownloadGenerationsPerBatch Merge Agent parameter to a large value in SQL Server 2000 Windows CE Edition 2.0 |
| 35968 | Error message when you run the sp_helpfile stored procedure in SQL Server 2005 or in SQL Server 2000: Arithmetic overflow error converting expression to data type int |
| 35969 | Describes how to use the Findstr tool to scan SQL error log files or DBCC output files to analyze errors. Provides some examples to demonstrate how to use the tool. |
| 35970 | Describes a problem that occurs when you you run a maintenance plan or a command that examines the integrity of the SQL Server 2000 database. You may receive the Server: Msg 8929 error message or the Server: Msg 8968 error message. |
| 35971 | Explains that you receive an Error 14114:(NULL) is not configured as a distributor error message when you try to set up a server that is running SQL Server as a distributor for replication. Provides steps to work around this problem. |
| 35972 | Error message when you try to open SQL Server 2000 Data Transformation Services (DTS) packages in SQL Server Management Studio: SQL Server 2000 DTS Designer components are required to edit DTS packages |
| 35973 | A cumulative hotfix package is available for SQL Server 2000 Service Pack 4 build 2162 |
| 35974 | Cumulative list of the hotfixes that are available for SQL Server 2000 SP4 |
| 35975 | You receive an error message when you run SQL Server Setup to install SQL Server 2000 Service Pack 4 in binary-only mode on a failover cluster |
| 35976 | How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database |
| 35977 | The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server 2000 instance that hosts the BizTalk Server 2004 BizTalkMsgBoxDB database or the BizTalk Server 2006 BizTalkMsgBoxDB databas |
| 35978 | You may receive messages that state that the computer is out of memory when you run Virtual Server 2005 and SQL Server 2000 as peer applications on the same computer |
| 35979 | When you use a Data Transformation Services (DTS) Transfer Logins Task to move a SQL Server login that is based on a local Microsoft Windows NT account, the DTS package fails with this error message: Unspecified Error. Here is an example of the... |
| 35980 | You deploy SQL Server 2000 by using the hard disk image of another computer where SQL Server 2000 is installed. If you use SQL Server Enterprise Manager to configure a replication distributor, the configuration of the distributor may not be... |
| 35981 | A stack overflow exception occurs in the merge replication reconciler DLL, Replprov.dll, when the thread stack size is smaller than 1 megabyte. |
| 35982 | Describes a problem that occurs when you specify an outage period for out-of-synchronization messages in Log Shipping Monitor in Microsoft SQL Server 2000 Enterprise Edition. |
| 35983 | Describes late-breaking changes in SQL Server 2000 Service Pack 4 (SP4) that are not documented in the readme files. |
| 35984 | When you use SQL Server Enterprise Manager to attach multiple database files, which are saved on different hard disk driver folders, the following problems may occur: If you create a database for some of the log or data files that are stored in a... |
| 35985 | The Microsoft SQL Server Books Online documentation refers to an option that may be chosen in the SQL Enterprise Manager to autostart SQL Mail. This option does not exist in the SQL Server 2000 Enterprise Manager. SQL Server 2000 automatically... |
| 35986 | Discusses two alternative approaches for a disaster recovery plan for transactional replication. Explains the problem in the SQL Server Books Online approach, and provides two methods to overcome the problem of latency. |
| 35987 | While a Microsoft Decision Support Objects (DSO) program can read the EstimatedRows property of the Aggregation class in the DSO library and assign a new value without receiving an error message, the value is not stored. This prevents OLAP... |
| 35988 | Following is part 2 of a list of fixes and various other improvements that have been made in Service Pack 1 (SP1) for Microsoft SQL Server 2000. For more information, contact your primary support provider. For additional listings, click the... |
| 35989 | Analysis Services may set the EstimatedRows property for a particular aggregation in a partition to zero, if the number of dimension members in a cube is large. The EstimatedRows property is used by the Aggregation Design Wizard when it evaluates... |
| 35990 | Aggregate functions may return incorrect results in a query that has a correlated subquery. The showplan for the query will show a spool operation followed by a nested loop join. SQL Server 2000290211INF: How to Obtain the Latest SQL Server 2000... |
| 35991 | The execution of a stored procedure that includes the following statement to update a remote table over a linked server does not work correctly: UPDATE [RemoteServer].pubs.dbo.RemoteTable SET Name = @Name WHERE MyID = @ID When the stored procedure... |
| 35992 | Fixes a problem in SQL Server 2000 Service Pack 3 (SP3) where a query is canceled and you receive a Msg 8649 error message when you execute the DBCC CHECKDB statement. |
| 35993 | A maintenance plan job to backup transaction logs may fail. The Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1' job history may show the following error message: The job failed. The Job was invoked by Schedule 3... |
| 35994 | Explains that the osql utility (Osql.exe) does not completely run a Transact-SQL script if you log off the console session of the computer. Requires that you install a hotfix to resolve this problem. |
| 35995 | Describes a problem that occurs when the MSSQLServer service exits unexpectedly in SQL Server 2000 SP3. Includes a hotfix to resolve the problem. |
| 35996 | When you run an encrypted stored procedure that contains a dynamic query, and you have turned on the SET STATISTICS PROFILE option, the dynamic query statement or statements may appear in the execution plan of the encrypted stored procedure. |
| 35997 | An access violation (AV) may be raised upon the execution of a stored procedure that has the following properties: The stored procedure receives a parameter of type TEXT.The TEXT parameter is used in the declaration of a cursor.The cursor... |
| 35998 | Explains that when you run a SQL Server CE OLE DB application, and then you access data in a specified range, you may receive incorrect results. |
| 35999 | When using the SQL Server ODBC driver or SQL Server OLEDB provider (SQLOLEDB), a large SQL statement (where the length of the SQL statement exceeds 5 MB) may fail to execute. No error is reported to the client application when this specific... |
| 36000 | Describes a problem that occurs when you add a column to a published article or drop a column from a published article, and the Distribution Agent may not run successfully. Includes a hotfix that you can use to resolve the problem. |
| 36001 | Fixes a problem in SQL Server 2000 where full-text searches are not returned and latch time-out errors are written to the error log when you stop a full-text search. |
| 36002 | An access violation occurs when you try to access SQL Server on a computer that is running under low memory conditions. To resolve this problem, apply the hotfix that is discussed in this article. |
| 36003 | If you try to insert a binary large object (BLOB), such as a Microsoft Word document, into a table that uses the bulk copy program or BULK INSERT, one or both of the following error messages may occur: Server: Msg 4832, Level 16, State 1, Line 1... |
| 36004 | This article discusses a corruption problem that occurs when SQL Server transfers data to a sql_variant column that contains character data. To resolve the problem, use the hotfix that is provided in this article. |
| 36005 | NOTE : This only applies to Microsoft SQL Server 2000 Spanish version. The installation of the Spanish version of SQL Server 2000 may fail with the following error message: Se produjo un error que impide realizar un correcto cambio de version.... |
| 36006 | An abort of a Microsoft Distributed Transaction Coordinator (DTC) transaction during tempdb activity, may result in 7105 errors, retail assertions, and potentially a failure during rollback in tempdb that may cause the server to shutdown.... |
| 36007 | Describes a problem that occurs when the Microsoft Distributed Transaction Coordinator (MSDTC) is not available when you connect to SQL Server in a SQL Server 2000 clustered environment. |
|
|
| 36008 | Lists the fixes that are included with SQL Server 2000 Service Pack 4. |
| 36009 | When you run a query that references a derived table or a view that is defined by a query that contains a LEFT OUTER JOIN clause, the query execution plan may display an incorrect row count estimate for the filter condition in the query. This... |
| 36010 | When you upgrade from the SQL Server 2000 Desktop Engine to the SQL Server 2000 (Personal, Standard, or Enterprise editions), you are prompted to install additional components. If you select NO, and then complete the upgrade process, only the... |
| 36011 | When you install a default or a named instance of SQL Server 2000 on a failover cluster, the setup might fail, and you receive the following error message: Setup failed to perform required operations on the cluster nodes. This problem may also... |
| 36012 | SQL Server 2000 includes sp_trace_create , a system stored procedure that you can use to start a trace. By default, the sp_trace_create stored procedure creates a trace that is written by the server to a specified file. If the specified file is on... |
| 36013 | Fixes a performance issue that occurs in SQL Server 2000 when a trigger execution plan recompiles repeatedly. Explains that the recompilation occurs when the number of rows that are modified by a DML statement that fire the trigger changes. |
| 36014 | When you run a full-text query on a computer that is running Microsoft SQL Server 2000 Service Pack 3 (SP3), the query may not be successful if all the following conditions are true: The full-text query contains full-text predicates (such as... |
| 36015 | Lists the public SQL Server 2000 post-Service Pack 3 and Service Pack 3a hotfixes by build number. |
| 36016 | When you use the ExportData method of the BulkCopy object from SQL Distributed Management Objects (SQL-DMO), and the name of the database that you use in the method contains a space (for example, My Database ), you receive the following error... |
| 36017 | Describes a problem that occurs when you open a database in SQL Server, and the database is marked as suspect. Includes a hotfix to resolve the problem. |
| 36018 | The @date_received parameter incorrectly returns a timestamp that corresponds to the e-mail message submitted by the sender instead of the recipient. To resolve this behavior, install the hotfix that is discussed in this article. |
| 36019 | The Database Maintenance Planner is used to schedule jobs to back up a database and its transaction log. The job to back up the database succeeds, but the job to back up the transaction log fails. When you view the job history, you see a message... |
| 36020 | The Aging Execution Plans section in the Execution Plan Caching and Reuse topic of SQL Server Books Online incorrectly states that each time a query plan that resides in the procedure cache is referenced by a connection, the age field of the... |
| 36021 | When SQL Server tries to compile a plan for a complex query, you might receive the following error message: Server: Msg 8623, Level 16, State 1, Line 1 Internal Query Processor Error: The query processor could not produce a query plan. Contact... |
| 36022 | A query that uses the ISNULL function for a predicate on a column with statistics may result in: Poor estimation by the optimizer. -and-Suboptimal query performance. When you review the execution plan, you may find that the EstimateRows value is... |
| 36023 | Describes a problem that occurs when you try to run a complex query on an instance of SQL Server, and you receive an 8623 error message. Includes a hotfix that you can install to resolve the problem. |
| 36024 | You cannot administer Full Text Search (FTS) from SQL Server Enterprise Manager (SEM) from a client computer when you are using a local user account to log on to the computer. This behavior occurs even if you connect to SQL Server with the sa... |
| 36025 | When you are running a stored procedure with a dynamic execution query ( sp_executesql or EXECUTE), you may receive the following error message: Server: Msg 229, Level 14, State 5, Line 1 'permission' permission denied on object 'object', database... |
| 36027 | UPDATE or DELETE statements that act against a remote table that resides on a non-SQL Server data source, may run much slower than an equivalent SELECT statement. For linked server DELETEs or UPDATEs, SQL Server retrieves data from the table,... |
| 36028 | After you successfully register the SQL Server 2000 Distributed Management Objects (SQL-DMO) DLLs in an environment with the SQL Server 7.0 Client tools installed, when you start SQL Server 7.0 Enterprise Manager (SEM), you may receive the... |
| 36029 | When you use the Display Estimated Execution Plan option in Query Analyzer, with several queries submitted, the graphical plan may show step optimization costs greater than 100%. The particular query that reproduces this problem is too large and... |
| 36030 | Discusses using SQL Server in a hyper-threaded environment. |
| 36031 | When using Data Transformation Services (DTS) to transfer columns with the same name, the transformation fails. For example, using the following query to transfer data from the pubs database with two or more columns named city will prevent the... |
| 36032 | On a busy server it may take several seconds to stop or start one of the SQL Server services by using the SQL Server Service Manager. If the SQL Server Service Manager is opened and the control buttons are used to start or stop a service, all the... |
| 36033 | The SQL Server Enterprise Manager server-state polling may generate the following errors in the Cluster log file: 00000574.00000dc0::2002/07/27-23:28:09.671 [API] Dump the ClientToken that failed... 00000574.00000dc0::2002/07/27-23:28:09.671 [API]... |
| 36034 | If you try to change the SQL Server startup account in SQL Enterprise Manager (SEM) to an account that uses the User Principal Names (UPN) format (for example, user@domain), you receive the following error message: The login account is invalid. It... |
| 36035 | SQL Server databases are not supported on NTFS or FAT compressed volumes. A compressed volume does not guarantee sector-aligned writes, which is needed to ensure transactional recovery in some circumstances. In addition, performing a SQL Server... |
| 36036 | You may experience the following symptoms in SQL Server: A database does not expand automatically although you have the autogrow option on.The Errorlog file does not contain any messages that indicate that the database is full.Client computers... |
| 36037 | When you use bulk operations such as the bcp command-line utility, BULK INSERT Transact-SQL statements, the bulk copy API, or SQL Server Data Transformation Services (DTS), to load data into tables that participate in merge replication, unless... |
| 36038 | If a database that is running in SQL Server 6.5 or SQL Server 7.0 compatibility mode is detached or backed up from a SQL Server 7.0 server and then attached or restored to a SQL Server 2000 server, the original compatibility mode is preserved in... |
| 36039 | In SQL Server 7.0 and SQL Server 2000, with the autogrow setting, transaction log files can expand automatically. Typically, the size of the transaction log file stabilizes when it can hold the maximum number of transactions that can occur between... |
| 36040 | When you open a view from the SQL Server Enterprise Manager (SEM) Design View tool, some column names in the SELECT statement of your view may contain spaces before and after certain characters. If this occurs, the column names prevent Enterprise... |
| 36041 | When you attempt to perform a database upgrade with the Upgrade Wizard, the SQL Server Upgrade Script Interpreter screen displays a message box at the point of EXPORT and IMPORT VIA NAMED PIPES titled Informational Files Found . The message box... |
| 36042 | After you clear the Store user independent check box in SQL Server Enterprise Manager (SEM) in the Tools|Options dialog box and then register a new SQL Server, when other users log on to this computer they will be able to see the previously... |
| 36043 | Open Database Connectivity (ODBC) Tracing can be used to trace calls to ODBC functions from ODBC applications. The ODBC Driver Manager can trace calls continuously or for one connection only, can perform tracing dynamically, or can allow tracing... |
| 36044 | The Data area passed to a system call is too small error message is logged when you call the CreateEx method at the same time in a multiple-thread application that uses the Virtual Device Interface feature of SQL Server 2000 |
| 36045 | Login names that contain leading zero characters are not visible when you use SQL Profiler to audit connections to SQL Server 2000 |
| 36046 | You may experience concurrency issues when you run the DBCC INDEXDEFRAG statement in SQL Server 2000 |
| 36047 | You may receive the Server Msg 8630, Level 17, State 34, Procedure TableName, Line nn error message when you try to delete records from a table that has FOREIGN KEY constraints on many tables in SQL Server 2000 with Service Pack 4 |
| 36048 | You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server |
| 36049 | In SQL Server 2000 Service Pack 2 (SP2), when you run a SQL Profiler trace that includes RPC events ( RPC:Starting or RPC:Completed ), a statement that includes a bit parameter that has a value that is greater than 9 causes an access violation in |
| 36050 | If you run a Transact-SQL INSERT statement that tries to insert a row in a table that is referenced in several indexed views, an access violation exception may occur. When the access violation exception occurs, SQL Server terminates the client... |
| 36051 | After you upgrade to SQL Server 2000 Service Pack 3, the SQL Server query optimizer may incorrectly estimate the cost for queries that involve a predicate that uses a NOT EXISTS (subquery) construct. The estimate will be too high, and results in... |
| 36052 | If transaction log stalls occur, a computer running SQL Server may experience CPU usage that was not expected. This usage occurs because of poor log file performance or because database backups are in progress. Service pack information Microsoft... |
| 36053 | The results are different every time that you run a complex query that contains a hash outer join operator in SQL Server 2000 |
| 36054 | You receive an Error 14269 error message when you try to modify the SQL Server Agent job if the combination of the computer name and the instance name is more than 30 characters in SQL Server 2000 |
| 36055 | The Mail Profile combo box is disabled when you use Enterprise Manager to view SQL Server agent properties, and you receive an error message when you try to use the xp_sendmail stored procedure from a DTS package in SQL Server 2000 |
| 36056 | How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 |
| 36057 | An Error 17883 error message may be logged, and SQL Server 2000 or SQL Server 7.0 may stop responding when you run an application that creates COM objects by using the sp_OACreate function |
| 36058 | You receive a Failed to open a table error message when you try to open a trace table by using SQL Profiler after you upgrade to SQL Server 2000 Service Pack 4 |
| 36059 | Fixes the access violation exception that occurs when you run the DBCC FREEPROCCACHE Transact-SQL statement on a linked SQL server and you connect to the linked SQL server by using remote access. |
| 36060 | An access violation may occur when a deadlock graph is written to the error log in SQL Server 2000 |
| 36061 | SQL Server 2000 may experience errors and stop responding, and error messages may be logged in the SQL Server 2000 error log, when you try to perform a write operation that is not logged |
| 36062 | Unsupported tuning options for some editions of SQL Server 2005 CTP 16 and of SQL Server 2000 |
| 36063 | You may receive a “Server: Msg 7358, Level 16, State 1, Line 1” error message after you run a linked server query in SQL Server 2000 Service Pack 4 |
| 36064 | The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database |
| 36065 | The installation process may fail when you try to install SQL Server 2000 Service Pack 4 |
| 36066 | You receive error messages when you try to back up a SQL Server 2000 database to a tape drive after you format and use the tape drive for backups in Windows Server 2003 |
| 36067 | You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems |
| 36068 | The batch job stops running, and job output is truncated when you run a Transact-SQL script as a SQL Server Agent job in SQL Server 2000 |
| 36069 | A stack overflow exception may occur, and SQL Server 2000 may unexpectedly close when you submit a query that uses the UNION ALL operator more than 255 times |
| 36070 | The blocked column in the sysprocesses table is populated for latch waits after you install SQL Server 2000 SP4 |
| 36071 | Checkpoint resumes the behavior that it exhibited before you installed SQL Server 2000 SP3 when you enable trace flag 828 on a computer that is running SQL Server 2000 SP4 |
| 36072 | The Mssdmn.exe process may use lots of CPU capacity when you perform a SQL Server 2000 full text search of Office Word documents |
| 36073 | You receive an “Error: 8526, Severity: 16, State: 2” error message in SQL Profiler when you use SQL Query Analyzer to start or to enlist into a distributed transaction after you have installed SQL Server 2000 SP4 |
| 36074 | The error message that the SELECT statement returns may contain user data in SQL Server 2000 |
| 36075 | Event ID 20 Volume Shadow Copy Service error is logged when you back up the System State on a Windows Server 2003 x64 Edition-based computer that is running SQL Server 2000 |
| 36076 | The PKM Search Filter Daemon (Mssdmn.exe) may unexpectedly crash when you parse Office Word documents in SQL Server 2000 |
| 36077 | Queries against indexed views may run slower when you install a SQL Server 2000 post-SP3 hotfix, a SQL Server 2000 post-SP3a hotfix, or SQL Server 2000 SP4 |
| 36078 | The results of the query may be returned much slower than you expect when you run a query that includes a GROUP BY statement in SQL Server 2000 |
| 36079 | You receive a Getting registry information message when you run the Sqldiag.exe utility after you install SQL Server 2000 SP4 |
| 36080 | You receive a This service pack is meant for a different language than your installed product error message when you try to install a SQL Server 2000 service pack |
| 36081 | An application that uses the Virtual Device Interface feature of SQL Server 2000 to back up a SQL Server 2000 database may not back up the database |
| 36082 | Only the master database and the tempdb database are listed when you try to create a new job in SQL Server Enterprise Manager |
| 36083 | A Failed to reserve contiguous memory error message may be logged in the SQL Server error log when users connect to an instance of SQL Server by using a network packet size that is larger than 8,060 bytes |
| 36084 | The UPDATE query blocks the SELECT query when you run an UPDATE query and a SELECT query at the same time in SQL Server 2000 |
| 36085 | You receive an error message when you use the sp_addalias or sp_dropalias procedures and the IMPLICIT_TRANSACTIONS option is set to on in SQL Server 2000 SP4 |
| 36086 | You experience slow performance when you back up the database in SQL Server 2000 |
| 36087 | The Snapshot Agent fails and a The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION error message may be logged in the Distribution Agent log in SQL Server 2000 |
| 36088 | A trace file may be reported as corrupted and contains a 128 KB region of zeros in SQL Server 2000 |
| 36089 | SQL Server 2000 may load an incorrect certificate when the ClusterName value is longer than the ClusterIpAddr value |
| 36090 | An access violation occurs in the Mssdi98.dll file, and SQL Server crashes when you use SQL Query Analyzer to debug a stored procedure in SQL Server 2000 Service Pack 4 |
| 36091 | SQL Server 2000 may intermittently appear to stop responding (hang) during a scheduled maintenance DBCC DBREINDEX operation |
| 36092 | Service Pack 3a for Microsoft SQL Server 2000 April 9, 2003 |
| 36093 | Implications of removing the xp_cmdshell stored procedure from SQL Server 2000 |
| 36094 | The subquery in a CASE function is evaluated even if the condition in the WHEN expression is false in SQL Server 2000 |
| 36095 | You may receive an exception access violation for the Ssnetlib.dll file in SQL Server 2000 |
| 36096 | The TextData column may be empty for the SP:StmtStarting, SP:StmtCompleted, SQL:StmtStarting, and SQL:StmtCompleted events when you use SQL Profiler to capture SQL Server traces in SQL Server 2000 |
| 36097 | The Subscriber may not be able to upload changes to the Publisher when you incrementally add an article to a publication in SQL Server 2000 SP3 |
| 36098 | The SQL Server 2000 automatic database recovery operation may not succeed if an index contains a FLOAT data type or a REAL data type, and this data type contains a NaN value |
| 36099 | Event ID: 208 may be logged, and a DBCC failed error message is logged when you try to use the Database Maintenance Plan Wizard to create a maintenance plan in SQL Server 2000 |
| 36100 | The Full Text resource fails when you install a new clustered instance after you apply SQL Server 2000 Service Pack 4 to an existing clustered instance |
| 36101 | Some 32-bit applications that use SQL-DMO and SQL-VDI APIs may stop working after you install SQL Server 2000 Service Pack 4 on an Itanium-based computer |
| 36102 | You receive incorrect results when you run a query that uses a cross join operator in SQL Server 2000 SP3 |
| 36103 | A query that involves data that is the numeric data type may return incorrect results in SQL Server 2000 SP3 and in earlier SQL Server 2000 service packs |
| 36104 | Query performance may be slower if the query contains both a GROUP BY clause and a DISTINCT keyword on the same column |
| 36105 | A memory leak may occur when a client application uses the Dbmslpcn.dll shared memory network library version 2000.80.828.0 and connects to a local computer that is running SQL Server 2000 |
| 36106 | You experience slow performance when you join local partitioned views with a table in SQL Server 2000 |
| 36107 | TechNet Support WebCast: Tips for MDX Tuning |
| 36108 | Permissions do not appear in the sysprotects table or in the output of the sp_helprotect stored procedure when you grant the permissions to an object in SQL Server 2000 |
| 36109 | Server Network Utility may display incorrect protocol properties in SQL Server 2000 |
| 36110 | 17883 errors may be written to the SQL Server error log when you run a query that generates many floating point exception errors in SQL Server 2000 |
| 36111 | An access violation may occur when you run a SELECT query and the NO_BROWSETABLE option is set to ON in Microsoft SQL Server 2000 |
| 36112 | You may experience performance issues when you use SQL Server Distributed Management Objects (SQL-DMO) components in a multithreaded environment |
| 36113 | You experience delays and receive a 17883 error message when SQL Server 2000 performs a large and complex query plan that uses hash operators on a 64-bit computer that has 16 GB or more GB of physical RAM |
| 36114 | A BizTalk Server Host instance fails and a General Network error is written to the Application log when the BizTalk Server-based server processes a high volume of documents |
| 36115 | The -skipperrors Distribution Agent parameter for SQL Server 2000 may skip more commands than expected |
| 36116 | Changes to SQL Server 2000 Service Pack 4 operating system support |
| 36117 | The installation may fail when you try to install SQL Server 2000 hotfix build 8.00.0977 on a clustered or a stand-alone server computer that has large number of databases |
| 36118 | You receive an Incorrect syntax near ')' error message when you run a script that was generated by SQL-DMO for an Operator object in SQL Server 2000 |
| 36119 | You may receive error message 701, error message 802, and error message 17803 when many hashed buffers are available in SQL Server 2000 |
| 36120 | The return data type depends on the location of a UNION operation where char and varchar data types are combined in SQL Server 2000 |
| 36121 | Explains that the removal of a SQL Server login account that owns one or more jobs by the members of the securityadmin fixed server role does not cause any errors or warnings. Provides the cause and guides you with a workaround for the problem. |
| 36122 | When you run a distributed transaction against a linked server in SQL Server 2000 on a computer running Windows Server 2003, Enterprise Edition, you may receive the following error message: Server: Msg 7391, Level 16, State 1, Line 2 The operation... |
| 36123 | When you try to restore a database backup, the restoration may fail, and a retail assertion with error 3624 may occur. You may see the following error message in the SQL Server error log files as a result of the assertion error: SQL Server... |
| 36124 | Explains that you receive an error message when you try to run an Oracle procedure from a computer that is running Microsoft SQL Server 2000 by using MSDAORA provider by creating a linked server. |
| 36125 | Describes a problem where SQL Server 2000 cluster setup on Windows Server 2003 cluster nodes may fail with an error when the Winreg registry key is not assigned the correct permissions on the cluster nodes. |
| 36126 | Explains that you may receive an error message if you use the full-text search service on an instance of SQL Server 2000 on a computer that is running Windows XP SP2. Includes two workarounds to work around this problem. |
| 36127 | This article describes a problem that occurs when a client tries to query lots of data with a large packet size connected over a VIA protocol. |
| 36128 | If Exchange 2000 and SQL Server 2000 are installed on the same computer, you receive the following error message when you attempt to use the RecordSet-MoveNext() function within ActiveX Data Objects (ADO) code . The error consistently occurs when... |
| 36129 | Describes a problem that occurs when you try to attach a database that contains more than 16 files to an instance of SQL Server 2000, and an 8144 error occurs. |
| 36130 | Describes an issue that occurs if SQL Server 2000 is configured to use Windows Authentication Mode authentication instead of Mixed Mode authentication. |
| 36131 | Fixes a problem in SQL Server 2000 that occurs when you run a query that contains a RIGHT OUTER JOIN clause. When you do this, an access violation occurs. |
| 36132 | Describes a problem that occurs when you start the MDX sample application in SQL Server 2000, and you receive an Unable to open connection error message. |
| 36133 | Under rare conditions, you may recieve the following error message when you run a query with an aggregate function: Msg 3628, Level 16, State 1A floating point exception occurred in the user process. Current transaction is canceled. If you drop... |
| 36134 | When you use the Uninstall option to remove SQL Server 2000, it does not remove all the previously installed files. Service pack information Microsoft SQL Server 2000290211How to obtain the latest SQL Server 2000 service packTo resolve this... |
| 36135 | Describes a problem in SQL Server 2000 where you receive an error message when your .NET Framework client application sets the size of a stored procedure output parameter to more than 4,000 and the parameter is the nvarchar type. |
| 36136 | Describes a problem that occurs when the SQL Server client uses shared memory to connect to the MOM 2005 database. |
| 36137 | Fixes a memory leak that may occur when you cancel a large remote query. |
| 36138 | Describes a behavior in SQL Server 2000 that occurs when you try to assign large binary large object data to a stored procedure parameter. The action may fail. However, you can work around this behavior by directly writing the data into the table. |
| 36139 | When SQL Server is paused, any attempt you make to connect from a client tool, for example ISQL/W, gives the following error: Msg. No.: -10737; Severity: 14; State 0 SQL Server has been paused; No new connections will be allowed. The message... |
| 36140 | Fixes a problem where you receive access violation error messages when a long-running cursor fetch query causes a timeout and then causes SQL Server 2000 to crash. |
| 36141 | Fixes a problem in SQL Server 2000 that occurs when you make differential database backups. The backups may not include database changes in the Page Free Space (PFS) pages. |
| 36142 | Wednesday, April 13, 2005: 10:00 AM Pacific time: Explores I/O-related performance problems and resolutions for SQL Server 2000. Discusses in-depth monitoring using System Monitor and Profiler. Briefly introduces features of MOM 2005 SQL Mgt. Pack. |
| 36143 | Hash and merge algorithms can be used in a join operation between two or more tables only if there is at least one qualified equality comparison between the join attributes. An OR clause disqualifies all equality comparisons between joined tables.... |
| 36144 | Fixes a problem where Microsoft SQL Server 2000 stops listening unexpectedly for new TCP/IP Socket-based connections after you receive a 17882 error message. You must apply a hotfix to resolve this problem. |
| 36146 | There are times when you want jobs to be scheduled through the Windows NT Server AT scheduler rather than scheduled through the task scheduling manager used by the SQL Executive service. For example, you may want to schedule a job to stop SQL... |
| 36147 | The command line utility ISQL.EXE uses the currently logged in network user name for the SQL Server login name if the -U parameter is omitted or is specified without a name after the parameter instead of passing null. This may cause the error... |
| 36148 | If a stored procedure or view depends on a table that has been dropped, sysdepends will continue referencing the old ID of the table as a dependent, even if this ID does not exist any more. As a result, sp_depends will not show the correct object... |
| 36149 | Describes a problem that occurs when you perform an UPDATE or a DELETE operation against a remote OLE DB provider in SQL Server 2000. A deadlock condition may occur. |
| 36150 | Describes a problem that may occur when you receive incorrect results after you run a query in SQL Server 2000. |
| 36151 | Fixes the error 3624 that you receive after you perform a bulk insert operation in SQL Server 2000. After you receive this error message, the transaction file is corrupted and the user database is marked suspect. |
| 36152 | Fixes a problem that occurs when your computer that is running Microsoft SQL Server 2000 performs a very large hash operation. You receive a 17883 error message. Requires that you install a hotfix. |
| 36153 | Provides a fix for slow-running queries that contain a multi-table joins and one of the join is a view |
| 36154 | Discusses a problem that occurs when connection timeouts and other time-sensitive operations may fail. The article describes a hotfix that resolves the problem. |
| 36155 | If the column list in a CREATE TABLE command is terminated with a comma, as in the following statement: create table CommaTab (cola int, colb char(8),) SQL Server does not flag this as a syntax error. To work around this problem, correct the... |
| 36156 | If a stored procedure exits with the @@trancount value that is not the same as when the stored procedure was entered, the following error will occur: Error: 266, Severity: 16, State: 1 Transaction count after EXECUTE indicates that a COMMIT or... |
| 36157 | A sort order is a set of rules that determines how SQL Server collates and presents data in response to database queries. The sort order determines the order in which data is presented in response to SQL Server statements involving GROUP BY, ORDER... |
| 36158 | Describes a problem that occurs when you disconnect from an instance of SQL Server after you submit queries or transactions, and error 1203 may be logged in the error log. Includes a hotfix to resolve the problem. |
| 36159 | This article discusses cross language support for SQL Server 2000. |
| 36160 | Fixes a problem that occurs when you call a stored procedure that contains a SqlParameter output parameter and you set the parameter to DBNull. |
| 36161 | Fixes a problem that occurs after you install security update MS03-031. An access violation occurs in SQL Server 2000 when there is a high volume of local shared memory connections. |
| 36162 | Fixes a problem that occurs when you send an e-mail message in SQL Server 2000 by using the xp_sendmail extended stored procedure. The attached result set column widths are incorrect when the data contains DBCS characters. |
| 36163 | This article discusses a fix for a 3628 error that you may receive in SQL Server 2000 when you query many items that have an IN clause. |
| 36164 | Describes an issue that may occur when you perform multiple VDI snapshot backups and the thaw command (CompleteCommand) has been issued for all databases. The backup may not finish successfully. |
| 36165 | This article discusses a fix that you can use if you cannot create new TCP/IP socket based connections after error messages 17882 and 10055 are written to the Microsoft SQL Server 2000 error log. |
| 36166 | Fixes a problem that occurs when you perform a large in-memory sort operation that causes the SQL Server User Mode Scheduler to stop responding. A 17883 error message is reported in the error log. |
| 36167 | Discusses an issue where you receive an error message that is similar to SQLState = S1000, NativeError = 0 Error = [Microsoft][ODBC SQL Server Driver][SQL Server] when you use BCP in SQL Server 2000. |
| 36168 | Fixes the server Error: 17883, Severity: 1, State: 0 error. Error 17883 may be in the error log when transaction throughput has been reduced, and Microsoft SQL Server 2000 may appear to be hung. |
| 36169 | Fixes a problem that creates 17883 error messages in the error log and other problems when you perform large deallocation operations in SQL Server 2000. You must install a hotfix to resolve this problem. |
| 36170 | When creating a new SQL Server Data Source Name (DSN) using the ODBC API SQLConfigDataSource function, a network library must be specified. If the network library name is in lowercase letters, the Client Configuration dialog box may show it as... |
| 36171 | If you try to uninstall SQL Server 6.5 by doing the following after SQL Server 7.0 has been upgraded to SQL Server 2000 on the same computer: On the Start menu, choose Programs , select Microsoft SQL Server-Switch , and then click Uninstall SQL... |
| 36172 | Describes a problem that occurs when you run a TRUNCATE TABLE statement, and an Audit Object Permission event is not produced. |
| 36173 | Describes a problem that occurs when you retrieve rows in SQL Server 2000 by using browse mode, and you may not be able to identify or modify the rows. |
| 36174 | Describes a problem that occurs when performance is slow when you update a subscribed table on a subscriber that uses queued updating. |
| 36175 | Describes a problem that occurs when you try to perform an update statement, an insert statement, or a delete statement on a table that contains a trigger, and you receive an error message. |
| 36176 | Provides a fix for a problem where catalog creation for Full Text Search does not work. Problem occurs with Japanese character strings on Windows Server 2003-based computers. |
| 36177 | Balance Sheets are a common means of reporting cumulative financial data for a distinct time period. This article explains how to use calculated members to provide the necessary functionality. |
| 36178 | When you use the PivotTable component and you choose the option to calculate totals based on visible items only, you may receive the following error message: The data source does not support totalling only visible items. |
| 36179 | Describes a problem that occurs when a SPID stops responding with a NETWORKIO (0x800) waittype in SQL Server Enterprise Manager when SQL Server tries to process a fragmented TDS network packet. |
| 36180 | Describes a problem that occurs in the SQL Server optimizer when it underestimate the number of rows that qualify for a predicate of the form column = constant. Includes a hotfix that you can apply to resolve this problem. |
| 36181 | Describes two utilities that you can use to support stress testing and performance analysis in SQL Server 2000. |
| 36182 | Discusses how to install Microsoft SQL Server 2000 clustering on Microsoft Windows Server 2003 and differences between Microsoft Windows 2000 Server and Windows Server 2003. |
| 36183 | When defining multiserver jobs, SQL Server 7.0 as master server (MSX) is unable to enlist a SQL Server 2000 named instance as a target server (TSX). Trying to do so generates the following error message: Enlistment failed (reason: Error 22026: The... |
| 36184 | If you run the sqldiag utility on a computer that has Microsoft SQL Server 7.0 installed as the default instance and a named instance of SQL Server 2000, the sqldiag utility might use the SQL Server 7.0 path for collecting data and creating the... |
| 36185 | When tracing an ODBC connection to previous versions of SQL Server, you would see the following SET statements issued at connect time: SET QUOTED_IDENTIFIER ON SET TEXTSIZE 2147483647 SET ANSI_DEFAULTS ON SET CURSOR_CLOSE_ON_COMMIT OFF SET... |
| 36186 | Thread Local Storage (TLS) can be a very tricky subject. When working in a thread pooling environment, it is very important that you understand the ramifications of TLS and the thread interactions. It is highly suggested you avoid TLS in a thread... |
| 36187 | Describes a hotfix for the 547 error message that you may receive when you run the NSControl Update command to re-create a distributor in the NSDistributors table. |
| 36188 | Describes a problem that occurs when SQL Server 2000 may commit more memory than is physically available on a computer that is running Windows XP. Includes a resolution for the problem. |
| 36189 | When you view data associated with a custom member of a parent-child dimension, the cell values may display as #Err. When you examine the cell properties of any of the custom members, you receive the following error message: Infinite recursion... |
| 36190 | When you traverse a dimension through a Multidimensional Expressions (MDX), you may have to determine if you are at the top most level of the hierarchy. This article shows you four MDX expressions that allow you to find out if you are at the top most... |
| 36191 | The xp_sendmail extended stored procedure may raise the following error if you try to send query results by e-mail using the @attach_results parameter from SQL Server 2000 Personal Edition: Server: Msg 18024, Level 16, State 1, Line 0 xp_sendmail:... |
| 36192 | SQL Server supports connections to other OLE DB data sources on a persistent or an ad hoc basis. The persistent connection is known as a linked server; an ad hoc connection that is made for the sake of a single query is known as a distributed query.... |
| 36193 | Cluster Administrator provides a method to rename cluster resources. To do this, right-click the resource in Cluster Administrator and click Rename . However, if you rename the SQL Server Network Name resource, a variety of situations could occur, the... |
| 36194 | In Analysis Services a Member's Unique Name may be different depending on the setting of the MDX Unique Name Style connection string property of the Microsoft OLE DB Provider for OLAP 8.0. This article describes the different formats of the Member's... |
| 36195 | SQL Server 2000 enables replication of declared referential integrity (DRI) to Subscribers through the initial snapshot. The addition of this feature represents a significant performance enhancement for SQL Server 2000 as compared to other versions,... |
| 36196 | Time series calculations are frequently required in business and financial reports. Multidimensional expressions (MDX) provide the following time oriented functions to perform time series calculations: YTD QTD MTD WTD LastPeriods PeriodsToDate This... |
| 36197 | When editing the properties of an indexed view article that is part of a transactional publication, changes made to the Replace INSERT commands with this stored procedure call , Replace UPDATE commands with this stored procedure call , and Replace... |
| 36198 | In some applications, it is useful to find the first or last dimension member that has data associated with it. This article illustrates how to use the HEAD() , TAIL() , and UNION() functions to return the first and last members of a dimension that... |
| 36199 | Analysis Services limits the length of SQL expressions to 32 KB. Some applications require complex SQL Case expressions to define member names and keys, which would exceed the 32 KB limit. This article explains how you can work around the 32 KB limit. |
| 36200 | Describes how to download, install, and run the SQL Server edition of MPS Reporting tool. |
| 36201 | Describes a problem that occurs when a SQL Server CE connectivity application stops responding and does not return any error messages when the network connection is disconnected. Includes a hotfix to resolve the problem. |
| 36202 | The functionality to specify parameters for a T-SQL or XPath query is provided by enhancements in ActiveX Data Objects (ADO) 2.6. This article presents a sample of how to specify parameters to a templated query against SQL Server 2000 from an MDAC 2.6... |
| 36203 | Fixes a problem in SQL Server 2000 Service Pack 3 (SP3) where you experience blocking or performance problems because shared page locks are held until the end of the transaction. |
| 36204 | A SQL Server cluster resource may not come online and errors are in the log files. This problem occurs if resource-specific registry keys are missing. To resolve the problem, manually create the registry keys. |
| 36205 | Describes a problem that occurs when your DTS packages may fail if you run multiple DTS packages that contain Analysis Services Processing tasks at the same time. Includes several methods that you can use to work around this problem. |
| 36206 | This articles discusses a problem that you may experience with the AuthzInitializeContextFromSid API function call during the delivery of an e-mail subscription and possible resolutions for the problem. |
| 36207 | Describes a problem that occurs when you try to run a SQL Server CE RDA application that tries to connect to the SQL Server CE Server Agent by using an HTTPS connection. Includes a hotfix to resolve the problem. |
| 36208 | Discusses a situation where a client experiences poor performance with SQL Server 2000 when requests to the SQL Server stack up through critical sections of code. |
| 36209 | The SQL Server Agent Service does not start and you may see the following error message in the Windows Event Viewer: SQLServerAgent could not be started (reason: Unable to connect to server; SQLServerAgent cannot start). Additionally, if you attempt... |
| 36210 | When you install SQL Server 2000 SP2 or MSDE 2000 SP2 or earlier versions on computers that are running Windows XP SP2, you must install the latest SQL Server 2000 service pack or the latest MSDE 2000 service pack to help protect your computer. |
| 36211 | Describes a problem that occurs when you try to insert more than 65,535 records in a SQL Server table by using the SQLBulkOperations function. Includes a workaround for the problem. |
| 36212 | When attempting to restore an Analysis Services archive created on a server with the repository in Metadata Services Format to a server using the default Microsoft Access repository (Msmdrep.mdb), the following error message may appear: The archived... |
| 36213 | The SQL Server 2000 Books Online documentation is incorrect regarding the default value for the @terminate parameter for the sp_change_primary_role stored procedure in the msdb database. |
| 36214 | If you have configured a Data Transformation Services package to execute on a schedule, you may modify the schedule by using SQL Server Enterprise Manager. However, do not change the schedule for the package by using the Schedule Package command... |
| 36215 | Describes how to enable multiprotocol encryption in SQL Server 2000 for client connections, for a specific client, and over a firewall. Also describes how to enforce multiprotocol encryption over TCP/IP and Named Pipes. |
| 36216 | Indexed views are views whose results are persisted in the database and indexed for fast access. After the indexed views are created, you can publish the views as articles in Replication. If indexed views are part of a merge publication, changes to... |
| 36217 | Describes a problem that occurs when you use PDH APIs to collect the performance data of several instances of SQL Server 2000 at the same time, and an access violation occurs. Includes a hotfix that you can install to resolve the problem. |
| 36218 | This article describes how to perform Remote Data Access (RDA) pull by using SSCERelay and ActiveSync. |
| 36219 | When you try to set up SQL Server 2000 on a cluster, if the Full-Text resource fails to come online, the installation fails and SQL Server is removed on both nodes. The following events are logged: Event Type: Error Event Source: Microsoft Search... |
|
|
| 36220 | If log shipping is set up with only one destination server, clicking the Delete button on the Log Shipping tab of the Maintenance Plan properties has the same effect as clicking the Remove Log Shipping button; it removes the log shipping pair... |
| 36221 | In SQL Server 2000 Books Online, under the Usage Considerations heading in the Creating a Failover Cluster topic, the following is mentioned: You should not remove the BUILTIN\Administrators account from SQL Server. The IsAlive thread runs under... |
| 36222 | This article describes how to use the Microsoft ADO for Windows CE SDK (ADOCE) 3.1 Seek method with SQL Server 2000 Windows CE Edition. One of the most widely used methods by clients on SQL Server CE indexes is Seek . The Seek method provides the... |
| 36223 | This article contains a code sample that uses the the Microsoft ActiveX Data Objects for Windows CE (ADOCE) 3.1 AppendChunk and GetChunk methods against NText columns in a SQL Server CE database. The code sample illustrates the creation of a sample... |
| 36224 | This article demonstrates how to specify an XSL file as a parameter on a post to a SQL Server 2000 virtual root. |
| 36225 | Due to changes in the development cycle for the functionality of Distributed Partitioned Views, SQL Server Books Online contains some incorrect information on this subject. Distributed Partitioned Views, in the released product (SQL Server 2000), do... |
| 36226 | Fixes a problem with merge replication that is specific to SQL Server CE subscribers that can cause non-convergence of merge data. |
| 36227 | Describes a problem that occurs when you run a query that has a query plan that uses a nested loop join strategy. Includes a workaround and a hotfix that you can use to resolve the problem. |
| 36228 | Describes a problem that occurs when the Log Reader Agent may cause 17883 error messages. Includes a hotfix that you can use to resolve the problem. |
| 36230 | Describes the security update for SQL Server that you must apply as a post-installation step for Microsoft Office Live Communications Server 2003. |
| 36231 | This Support WebCast session provides information about the most common issues that are known to cause General Network Error error messages in client-side applications when connecting to SQL Server. |