| 15334 | You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000 |
| 15335 | The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005 |
| 15336 | Additional updates and additional inserts may be performed during synchronization when the merge publication contains join filters in SQL Server 2005 |
| 15337 | You cannot find SQL Server cluster resources in Failover Cluster Manager after you install a SQL Server 2005 failover cluster on a computer that is running Windows Server Longhorn |
| 15338 | Error message when the Log Reader Agent runs for a transactional publication in SQL Server 2005: Invalid Text Info Block for UpdateText |
| 15339 |
|
| 15340 | All conditional and branching statements are ignored when you try to execute a batch of Transact-SQL statements that have the FTMONLY option set to ON in SQL Server 2005 |
| 15341 | Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: “An OLE DB error has occurred. Error code: 0x80004005” |
| 15342 | Only the Backward Compatibility component is selected on the Feature Selection page when you install a localized version of SQL Server 2005 SP2 |
| 15343 | A SELECT query unexpectedly returns an incorrect number of rows in SQL Server 2005 Mobile Edition and in SQL Server 2005 Compact Edition |
| 15344 | Query performance may decrease after SQL Server 2005 has been running for a while |
| 15345 | A schema change that is made to a published table may not be propagated to subscriptions in SQL Server 2005 |
| 15346 | An inefficient or incorrect SQL query is generated when you try to use SQL Server 2005 to browse a ROLAP dimension |
| 15347 | SQL Server 2005 Analysis Services may stop responding when you try to process a ROLAP dimension two times |
| 15348 | You may receive an incorrect result when you try to run a Multidimensional Expressions (MDX) query by using SQL Server 2005 |
| 15349 | 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 |
| 15350 | Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available |
| 15351 | Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended |
| 15353 | The effects of U.S. daylight saving time changes on the databases of some SQL Server editions |
| 15354 | Error message when you use the sp_OACreate stored procedure to create an OLE object from a 32-bit COM DLL in an x64 edition of SQL Server 2005: 0x80040154 ODSOLE Extended Procedure Class not registered |
| 15355 | The query performance is very slow when you use a fast forward-only cursor to run a query in SQL Server 2005 |
| 15356 | The database mirroring session may remain in the synchronizing state and may stop responding when a database failover occurs in SQL Server 2005 |
| 15357 | Error message when you install SQL Server 2005 Service Pack 1 on an instance of SQL Server 2005 when the computer is also running an instance of SQL Server 2005 Service Pack 2: SqlSupport.msp is not digitally signed |
| 15358 | A forward-only cursor may be implicitly converted to a keyset cursor in SQL Server 2005 |
| 15359 | Error message when you perform a transaction log backup operation and another data backup operation in parallel in SQL Server 2005: Error 3633 |
| 15360 | 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 |
| 15361 | An assertion violation may be logged after you install SQL Server 2005 or after you add more processors to a server that is running SQL Server 2005 |
| 15362 | Error message when you try to connect to SQL Server 2005 Analysis Services from Object Explorer: System.OutOfMemoryException |
| 15363 | Error message when you execute a user-defined function in SQL Server 2005: Invalid length parameter passed to the SUBSTRING function or A transport-level error has occurred when receiving results from the server |
| 15364 | The size of the e-mail message is very large when you use Database Mail in SQL Server 2005 to send query results to users |
| 15365 | A query may take longer to run in SQL Server 2005 SP1 than it takes to run in the original release version of SQL Server 2005 or in SQL Server 2000 |
| 15366 | You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005 |
| 15367 | 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 |
| 15368 | You may be unable to execute SQL Server 2005 Integration Services packages that contain a Script task or a Script component on a Windows Vista-based computer |
| 15369 | Describes FIPS 140-2 and how to use SQL Server 2005 Service Pack 1 (SP1) or a later version of SQL Server in the FIPS 140-2 compliant mode. |
| 15370 | Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: Could not find stored procedure |
| 15371 | A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors |
| 15372 | You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services |
| 15373 | You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005 |
| 15374 | Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005 |
| 15375 | You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 |
| 15376 | A 17187 error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load |
| 15377 | I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005 |
| 15378 | Error message when you use SQL Server 2005: High priority system task thread Operating system error Exception 0xAE encountered |
| 15379 | Error message when you use the Bcp.exe utility to import data into a table from a text file in SQL Server 2005: The memory could not be written |
| 15380 | Fixes a problem in which rows in the TextData column that contain more than 128 characters are always displayed in a trace regardless of the filter that you create for the column. |
| 15381 | SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390 |
| 15382 | Error message when you try to configure SQL Server Agent to interact with Database Mail in SQL Server 2005 64-bit editions: An attempt was made to send an email when no email session has been established |
| 15383 | 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 |
| 15384 | How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 |
| 15385 | You may be prompted to enter the old password when you try to reset the password of a SQL Server login by using a SQL Server login that is a member of the securityadmin fixed server role in SQL Server 2005 |
| 15386 | The restore operation may take a long time to finish when you restore a database in SQL Server 2005 |
| 15387 | Fixes a problem in which you receive an error message when you run a CLR stored procedure or CLR function in SQL Server 2005. |
| 15388 | SQL Server timing values may be incorrect when you use utilities or technologies that change CPU frequencies |
| 15389 | You may receive incorrect results when you run a query against the target partitioned table after you insert data from a partitioned table to another partitioned table in SQL Server 2005 |
| 15390 | How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005 |
| 15391 | Error message when you use Database Mail in SQL Server 2005: Error 14667, Severity 16, State 1 |
| 15392 | Describes SQL Server 2005 Compact Edition. |
| 15393 | Error message when you try to upgrade a SQL Server 2000 database to a SQL Server 2005 database: Database 'DatabaseName' cannot be upgraded because it is read-only or has read-only files |
| 15394 | You may be unable to perform most database operations after you log on to an instance of SQL Server 2005 Express Edition Service Pack 1 on a Windows Vista-based computer |
| 15395 | The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005 |
| 15396 | When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005 |
| 15397 | Error message when you try to upgrade from SQL Server 2000 to SQL Server 2005: Cannot insert duplicate key row in object 'dbo.syscategories' with unique index 'clust' |
| 15398 | The SQL Native Client OLE DB provider (SQLNCLI) leaks memory when you call the IRowsetFastLoad::Commit method in a SQL Server 2005-based application |
| 15399 | The full-text index population for the indexed view is very slow in SQL Server 2005 |
| 15400 | The sp_MSinitDynamicSubscriber stored procedure is called more than one time by using the same parameters in SQL Server 2005 |
| 15401 | You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005 |
| 15402 | The output rows of the Aggregate transformation are divided into multiple rows in SQL Server 2005 Integration Services |
| 15403 | Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication |
| 15404 | Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: Windows NT user or group 'COMPUTERNAME\SQLServer2005MSSQLUser$COMPUTERNAME$MSSQLSERVER' not found |
| 15405 | Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005 |
| 15406 | How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Longhorn Server-based computer |
| 15407 | A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005 |
| 15408 | The merge agent fails and a permission denied error message is logged when you synchronize a SQL Server 2005-based merge publication |
| 15409 | Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: Msg 3456, Level 16, State 1, Line 1. Could not redo log record |
| 15410 | SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005 |
| 15411 | The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005 |
| 15412 | The value of the Collation registry entry is changed to the SQL_Latin1_General_CP1_CI_AS value after you install SQL Server 2005 Service Pack 2 Community Technology Preview or SQL Server 2005 Service Pack 1 |
| 15413 | 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 |
| 15414 | Some menu items in Visual Studio 2005 are missing when you open or create a project in Visual Studio 2005 after you install SQL Server 2005 Business Intelligence Development Studio |
| 15415 | Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: Invalid XML message format received on the ExternalMailQueue |
| 15416 | You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005 |
| 15417 | Error message when you install SQL Server 2005 Express Edition Service Pack 2 Community Technology Preview: An installation package for the product Microsoft SQL Server Native Client cannot be found |
| 15418 | You receive an error message when you try to create a full-text schedule by using SQL Server Management Studio in localized versions of SQL Server 2005 |
| 15419 | A query notification dependency between an application and a SQL Server 2005 database does not detect the changes in the database after a database mirroring failover |
| 15420 | How to improve concurrency in a SQL Server 2005 application by using built-in functions |
| 15421 | Support WebCast: Using Microsoft SQL Server 2005 Compact Edition |
| 15422 | The SQL Server service shuts down and an assertion error is logged in the CXteIndexSort::CXteIndexSort function in the SQL Server error log file when you start the SQL Server service in SQL Server 2005 |
| 15423 | Error message when you use a synonym for a stored procedure in SQL Server 2005: A severe error occurred on the current command |
| 15424 | Error message when you install or uninstall Microsoft SQL Server 2005 or SQL Server 2005 with Service Pack 2 on a Windows Vista-based or a Windows Server Longhorn-based computer |
| 15425 | The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005 |
| 15426 | SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source |
| 15427 | A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005 |
| 15428 | 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 |
| 15429 | A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database |
| 15430 | You cannot use existing tables on a heterogeneous subscriber database when you configure a push subscription to a heterogeneous subscriber in SQL Server 2005 |
| 15431 | An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005 |
| 15432 | You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005 |
| 15433 | A script task or a script component is executed multiple times in duplicate when you run packages that contain script tasks or script components in parallel in SSIS |
| 15434 | A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005 |
| 15435 | Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1” |
| 15436 | Error message when you run a .NET Framework 1.0 or .NET Framework 1.1 application on a computer that has SQL Server 2005 installed |
| 15437 | The SQL Server service cannot start after you configure an instance of SQL Server 2005 to use a Secure Sockets Layer (SSL) certificate using the Microsoft Enhanced Cryptographic Provider 1.0 |
| 15438 | You may receive incorrect results when you use the bulk copy program command-line utility to import data in SQL Server 2005 |
| 15439 | 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 |
| 15440 | 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 |
| 15441 | When you call a SQL Server 2005 Integration Services package from a SQL Server Agent job step, the package may stop responding |
| 15442 | SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005 |
| 15443 | Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: Query processor could not produce a query plan because of the hints defined in this query |
| 15444 | A list of the bugs that are fixed in SQL Server 2005 Service Pack 2 Community Technology Preview (CTP) |
| 15445 | Error message when you start SQL Server Management Studio in SQL Server 2005: Unable to cast object of type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' to type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' |
| 15446 | Fix: Error message when you convert a column from the varbinary(max) data type to the XML data type in SQL Server 2005: Msg 6322, Level 16, State 1, Line 2 Too many attributes or namespace definitions |
| 15447 | Ad hoc queries take a longer time to finish running when the size of the TokenAndPermUserStore cache grows in SQL Server 2005 |
| 15448 | The SQL Trace entries may be incorrect when you trace an instance of SQL Server 2005 that is configured to use database mirroring |
| 15449 | Error message when you run any of the DBCC CHECK commands in SQL Server 2005: The database could not be exclusively locked to perform the operation |
| 15450 | A memory leak may occur when you run SQL Server 2005 Integration Services packages that are stored in the SSIS Package store |
| 15451 | Hard disk drive sector-size support boundaries in SQL Server 2005 |
| 15452 | When you use SQL Profiler to create a trace in SQL Server 2005, the Existing Connection event appears after other events that are logged for the same session ID |
| 15453 | The list of product codes that depend on SQL Native Client may be lost after you upgrade to SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista Release Candidate 1 |
| 15454 | How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring |
| 15455 | SQL Server 2005 Service Pack 1 installation stops unexpectedly, and the following error message is logged in the setup log file: Unable to install Windows Installer MSP file |
| 15456 | Error message when you try to query data from a column of the XML data type or from a variable of the XML data type in SQL Server 2005: An error occurred while executing batch |
| 15458 | You receive error messages when you use SQL Server Management Studio or SQL Server Business Intelligence Development Studio after you install Microsoft Office Excel 2007 on a computer that has SQL Server 2005 Analysis Services installed |
| 15459 | Error message when the Replication Merge Agent runs in SQL Server 2005: Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402 |
| 15460 | Error message when you try to install a SQL Server 2005 service pack or a SQL Server 2005 hotfix package: Error 29528. The setup has encountered an unexpected error while Setting Internal Properties |
| 15461 | You cannot use SQL Server Management Studio to view job steps that have the SSIS data type on an installation of SQL Server 2005 that uses Turkish collation, and you may receive an Index was outside the bounds of the array error message |
| 15463 | Error message when you try to install SQL Server 2005 in a cluster environment: SQL Server Setup could not validate the service accounts |
| 15464 | Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: Logon error: 18456 |
| 15465 | An EXCEPTION_STACK_OVERFLOW exception may occur when you try to run a Transact-SQL query in SQL Server 2005 |
| 15466 | The Distribution Agent may not apply transactions when you use transactional replication with a published Oracle table and the table contains a column that uses the number data type in SQL Server 2005 |
| 15467 | Error message when you run queries between two SQL Server 2005 linked servers: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON' |
| 15468 | Error messages may be logged in the SQL Server error log after you run a DBCC command in SQL Server 2005 |
| 15469 | Subscription distribution may fail after you synchronize a subscription in SQL Server 2005 |
| 15470 | SQL Server significantly increases the unused space for some tables |
| 15471 | You may experience stack corruption and SQL Server 2005 Analysis Services may stop responding when you run SQL Server 2005 Analysis Services on a Dual-Core Intel Itanium 2 Processor 9000 Series-based computer |
| 15472 | Error message when you use a label after a Transact-SQL query in SQL Server 2005: Incorrect syntax near 'X' |
| 15473 | Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: Package PackageName has been cancelled |
| 15474 | Error message when you call the SQLTables function against an instance of SQL Server 2005: Invalid cursor state (0) |
| 15475 | An empty string is replicated as a NULL value when you synchronize a table to a SQL Mobile subscriber |
| 15476 | Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: insufficient system memory to run this query |
| 15477 | Error message when you use a table-valued function (TVF) together with the CROSS APPLY operator in a query in SQL Server 2005: There is insufficient system memory to run this query |
| 15478 | A partitioned table may generate an inefficient query plan when you run a Transact-SQL query that uses the Top n clause on a partitioned table in SQL Server 2005 |
| 15479 | You may receive an error message when you try to use SQL Server Management Studio to update a row of a table in SQL Server 2005 |
| 15480 | System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization |
| 15481 | After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database |
| 15482 | SQL Server 2005 may overestimate the cardinality of the JOIN operator when a SQL Server 2005 query contains a join predicate that is a multicolumn predicate |
| 15483 | When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease |
| 15484 | You may obtain incorrect results when you run a query against a character data type column in SQL Server 2005 |
| 15485 | You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005 |
| 15486 | The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative |
| 15487 | Error message when you execute an MDX query that calls a VBA function in SQL Server 2005 Service Pack 1: PFE_ASSEMBLY_NOT_SAFETOPREPARE |
| 15488 | An access violation may intermittently occur when you run a SQL Server Integration Services package in SQL Server 2005 |
| 15489 | You obtain incorrect results when you run a full-text search query that uses a thesaurus file in SQL Server 2005 |
| 15490 | You may receive an access violation error message when you run a query against a linked server in SQL Server 2005 |
| 15491 | Use of detours by a third-party solution is not supported with SQL Server |
| 15492 | When you click Build Query in the Execute SQL Task Properties dialog box of the SQL Server 2000 DTS package designer, SQL Server 2005 Management Studio unexpectedly closes |
| 15493 | A query plan is not cached in SQL Server 2005 when the text of the hint is a large object |
| 15494 | Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005 |
| 15495 | Support WebCast: Overview of database mirroring in SQL Server 2005 |
| 15496 | Support WebCast: How to use the DataReader Source and the OLE DB Source objects in SQL Server 2005 Integration Services |
| 15497 | You may receive an access violation error message when you try to run an SSIS package in SQL Server 2005 |
| 15498 | You receive an access violation error message on a server that is running SQL Server 2005 Analysis Services when you run a MDX query that contains a user-defined function |
| 15499 | In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application log |
| 15500 | You may receive an error message when you manually define a Back Up Database task in SQL Server 2005 to back up the transaction log |
| 15501 | Unhandled exceptions are caught by the Visual Studio JIT debugger instead of Dr. Watson or a third-party debugger after you install certain versions of SQL Server 2005 |
| 15502 | Troubleshooting DBCC error 2570 in SQL Server 2005 |
| 15503 | SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor |
| 15504 | SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement |
| 15505 | Error message when you run the SQLDiag utility or the PSSDiag utility: Exception creating Perfmon log |
| 15506 | You receive an error message when you try to create a differential database backup in SQL Server 2005 |
| 15507 | SQL Server 2005 treats an identity column in a view as an ordinary int column when the compatibility level of the database is set to 80 |
| 15508 | The BULK INSERT statement may not return any errors when you try to import data from a text file to a table by using the BULK INSERT statement in Microsoft SQL Server 2005 |
| 15509 | Error message when you perform a full backup of a database in SQL Server 2005: Backup failed for Server 'ComputerName\SQLInstanceName' or The backup of the file or filegroup 'sysft_FullTextCatalog' is not permitted because it is not online |
| 15510 | The SQL-DMO SpaceAvailableInMB property of the Database object may return an incorrect value in SQL Server 2005 or in SQL Server 2000 |
| 15511 | The SQL Server login name is not updated in the sys.syslogins catalog compatibility view after you change the computer name |
| 15512 | Error message when you install SQL Server 2005 on a computer that is running the original release version of Windows XP: This application has failed to start because the application configuration is incorrect |
| 15513 | SQL Server is not supported on Intel-based Apple Macintosh computers that run a Windows operating system |
| 15514 | You may experience decreased performance in some features of SQL Server 2005 when you use EFS to encrypt database files |
| 15515 | You cannot debug assemblies that are referenced in the Script task code by using Visual Studio for Applications in SSIS |
| 15516 | Error message when you run a Visual C++ application that connects to SQL Server 2005 by using ODBC: [Microsoft][ODBC SQL Server Driver][SQL Server] Could not find stored procedure 'sp_fallback_MS_sel_fb_svr' |
| 15517 | The binary zero (0x00) data and the successive data in a character column is truncated or is replaced with spaces (0x20) when you use the SQL Server Import and Export Wizard to transfer a table in SQL Server 2005 Integration Services |
| 15518 | Support policy for untested .NET Framework assemblies in the SQL Server 2005 CLR-hosted environment |
| 15519 | Error message when you try to save a maintenance plan in SQL Server Management Studio: Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx) |
| 15520 | How to use the Add or Remove Programs item in Control Panel to add or remove components for stand-alone installations and clustered installations of SQL Server 2005 |
| 15521 | Error message when you install the SQL Server 2000 DTS Designer components on a computer that is running Windows 2000: dtsui.dll failed to register HRESULT -2147024770 |
| 15522 | Error message when you uninstall SQL Server 2005: The setup has encountered an unexpected error while Setting Internal Properties. The error is: Fatal error during installation |
| 15523 | You receive a Sample database 'Adventureworks' already exists in SQL instance specified error message when you use Add or Remove Programs to install the AdventureworksDW Sample Data Warehouse sample database in SQL Server 2005 |
| 15524 | Error message when you run a SQL Server 2005 application that contains user-defined data types: AppDomain 3 (db_name.dbo[runtime].2) is marked for unload due to memory pressure |
| 15525 | A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005 |
| 15526 | Error message when you run the SQL Server Import and Export Wizard in SQL Server 2005: SQL Server Import and Export Wizard has encountered a problem and needs to close |
| 15527 | SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer |
| 15528 | Error message when SQL Server Agent runs a job to clean up the spool table in BizTalk Server 2006: Unable to post notification to SQLServerAgent |
| 15529 | The value of the automatic growth increment of a database file may be very large in SQL Server 2005 |
| 15530 | Error message when you use the CREATE TABLE statement to create a temp table and you use the CREATE SCHEMA statement in the same batch in SQL Server 2005: CREATE SCHEMA failed due to previous errors |
| 15531 | Error message when you use SQL Server 2005 Report Manager to try to run a linked report: An internal catalog exception has occurred |
| 15532 | You receive a No description found error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005 |
| 15533 | SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS) |
| 15534 | The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005 |
| 15535 | The value of the UserModeTime element is displayed as the value of the KernelModeTime element in the XML output of the record column in SQL Server 2005 |
| 15536 | You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groups |
| 15537 | Error message when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Express Edition: Another installation is already in progress. Complete that installation before proceeding with this install |
| 15538 | Error message when you restore or attach an msdb database or when you change the syssubsystems table in SQL Server 2005: Subsystem % could not be loaded |
| 15539 | The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005 |
| 15540 | Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005 |
| 15541 | The User connections counter of the SQLServer:General Statistics performance object is not decremented when a Service Broker activation task is ended in SQL Server 2005 |
| 15542 | The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005 |
| 15543 | You may receive an error message when you try to run an SSIS package in SQL Server 2005 |
| 15544 | Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: The request failed to run because the batch is aborted |
| 15545 | Error message when you try to add a configuration to a SQL Server 2005 Integration Services .dtsx package: An error occurred while a new configuration was being added |
| 15546 | Error message when you run SQL Server 2005 Mobile Edition: 80004005 unspecified error |
| 15547 | Fixes the problem that occurs when you run Database Engine Tuning Advisor from the command line in SQL Server 2005. |
| 15548 | You notice additional random trailing character in values when you retrieve the values from a fixed-size character column or a fixed-size binary column of a table in SQL Server 2005 |
| 15549 | The user is not assigned to a default schema when you use Windows authentication to connect the user to SQL Server 2005 |
| 15550 | Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources |
| 15551 | Requirements for SQL Server 2005 and SQL Server 2000 to support remote mirroring of user databases |
| 15552 | Error message when you try to install SQL Server Express or SQL Server Express Edition or SQL Server Express Edition with Advanced Services: The SQL Server service failed to start |
| 15553 | Error message when you call the Pull method of an RDA object: duplicate value cannot be inserted into a unique index. [Table name = __sysRDASubscriptions, Constraint name = c_LocalTableName] |
| 15554 | Error message when you try to connect to an instance of SQL Server 2005: No process is on the other end of the pipe or An existing connection was forcibly closed by the remote host |
| 15555 | Error message when you try to export SQL Server 2005 reports to Excel: Index out of range |
| 15556 | Error message when you run a DBCC check command in SQL Server 2005: 8909 16 1 Table error: Object ID 0, index ID -1, partition ID 0, alloc unit ID 0 (type unknown) |
| 15557 | You may receive an error message when you run a package that calls other child packages in SQL Server 2005 Integration Services |
| 15558 |
|
| 15559 | The SQL Server 2005 JDBC Driver may not return the correct dates when you use the getTimestamp(,,Calendar) method or the setTimestamp(,,Calendar) method in a prepared statement |
| 15560 | The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schema |
| 15561 | You may receive an error message when you use the SQL Server 2005 Driver for JDBC and try to perform a batch insert by using a prepared statement that contains the SelectMethod=cursor property on a connection |
| 15562 | Error message when you start SQL Server 2005 Management Studio: Input string was not in a correct format |
| 15563 | Error message when you install SQL Server 2005: Beta components detected |
| 15564 | The datetime data type and the smalldatetime data type are always evaluated by using the us_english language environment when you use the CREATE PARTITION FUNCTION statement in SQL Server 2005 |
| 15565 | You may experience problems when you try to run a SQL Server 2000 DTS package after you upgrade all the instances of SQL Server 2000 to SQL Server 2005 |
| 15566 | Error message when you try to install SQL Server 2005 Express Edition or SQL Server 2005 Express Edition with Advanced Services: Server SQL Server is terminating because of fatal exception c000001d |
| 15567 | Error message when you try to install SQL Server 2005: Could not find a package to install on the installation media |
| 15568 | You receive an error message when you use the Package Migration Wizard to migrate a DTS package |
| 15569 | An exception occurs when you try to perform a one-phase commit on an XA-enabled JDBC connection in SQL Server 2005 |
| 15570 | Describes that you may receive the 7357 or 7320 error messages, or both, when you perform an UPDATE, INSERT, or DELETE Transact-SQL statement on a remote table by using the OpenQuery function. |
| 15571 | Describes the default resource dependencies in SQL Server and the restrictions on these dependencies. |
| 15572 | Describes that you may receive an error message when you connect to an instance of SQL Server without specifying a login database. |
| 15573 | You may unexpectedly receive a series of messages when you use Object Explorer in Management Studio to restart SQL Server 2005 |
| 15574 | How to transfer the logins and the passwords between instances of SQL Server 2005 |
| 15575 | Error message when you run the DBCC CHECKDB statement on a database that contains one or more very large tables in SQL Server 2005: Timeout occurred while waiting for latch |
| 15576 | When you connect to the SQL Server 2005 database engine, you may experience longer connection times |
| 15577 | How to uninstall an instance of SQL Server 2005 manually |
| 15578 | You receive an access violation error message when you use the Microsoft Application Verifier to monitor the Sqlservr.exe program for SQL Server 2005 |
| 15579 | Error message when you install SQL Server Express Edition Service Pack 1 or SQL Server 2005 Express Edition with Advanced Services: SQL Server Setup did not have the administrator permissions required to rename a file |
| 15580 | The part of a script that is defined on an indexed view is not generated when you script an SMO object that is related to the indexed view in SQL Server 2005 |
| 15581 | You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005 |
| 15582 | How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005 |
| 15583 | Cumulative hotfix package (build 2153) for SQL Server 2005 is available |
| 15584 | Error message when you use the correct syntax of the CREATE TYPE statement in SQL Server 2005: Incorrect syntax near 'ObjectName' |
| 15585 | Error message when you install SQL Server 2005: The file C:\Windows\Microsoft.NET\Framework\Meaningless_string\mscorlib.tlb could not be loaded |
| 15586 | The cluster setup may fail when you try to upgrade SQL Server 2005 to SQL Server 2005 Service Pack 1 |
| 15587 | You may receive an error message when you try to run an existing CLR object or create an assembly that has the external_access or unsafe permission set on a database that is attached or restored from a different server |
| 15588 | The SQL Server session may be blocked unexpectedly when you execute an ALTER VIEW statement on a view or when you execute an ALTER FUNCTION statement on a table-valued function |
| 15589 | 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 |
| 15590 | Best practices for setting up domain groups when you install a SQL Server 2005 cluster |
| 15591 | An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step |
| 15592 | You may receive an error message when you try to print a SQL Server 2005 Reporting Services report from a WebBrowser control |
| 15593 | Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005 |
| 15594 | The Permissions column for the Audit Schema Object Access event does not populate in SQL Server 2005 |
| 15595 | You receive an error message when you try to load an SSIS package that contains a DateTime type variable in SQL Server 2005 |
| 15596 | You may experience a 45-second delay when you run a full-text query in an instance of SQL Server 2005 that is running on a server without Internet access |
| 15597 | Error message when you install SQL Server 2005: Cannot alter the login 'sa', because it does not exist or you do not have permission |
| 15598 | You may experience a decrease in query performance after you perform certain database maintenance operations or regular transaction operations in SQL Server 2005 |
| 15600 | Support for the Hong Kong collation in SQL Server 2005 |
| 15601 | How to upgrade or downgrade an assembly that has a referenced assembly for a CLR object in an instance of SQL Server 2005 |
| 15602 | You receive an error message when you use SQL Server 2005 Reporting Services to run a report that has two or more parameters |
| 15603 | You receive an error message when you try to uninstall the second named instance of SQL Server 2005 |
| 15604 | SQL Server Agent jobs fail when the jobs contain job steps that use tokens after you install SQL Server 2005 Service Pack 1 |
| 15605 | How to use certificates for SQL Server 2005 Service Broker remote security on multiple instances of SQL Server 2005 |
| 15606 | Error message when you run an MDX query in SQL Server 2005 Analysis Services: Dimension attribute was not found |
| 15607 | Error message when you try to modify a SQL Server 2000 DTS package in SQL Server 2005: The DTS host failed to load or save the package properly |
| 15608 | You may receive an error message when a SQL Server 2005 client requests encryption and connects to 127.0.0.1 on a Windows XP-based computer |
| 15609 | Error message when you try to change a column of a table by using the ALTER TABLE statement in SQL Server 2005: Could not allocate space |
| 15610 | You may receive an error message when you try to install SQL Server 2005 Service Pack 1 |
| 15611 | How to obtain the SQL Server Runtime license |
| 15612 | 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 |
| 15613 | Key factors to consider when evaluating third-party file cache systems with SQL Server |
| 15614 | You experience low CPU spikes at set intervals even when there is no user activity in SQL Server 2005 |
| 15615 | SQL Server 2005 Analysis Services may close unexpectedly when you create and then delete a subcube in the same session |
| 15616 | Microsoft SQL Server I/O subsystem requirements for the tempdb database |
| 15617 | Getting ready for SQL Server 2005 |
| 15618 | You may receive an access violation error message when you run a parallel execution plan in SQL Server 2005 |
| 15619 | No result set is returned when you run an MDX query that uses an unnatural hierarchy in SQL Server 2005 |
| 15620 | You may receive an access violation error message when you run a SELECT query in SQL Server 2005 |
| 15621 | The INSERT operation is very slow when you try to insert many rows into a table that contains a full-text index |
| 15622 | How to use the timestamp column of a table for optimistic concurrency control in SQL Server 2005 |
| 15623 | How to copy the files from the SQL Server 2005 installation CDs to a location and how to start the SQL Server 2005 Setup program from that location |
| 15624 | Problems may occur when you use the SQLdiag utility in SQL Server 2005 |
| 15625 | Memory leaks occur when you use Fuzzy Lookup and Fuzzy Grouping to transform a SQL Server 2005 Integration Services package |
| 15626 | How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services |
| 15627 | Error message when you try to use a merge publication that you created in SQL Server 2005: Precomputed partitions cannot be used |
| 15628 | Error message when you try to modify a large table by using SQL Server Management Studio: Timeout expired |
| 15629 | Error message when you use the sys.dm_exec_query_plan dynamic management function to return a Showplan in XML format for a Transact-SQL batch: A system assertion check has failed |
| 15630 | Error message when you try to use the DELETE statement to delete rows from a remote table on a linked server: Statement(s) could not be prepared |
| 15631 | Error message when you create a new maintenance plan in SQL Server 2005: Create maintenance plan failed |
| 15632 | A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1 - Community Technology Preview (CTP) March 2006 |
| 15633 | The incorrect type for the union element is returned when you run XQuery against XML data that contains the union element |
| 15634 | How to configure SQL Server 2005 to allow remote connections |
| 15635 | When you try to run a query in a query editor in SQL Server Management Studio, a query in a different query editor runs instead |
| 15636 | How to obtain the latest service pack for SQL Server 2005 |
| 15637 | An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in SQL Server 2005 |
| 15638 | You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005 |
| 15639 | An application query that reads lots of data may be slow, and the SQL Server service may take a long time to start in SQL Server 2005 |
| 15640 | The schema that indicates the Identity column in the source database is not transferred to the destination database when you try to transfer objects from a source database to a destination database by using SQL Management Objects in SQL Server 2005 |
| 15641 | When you use an ActiveX Data Objects Recordset object to access a database in SQL Server 2005, the Recordset object returns no records |
| 15642 | Error message when you try to convert a string to the XML data type in SQL Server 2005: Cannot bind to the reserved namespace |
| 15643 | Error message when you try to run several queries on large data sets at the same time in SQL Server 2005: 701 There is insufficient system memory to run this query |
| 15644 | An export operation fails when you try to perform a site deployment export operation to SQL Server 2005 in Content Management Server 2002 SP1a |
| 15645 | How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005 |
| 15646 | You receive a NULL value when you use XQuery to retrieve the value of an XML element in SQL Server 2005 |
| 15647 | Error message when you try to create a new subscription in SQL Server Express: Invalid column name 'step_uid'. |
| 15648 | An .sdf database file in SQL Server Mobile is larger than the same .sdf database file in SQL Server CE 2.0 when you use the ntext data type or the image data type |
| 15649 | You receive an error message when you try to upgrade an expired installation of SQL Server 2005 Evaluation Edition to a retail version of SQL Server 2005 |
| 15650 | Error message when you run the ALTER SERVICE MASTER KEY REGENERATE statement in SQL Server 2005: The current master key cannot be decrypted |
| 15651 | The synchronous database mirroring session status may remain disconnected when you set up synchronous database mirroring but do not configure a witness database and you run a DBCC STACKDUMP command in SQL Server 2005 |
| 15652 | You may receive error messages when you use the Configure Distribution Wizard in SQL Server 2005 |
| 15653 | A user may be able to access objects in other schemas when you grant the ALTER permission on a schema to the user in SQL Server 2005 |
| 15654 | SSIS reports that a query was successful when a SQLOLEDB provider ends an SSIS query because of a server error |
| 15655 | How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing |
| 15656 | Error message when you install a SQL Server 2005 failover cluster on a node: The drive specified cannot be used for program location |
| 15657 | The connection may time out before the first try to connect to the failover partner server when you try to connect to a SQL Server 2005 mirrored database by using an ADO.NET 2.0-based application |
| 15658 | You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package |
| 15659 | You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard |
| 15660 | You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005 |
| 15661 | You may receive an error message when you try to use backup software to back up a database in SQL Server 2005 for Itanium-based Systems |
| 15662 | Error message when you use a common language runtime object in SQL Server 2005: Cannot load dynamically generated serialization assembly |
| 15663 | Error message when you run a query in SQL Server 2005: Internal error: An expression services limit has been reached |
| 15664 | Error message when you open SQL Server 2005 Books Online: Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.SQLCC.v9' is invalid |
| 15665 | Installation may fail, and you may receive an error message when you try to install SQL Server 2005 64-bit on a 64-bit server |
| 15666 | An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005 |
| 15667 | The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005 |
| 15668 | Microsoft does not certify that third-party products will work with SQL Server |
| 15669 | Error message when you use Database Engine Tuning Advisor in SQL Server 2005: Attempt to initialize the CRT more than once |
| 15670 | You cannot run a statement or a module that includes the EXECUTE AS clause after you restore a database in SQL Server 2005 |
| 15671 | Error message when you use an EXECUTE AS clause in a DDL trigger: The server principal LoginName is not able to access the database DatabaseName under the current security context |
| 15672 | Error message when you try to obtain schema information from a SQL Server 2005 Mobile Edition database by using the SqlCeConnection.GetSchema method: NotSupportedException |
| 15673 | You cannot open the SQL Server Mobile Setup Help file in the SQL Server Mobile Server Tools installation wizard |
| 15674 | You receive a compiler error message when you call the Dispose(BooleanParameter) method of the SqlCeDataReader object in a SQL Server 2005 Mobile Edition project |
| 15675 | The operation is delayed for several minutes when you run a Transact-SQL statement or a module that has an EXECUTE AS clause in SQL Server 2005 |
| 15676 | Error message when you run, import, or migrate a SQL Server 2000 DTS package that contains an instance of the Analysis Services Processing task in SQL Server 2005: Invalid class string |
| 15677 | Space that a table uses is not completely released after you use a DELETE statement to delete data from the table in SQL Server |
| 15678 | You cannot replicate data from SQL Server 2005 to SQL Server Mobile by using the 64-bit version of IIS |
| 15679 | Error message when you run a Transact-SQL query that involves one or more SQL Server CLR Integration (SQLCLR) objects in SQL Server 2005: Msg 6535 |
| 15680 | 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 |
| 15681 | The module information is represented incorrectly when you profile managed code that is running in SQL Server 2005 by using performance tools in Visual Studio Team Edition for Software Developers |
| 15682 | Error message when you try to replicate a table from SQL Server 2005 to SQL Server 2005 Mobile Edition: HRESULT 0x80004005 (0) |
| 15683 | How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management |
| 15684 | The query does not use the indexed view in SQL Server 2005 Enterprise Edition |
| 15685 | How to create a package template in SQL Server Business Intelligence Development Studio |
| 15686 | Event ID: 1023 occurs, and counter data is not logged when you use Performance Monitor to collect data from SQL Server 2005 Analysis Services performance counters |
| 15687 | The installation may fail and you may receive an error message when you try to install the DTS redistributable package for SQL Server 2005 on a Windows 2000 Advanced Server SP4-based computer |
| 15688 | Custom events information from a child package is not logged under the log provider context of the parent package in SQL Server 2005 Integration Services |
| 15689 | How to detect the status of the SQL Server Express service or start the SQL Server Express service by using Visual Basic or Visual C# |
| 15690 | Error message when you run certain queries or certain stored procedures in SQL Server 2005: A severe error occurred on the current command |
| 15691 | The user access option of a SQL Server 2005 database may unexpectedly be set to SINGLE_USER when you restore the database by using a backup file |
| 15692 | You receive an error message when you try to build a project for deployment and the project contains multiple packages that are configured to use a shared configuration file in SQL Server 2005 Integration Services |
| 15693 | Error message when you use Service Broker or database mirroring to connect to an instance of SQL Server 2005: Connection handshake failed |
| 15694 | 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 |
| 15695 | Item labels in the SQL Server Integration Services toolbox window may appear in an incorrect language |
| 15696 | 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. |
| 15698 | Explains that error message 823 may indicate hardware problems or system problems that occur when SQL Server reads from or writes to database files. |
| 15699 | Describes a problem that may occur when you try to connect to SQL Server 2000 or SQL Server 2005 by using a trusted connection. |
| 15700 | Explains why you receive an Error loading error message in SQL Server 2005 when you try to run an SSIS package by using a different computer or a different user account than the computer and user account that was used to create the SSIS package. |
| 15701 | Describes the steps that you must follow to reduce the transaction log file size when the transaction log becomes full and cannot grow any more. Lists the options that you can use to stop the transaction log file from unexpectedly growing. |
| 15702 | 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. |
| 15703 | You may receive an error message when you try to load data by using CLR functions in a Transact-SQL job in SQL Server 2005 |
| 15704 | 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 |
| 15705 | How to measure the rate at which rows pass through a particular data flow task in a SQL Server 2005 Integration Services (SSIS) package |
| 15707 | You receive error messages when you try to set up a clustered instance of SQL Server 2005 |
| 15708 | How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database |
| 15709 | 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 |
| 15710 | SQL Server 2005 Analysis Services performance monitor counters do not report values |
| 15711 | How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005 |
| 15712 | 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... |
| 15713 | 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... |
| 15714 | 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... |
| 15715 | 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... |
| 15716 | 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... |
| 15717 | The SQL Server 2005 Setup program may take a very long time to be completed |
| 15718 | TechNet Support WebCast: Server sizing recommendations for Microsoft SQL Server 2005 |
| 15719 | You receive an error message when you use the replication feature to run an INSERT statement on a table that has an IDENTITY column for which the NOT FOR REPLICATION option is enabled in SQL Server 2005 |
| 15720 | SQL Server 2005 Express Edition Readme |
| 15721 | SQL Server 2005 Readme and installation requirements |
| 15722 | You may receive the Property IsAccentSensitive is not available for FullTextCatalog '[CatalogName]' error message when you try to open a full-text catalog after you restore a database in SQL Server 2005 |
| 15723 | How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005 |
| 15724 | TechNet Support WebCast: Overview and deployment of Microsoft SQL Server 2005 |
| 15725 | You receive an error message when you use Microsoft OLE DB Provider for Visual FoxPro in SQL Server |
| 15726 | Scalable shared databases are supported by SQL Server 2005 |
| 15727 | Release manifest for Microsoft SQL Server Native Client (9.00.1399.06) |
| 15728 | How to uninstall SQL Server Management Studio |
| 15729 | A System.InvalidOperationException exception may occur when you try to use a Visual Studio .NET 2003 client application against a SQL Server 2005 native Web service |
| 15730 | You cannot upgrade a named instance of SQL Server 2000 to SQL Server 2005 on a computer that is running the Itanium-based operating system |
| 15731 | How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005 |
| 15732 | The supported Windows account types that you can use to run the SQL Server Agent service in SQL Server 2005 |
| 15733 | How to connect to SQL Server Express Edition |
| 15734 | A change to the Readme.htm file for SQL Server 2005 Mobile Edition |
| 15735 | Changes to the readme file for SQL Server 2005 |
| 15736 | The 32-bit version of the SQL Server 2005 Analysis Services Instance Rename tool (ASInstanceRename.exe) does not work correctly on a 64-bit computer |
| 15737 | Description of the Error 1619 installing sqlncli.dll error message that you may receive when you install SQL Server 2005 |
| 15738 | Issues to consider when you use the database mirroring feature in SQL Server 2005 |
| 15739 | Discusses the new noise word files in SQL Server 2005 and provides a method to use the old words if you want. |
| 15740 | A SQL Server CE database or a SQL Server 2005 Mobile Edition database may go into a unrecoverable state after a power failure or an explicit reset. This article discusses possible resolutions for this problem. |
| 15741 | Describes an issue in SQL Server 2005 CTP where the full-text search service incorrectly installs under the LocalSystem account. Includes a workaround for the issue. |
| 15742 | Explains that you may experience problems when you use a DTA client to tune SQL Server 2000 or pre-June CTP versions of SQL Server 2005. You must use an account that is a member of the sysadmin fixed server role to run a script on the server. |
| 15743 | You may receive a Permission denied error message when an application role-based application tries to select records from any one of the system tables in a SQL Server 2005 master database |
| 15744 | The NorthwindOleDb sample application is not available when you install SQL Server Mobile Edition from a SQL Server 2005 installation |
| 15745 | Unsupported tuning options for some editions of SQL Server 2005 CTP 16 and of SQL Server 2000 |
| 15746 | You may experience slow performance when you run 32-bit SQL Server tools on 64-bit operating systems |
| 15747 | 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.... |
| 15748 | Describes a problem that may occur when your SQL Server CE client program may not be able to connect to IIS on computers that are running Windows XP SP2. Includes a resolution for the problem. |
| 15749 | This article discusses a hotfix for the problem of the merge replication agent not responding when you use a custom conflict resolver with merge replication and a conflict occurs between SQL Server 2000 and SQL Server CE. |
| 15750 | Client connections to SQL Server instances or to MSDE instances that are installed on computers that are running Microsoft Windows XP Service Pack 2 may receive an error message. This article discusses how to work around this problem. |
| 15751 | This article describes how to enable SQL Server connectivity on Windows XP Service Pack 2. |
| 15752 | You may not be able to connect to an instance of SQL Server that is configured to use the Named Pipes server network library on a computer that is running Windows XP Service Pack 2. This article discusses a workaround for this problem. |
| 15753 | In SQL Server 2000, a collation specifies how strings are compared and sorted, and what character set is used for non-Unicode data. SQL Server 2000 supports two types of collations: SQL collations. Windows collations. For a description of each type... |
| 15754 | This article defines collation and describes how to transfer a database from one collation in Microsoft SQL Server to another collation in SQL Server, either in SQL Server 7.0 or in SQL Server 2000. What is collation? A collation specifies the bit... |
| 15755 | This article describes how to remove a replication from a computer that is running Microsoft SQL Server 2000. To remove a replication, you must drop the subscriptions, the publications, and the distributor that is configured for the replication. You... |
| 15756 | When you use the Push method in Microsoft SQL Server 2000 Windows CE Edition 2.0 (SQL Server CE) Remote Data Access (RDA) to transfer data from a SQL Server CE database table to a remote SQL Server database table, the data transfer may fail. This... |
| 15757 | This article discusses the different ways to dispose of the managed objects in Microsoft SQL Server 2000 Windows CE Edition that are used in applications that you create by using Microsoft Visual Studio .NET that use the Microsoft .NET Compact... |
| 15758 | Microsoft SQL Server 2000 introduces multiple instances. However, client tools such as Query Analyzer or ISQL/W, which are available with previous versions of Microsoft SQL Server, might experience difficulty connecting the non-default Named... |
| 15759 | If you use the SqlCeDataAdapter object to populate a DataSet object, and you do not explicitly call the Dispose method for all the associated SqlCeCommand instances, you may receive the following error message: Error Code: 8007000E Message: Not enough... |
| 15760 | This article discusses various solutions for recovering data from a Microsoft SQL Server database, if a disaster occurs. This article also discusses the advantages and the disadvantages of each solution. Disaster recovery is a process that you can use... |
| 15761 | This article describes how to estimate the size of a Microsoft SQL Server 2000 Windows CE Edition database. However, this estimate cannot be determined with real accuracy because of the following reasons: The size of the system table may vary,... |
| 15762 | This step-by-step article lists the steps you must use to enable SSL encryption for SQL Server 2000 if you have a valid Certificate Server in your network environment. If you have purchased certificates from a third party certificate vendor, follow... |
| 15763 | This article outlines the SQLIOStress utility. You can use this utility to perform stress tests on disk subsystems to simulate Microsoft SQL Server 2000 and Microsoft SQL Server 7.0 read, write, checkpoint, backup, sort, and read ahead activities. The... |
| 15764 | This article describes a Microsoft Visual C# .NET application that you can use to retrieve data from a Microsoft SQL Server 2000 Windows CE Edition database and to save the data in a XML document. This article also describes how to populate a DataGrid... |
| 15765 | SQL Client Tools are not part of the Microsoft Data Engine (MSDE) installation. Therefore, to back up an MSDE database, you can use the Transact-SQL BACKUP DATABASE statement, which is discussed in this article. |
| 15766 | When you use the Microsoft SQL Server Data Transformation Services (DTS) Import Wizard to import data from a Microsoft Excel worksheet, if a text column contains data that could be interpreted as mixed data (for example, alphanumeric characters... |
| 15767 | This article describes how to programmatically specify the client network library in the connection string when you connect to a SQL Server database. In Microsoft Data Access Components (MDAC) 2.6 and later, you can specify the client access library... |
| 15768 | You can use Kerberos authentication with Microsoft SQL Server 2000. SQL Server 2000 supports this functionality as part of a typical Microsoft Windows 2000 Active Directory domain installation. With Microsoft Windows 2000 Service Pack 3 (SP3), you can... |
| 15769 | Both SQL Server authentication (standard security) and Windows NT authentication (integrated security) are SQL Server authentication methods that are used to access a SQL Server database from Active Server Pages (ASP). Note This article does not apply... |
| 15770 | This step-by-step article discusses the steps you can use to change the SQL Server sa (system administrator) password. You can configure Microsoft SQL Server Desktop Engine (MSDE) versions 2000, or earlier, to run in Mixed Authentication mode. The sa... |
| 15771 | This article describes how to run SQL Server stored procedures and use parameters from an Active Server Pages (ASP) page. This article assumes that you are familiar with the procedure to use ActiveX Data Objects (ADO) in an ASP page. |
| 15772 | This article describes how to establish connections to SQL Server in an ASP script by using ActiveX Data Objects (ADO), while taking advantage of the connection pooling feature of ODBC 3.0. |
| 15773 | When you restart SQL Server, or SQL Executive, or the SQL Server Agent, the service may fail to start with the following error message: Error 1069: The service did not start due to a logon failure. |
| 15774 | This step-by-step article describes how to set up a linked server from a Microsoft SQL Server computer to an Oracle database and also provides basic troubleshooting steps for common errors you may encounter when you set up a linked server to Oracle.... |
| 15775 | You can backup the currently active transaction log even if the database file is damaged, provided that the transaction log file is still accessible. On Microsoft SQL Server 7.0, both the primary data file and the transaction log files must be... |
| 15776 | You cannot install SQL Server 2000 on a computer that runs Microsoft Windows Server 2003 and that has Terminal Server installed on a server cluster. After you provide all the correct information to SQL Server 2000 Setup (and provide the VirtualServer... |
| 15777 | This article contains a sample program that was developed in Microsoft Visual Basic .NET for compacting a Microsoft SQL Server 2000 Windows CE Edition (SQL Server CE) database file. The sample program, CompactDB.exe, uses the SqlCeEngine.Compact... |
| 15778 | You may see the following error when you add a Microsoft Windows NT user or a Microsoft Windows NT group as a login to Microsoft SQL Server, or when you move logins from a server in one domain to a server in a different domain: Error 15401: Windows NT... |
| 15779 | http://www.microsoft.com/sql/downloads/ce/sp3.asp If you install the Microsoft Internet Information Server (IIS) Lock Down Tool with all the default options, it may break a working Microsoft SQL Server 2000 Windows CE (SQL Server CE) Remote Data... |
| 15780 | When SQL Server starts on a computer that is running Microsoft SQL Server 2000, the SQL Server program always attempts to register the virtual server in the Active Directory. You may see the following warning in the Microsoft Windows NT Event Log:... |
| 15781 | This step-by-step article describes how to establish a connection to Microsoft Desktop Engine (MSDE). MSDE uses two authentication modes: Windows Authentication Mode (Windows Authentication) In Windows Authentication Mode, a user can connect through a... |
| 15782 | When you run a linked server query that is configured to use Microsoft OLE DB provider for Jet 4.0, the query might fail and you receive the following error message: Error 7399: OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB... |
| 15783 | This step-by-step article demonstrates how to install a certificate on a that is running SQL Server 2000 by using Microsoft Management Console (MMC) and describes how to enable SSL Encryption at the server, or for specific clients. NOTE : You cannot... |
| 15784 | When you perform a database backup to disk or tape, or a restore from disk or tape, the following error message may occur: SQL Server 7.0 Server: Msg 3266, Level 16, State 1, Line 1 The Microsoft Tape Format (MTF) soft filemark database on backup... |
| 15785 | This step-by-step article describes several methods that you can use to control access to a database that is published on an Internet Information Services (IIS) 6.0-based Web server. Use Security Features in the Database Use the built-in security... |
| 15786 | This article outlines some of the basics about Microsoft SQL Virtual Server Client connections. |
| 15787 | This article is a basic guide for troubleshooting linked server error 7391. The article contains guidelines and directions to determine the cause and resolution for this error. However, this is not a complete list, and some problems may be specific to... |
| 15788 | When you run a DBCC SHRINKFILE command in SQL Query Analyzer to shrink the specified transaction log file of a database, the transaction log file does not shrink, and you may receive the following error message: Cannot shrink log file transaction log... |
| 15789 | When a database is in the full recovery model, and you try to back up the transaction log files with either a NO_LOG or TRUNCATE_ONLY option, the following message is logged in the Application Log of the Event Viewer: Event Type: Error Event Source:... |
| 15790 | This article lists the possible lastwaittype values, their associated waittype values, and a brief description of their meaning. |
| 15791 | You can use the SqlCeDataReader class to read a forward-only stream of data rows from a data source. To use the SqlCeDataReader class, you must include a reference to the System.Data.SqlServerCe namespace. The SQlCeDataReader class is an alternative... |
| 15792 | When dealing with Unicode string constants in SQL Server you must precede all Unicode strings with a capital letter N, as documented in the SQL Server Books Online topic Using Unicode Data. The N prefix stands for National Language in the SQL-92... |
| 15793 | In SQL Server 2000, you can add, delete, and rename the data files and the transaction log files. This article explains how to consolidate physical files, and how to rename the logical file name in SQL Server 2000. |
| 15794 | SQL Server only uses 2 gigabytes (GB) of memory even though SQL Server is configured to use the Microsoft Windows 2000 Address Windowing Extensions (AWE) API to support a maximum of 64 GB of physical memory when the awe enabled option is set to 1.... |
| 15795 | When you fail over the SQL Virtual Server to another node and then fail back to the original node, SQL Virtual Server sometimes fails to bind to the port on which it is listening. SQL Virtual Server then also fails to accept incoming connections on... |
| 15796 | If any task in a Database Maintenance plan fails or encounters an error message, the maintenance plan job itself may show as failed. The Job History Details shows the following error message: sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed. However, this does not necessarily |
| 15797 | This article serves as a basic guide for troubleshooting Microsoft SQL Server merge replication problems. The article provides guidelines and directions to determine the cause and resolution of some merge replication problems. However, this is not a... |
| 15798 | When you use SQL Server 2000 to obtain live data for a Crystal Report in a Visual Studio .NET Web application, the Crystal Report fails to log on to the database. This occurs even if you provide accurate credentials at design time. You rece |
| 15799 | SQL Server does not exist or access denied is a generic Microsoft Data Access Components (MDAC) message that indicates that the SQL Server cannot be contacted. This generic message has many potential causes. Some of the most common causes are... |
| 15800 | Some applications (especially those that are Web based) must deal with Unicode data that is encoded with the UTF-8 encoding method. SQL Server 7.0 and SQL Server 2000 use a different Unicode encoding (UCS-2) and do not recognize UTF-8 as valid |
| 15801 | When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory availa |
| 15802 | This article describes how to identify your current SQL Server version number and corresponding product or service pack (SP) level. It also describes how to identify the specific edition if you are using SQL Server 7.0 or SQL Server 2000. |
| 15803 | After you install Cluster Server on Windows 2000 Advanced Server and configure Internet Information Services (IIS) or SQL Server, you may need to manually install Microsoft Distributed Transaction Coordinator (MSDTC) as a cluster instance. |
| 15804 | This article explains how you can prevent Microsoft Windows NT system administrators from having system administrator (sa) privileges in SQL Server. |
| 15805 | You cannot restore a backup of a system database ( master , model or msdb ) on a server build that is different from the build on which the backup was originally performed. An attempt to perform such a restore causes the following error |
| 15806 | Files or filegroups in a database can be backed up and restored individually. This allows you to restore only the damaged files without having to restore the rest of the database. Files in a filegroup backup can be restored individually or as a |
| 15807 | When you try to start a SQL Server service, the service may fail because the tempdb database is marked suspect. You may see the following text in the SQL Server error log: 2001-02-08 14:04:07.64 spid1 Clearing tempdb database. |
| 15808 | This step-by-step article describes the steps you must use to change domains for an existing SQL Server 2000 Failover Cluster. |
| 15809 | This step-by-step article demonstrates how to import data from Microsoft Excel worksheets into Microsoft SQL Server databases by using a variety of methods. |
| 15810 | This article describes the following configuration settings and considerations for their use: |
| 15811 | This step-by-step article describes how to move SQL Server user databases and most common SQL Server components between computers that are running SQL Server. |
| 15812 | Many different variations of licensing are available for SQL Server. This article provides resources that you can use to help you decide which licensing models are appropriate for your environment. |
| 15813 | When you move a database from one SQL Server server to another SQL Server server, there may be a mismatch between the security identification numbers (SIDs) of the logins in the |
| 15814 | SQL Server 7.0 and SQL Server 2000 restructure and redesign the logging and data algorithms from earlier Microsoft SQL Server releases to improve data reliability and integrity. |
| 15815 | The default |
| 15816 | The SQL Server service may fail to start and you may receive the following error messages in the SQL Server error logs or in the event viewer application log of the computer: spid5 Clearing tempdb database. spid5 Encountered an |
| 15817 | A computer may stop responding (hang), or a time out or some other disruption of normal operations may occur at the same time that SQL Server writes buffer latch errors to the SQL Server error log. The error messages that occur as a result of a |
| 15818 | Attempts to bring a SQL Server 2000 virtual instance online on a cluster may fail, or the SQL Server 2000 virtual instance on the cluster may come online successfully, but the SQL Server 2000 virtual instance on the cluster will only listen |
| 15819 | You may see either one of the following error messages when you execute a linked server query: |
| 15820 | This article discusses three methods you can use to shrink the |
| 15821 | This article describes how to rebuild a broken MSDTC installation for use with a failover clustered SQL installation and how to move the MSDTC clustered resource to a new group. |
| 15822 | This article provides you with some basic guidelines regarding: |
| 15823 | Databases often store hierarchical information. For more details about hierarchical information, refer to the "Expanding Hierarchies" topic in Microsoft SQL Server Books Online. The "Expanding Hierarchies" topic has a detailed Transact-SQL |
| 15824 | Row numbering or ranking is a typical, procedural issue. The solutions are generally based on loops and temporary tables and, therefore, SQL Server loops and cursors. This article describes how to dynamically rank rows when performing a SEL |
| 15825 | INF: How to Rotate a Table in SQL Server The information in this article applies to: Microsoft SQL Server versions 6.0, 6.5, 7.0 Microsoft SQL Server 2000 (all editions) This article describes how you can rotate a SQL Server table. Suppose you have a table named QTRSALES with |
| 15826 | It is often desirable to simulate a cursor-like FETCH-NEXT logic in a stored procedure, trigger, or Transact-SQL batch. This article will discuss various methods for accomplishing this task. |
| 15827 | Starting with SQL Server 7.0 Service Pack 2 (SP2), SQL Server adds a new warning message expressing the wait state of worker threads on the assigned UMS scheduler. When all worker threads for a given UMS scheduler are in a wait state, it is possible |
| 15828 | The opportunity to trap error and warning messages sent to a client from the SQL Server can provide powerful information when you are tracking down a problem. |
| 15829 | After you move databases to a new server, users may not be able to log in to the new server: |
| 15830 | This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server: slow performance of a specific query or group of queries. If you are troubleshooting a performance issue, but have no |
| 15831 | This article deals with one specific type of performance issue that applications may experience with Microsoft SQL Server -- slow performance of a large number of concurrent ad hoc queries. If you are troubleshooting a performance issue, bu |
| 15832 | Microsoft SQL Server 6.5 or later provides the capability to load and run custom Component Object Model (COM) objects through a set of OLE Automation stored procedures or through extended stored procedures. By default, DLL-based COM objects |
| 15833 | This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database. |
| 15834 | 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 |
| 15835 | When you set up SQL Server to run under a Microsoft Windows NT account and you grant permissions to the selected service account through the operating system, SQL Server sets permissions on certain files, directories and registry keys. If y |
| 15836 | This article describes how to configure SQL Server to use more than 2 GB of physical memory. |
| 15837 | This article describes the procedure to grant access to a database that has been loaded in STANDBY state from another server when the "guest" user is disabled because of security reasons. The information in this article applies only to SQL |
| 15838 | The newly-introduced statistical maintenance functionality, AutoStat, may generate unwanted overhead on a production system by performing one of the following actions: |
| 15839 |
|
| 15840 | Data that is expressed in XML can be loaded into a SQL Server 2000 database by using the XML Bulk Load component. This article outlines the steps that you need to follow to load XML data into a table that already exists in the database. |
| 15841 | After a |
| 15842 | This guide assists you in developing your Microsoft Internet Information Server (IIS) and SQL Server security plan for mobile devices. As mobile applications begin to increase in number, a solid plan can help avoid some of the pitfalls in s |