SQL 2005 Known Issues 32-bit and 64-bit Windows and SQL Server Environment witk Microsoft KB Article links

SQL 2005 & 2008 General Known problems - all editions
Troubleshooting utilities and information
Microsoft Support Knowledge Base for SQL Server 2005 / SQL Server 2005 Beta
Search the MSDN Product Feedback Center for known bugs
917825 - How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005
SQL Server Error Messages
233332 - How to run the SQLdiag utility on a clustered instance of SQL Server or on virtual SQL Server
913090 - A list of the bugs that have been fixed in SQL Server 2005 Service Pack 1
921896 - A list of the bugs that are fixed in SQL Server 2005 Service Pack 2
window.google_render_ad();

Backup and restore issues
911847 - 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
910067 - 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
914171 - 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"
915385 - A snapshot-based database backup restore process may fail, and you may receive an error message in SQL Server 2005
927797 - You cannot specify a USB-based tape drive as a backup device in SQL Server 2005 and in SQL Server 2000
923355 - 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"
928317 - 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
931640 - Error message when you try to upgrade a SQL Server 2000 database to a SQL Server 2005 database: "Database '' cannot be upgraded because it is read-only or has read-only files"
937683 - Error message when you try to restore a database by using SQL Server Management Studio in SQL Server 2005 after you use the Backup tool: "Restore failed for Server '' (Microsoft.SqlServer.Smo)"
943471 - Error message when you create a snapshot backup of many databases at the same time in SQL Server 2005: "ERROR Selected writer 'Microsoft Writer (Service State)' is in failed state"
943635 - You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server 2005
951288 - SQL Server records a backup operation in the backupset history table when you use VSS to back up files on a volume
951289 - The VSS application stops responding when you perform a backup operation on a server that is running a SQL Server 2005 failover cluster

Data import and export issues
913401 - An export operation fails when you try to perform a site deployment export operation to SQL Server 2005 in Content Management Server 2002 SP1a
918362 - The data import process may take a long time to be completed when you use the Microsoft OLE DB Provider for DB2 1.0 that is included with the SQL Server 2005 Feature Pack to perform bulk imports of IBM DB2 data
920809 - 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"
952111 - The identity column of the destination table does not contain the same identity values as the source table after you use SQL Server Management Studio to import data or to export data in Microsoft SQL Server 2005

Replication, subscription
911305 - Replication agent jobs may fail after you change the SQL Server Agent service startup account by using the Windows Service Control Manager in SQL Server 2005
922767 - Subscription distribution may fail after you synchronize a subscription in SQL Server 2005
928320 - You cannot use existing tables on a heterogeneous subscriber database when you configure a push subscription to a heterogeneous subscriber in SQL Server 2005
933838 - Additional updates and additional inserts may be performed during synchronization when the merge publication contains join filters in SQL Server 2005
935563 - You receive syntax error messages when you use transactional replication in SQL Server 2005
945066 - SQL Server 2005 does not validate all articles in a transactional publication when you run the sp_publication_validation stored procedure to validate the articles
949296 - Some SQL Server replication agents cannot run when you configure many replication agents to run on a server
950735 - Error message when you use the Configure Web Synchronization Wizard to configure the virtual directory against a server that is running IIS 7.0: "IIS was not found on the Web Server. Please specify a computer name that has IIS installed"
953201 - You receive a "Creating the partitioned snapshot" message when you create a pull subscription that is configured to receive the precomputed partition of a merge publication in SQL Server 2005

Database mirroring
926900 - The SQL Trace entries may be incorrect when you trace an instance of SQL Server 2005 that is configured to use database mirroring
937531 - The shrink operation is not duplicated on the mirror database when you use database mirroring in SQL Server 2005
940254 - Error message when you try to set a witness in a database mirroring session in SQL Server 2005: "The ALTER DATABASE command could not be sent to the remote server instance 'TCP://:'"

Database Mail
931175 - BUG: Error message when you use Database Mail in SQL Server 2005: "Error 14667, Severity 16, State 1"
931631 - 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"

DBCC errors
909003 - 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)"
919155 - 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"
923247 - Troubleshooting DBCC error 2570 in SQL Server 2005
926070 - Error messages may be logged in the SQL Server error log after you run a DBCC command in SQL Server 2005
928518 - 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"
953503 - The DBCC CHECKDB statement does not raise exceptions in SQL Server when the DBCC CHECKDB statement detect a consistency error in the database
954467 - You do not receive an error message when you run the DBCC CHECKDB statement against a database in SQL Server, but an access violation occurs when you run a query on a table in the database

DTS issues
904796 - You cannot run or schedule various packages that require SQL Server 2000 Meta Data Services files after you upgrade to SQL Server 2005
915189 - Error message when you try to edit the connection manager for a migrated package in SQL Server 2005: "The specified provider is not supported"
917420 - BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package
919131 - 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
921929 - BUG: 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

Account problems
324321 - How to troubleshoot error 15401 (..user or group '%s' not found..)
303411 - You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user
915180 - You can no longer enlist the target server into the master server after you change the service account for the SQL Server Agent service
918040 - 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
918346 - The user is not assigned to a default schema when you use Windows authentication to connect the user to SQL Server 2005
922549 - The SQL Server login name is not updated in the sys.syslogins catalog compatibility view after you change the computer name
955506 - Error message when you add a node to a SQL Server 2005 failover cluster on the Service Account page of the SQL Server 2005 Setup Wizard: "SQL Server Setup could not validate the service accounts"

Management Studio /database maintenance issues
915849 - Error message when you try to modify a large table by using SQL Server Management Studio: "Timeout expired"
922214 - 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'"
922651 - BUG: 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)"
925719 - BUG: 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
945068 - Some visual elements in SQL Server Management Studio lose functionality when you register many instances of SQL Server
953119 - A CROSS JOIN clause is automatically inserted into an UPDATE statement that uses an INNER JOIN clause when you execute the statement in the SQL pane of SQL Server Management Studio
938085 - A clean-up task does not delete database maintenance plan reports after you install SQL Server 2005 Service Pack 2
953118 - Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2
921089 - 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"
945067 - Error message when you run a maintenance plan after you set the "allow updates" option to 1 in SQL Server 2005: "Alter failed for server"
953122 - A tape device is not detected by SQL Server Management Studio in SQL Server 2005 or by SQL Server Enterprise Manager in SQL Server 2000

Misc. issues
231347 - SQL Server databases not supported on compressed volumes
558119 - Event ID 7000 appears in the System log while starting SQL 2005 Server
904803 - Character data is represented incorrectly when the code page of the client computer differs from the code page of the database in SQL Server 2005
912397 - 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
914261 - Error message when you run the ALTER SERVICE MASTER KEY REGENERATE statement in SQL Server 2005: "The current master key cannot be decrypted"
915848 - You obtain inconsistent version information after you install SQL Server 2005 Service Pack 1
917135 - You receive an access violation error message when you use the Microsoft Application Verifier to monitor the Sqlservr.exe program for SQL Server 2005
919395 - BUG: 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
922658 - SQL Server 2000 or SQL Server 2005 may temporarily stop responding on a Windows Server 2003 Service Pack 1-based computer
923827 - 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
924947 - SQL Server significantly increases the unused space for some tables
926899 - 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
928779 - 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
929666 - 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
932288 - Error message when you use a number that is more than 28 in the common language runtime for SQL Server 2005: "System.OverflowException: Conversion overflows"
932897 - 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"
933248 - 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
937685 - Error message when you register an assembly in SQL Server 2005: "CREATE ASSEMBLY for assembly 'Microsoft.SqlServer.Smo' failed because assembly 'microsoft.sqlserver.batchparser' is malformed or not a pure .NET assembly"
937757 - Error message when you run the ALTER SCHEMA statement in SQL Server 2005: “The object with name '' already exists”
937950 - Explanation of error 3928 in SQL Server 2005 and in SQL Server 2000
941105 - Error messages after SQL Server 2005 has been running for some time: "Failed to load FileName.dll" and "Attempts to load any type of dll might fail within the SQL Server process with errors pointing to LoadLibrary failure"
941152 - Error message when you run a distributed query against a loopback linked server in SQL Server 2005: "Transaction context in use by another session" or "MS DTC has cancelled the distributed transaction"
941823 - Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration
942211 - Error message when you use OLE DB Provider for SQL Server to update rows on a Windows Server 2003 Service Pack 2-based computer: "Incorrect syntax near the keyword 'WHERE'"
945142 - The query result is corrupted or incomplete when an application uses Microsoft ODBC driver for SQL Server to query a SQL Server database
945539 - SQL Server 2005 cannot index some 2007 Office document formats
948209 - Error message when you use a symmetric key to decrypt data in a SQL Server 2005 database: "The decryption key is incorrect"
948594 - Problems occur on a server that is running SQL Server 2005 when you upgrade Windows Server 2003 Service Pack 2 to Windows Server 2008
949080 - Error message when you execute a CLR routine or use an assembly in SQL Server 2005: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"
951574 - Error message when you update a table column that is a foreign key in SQL Server 2005: "Internal Query Processor Error: The query processor could not produce a query plan"
952734 - Error message when you run the bcp utility to copy a result set of a stored procedure that contains a dynamic query in SQL Server 2005: "BCP host-files must contain at least one column"

64-bti SQL Server specific issues
906954 - You may receive an error message when you try to run distributed queries from a 64-bit SQL Server 2005 client to a linked 32-bit SQL Server 2000 server

SQL2008 specific issues
954920 - When an application requests a result set from new SQL Server 2008 collations, you may receive an "MSG 40242" or "MSG 40205" error when the ODBC driver for SQL Server is used or an "MSG 40234" error when the SQL OLE DB provider is used