64-bit specific issues (OS and SQL)
- 2009214 - Collection sets running under proxy account will fail in WOW environment
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
- 955280 - A Transact-SQL statement randomly fails to commit and causes data corruption in Windows Server 2003 or in Windows XP Professional x64 Edition when you use the statement to operate on a FILESTREAM column in SQL Server 2008
- 970410 - Data Collection is disabled after applying Service Pack 1 for SQL Server 2008
- 970876 - You may get "Error 1316.A network error occurred while attempting to read from the file Path\SSCERuntime-ENU.msi" error message when you repair an instance SQL Server 2008
- 2014053 - A memory leak occurs in FDHOST.exe process in SQL Server 2008 on a Windows Server 2003 Domain Controller
- 2014749 - You cannot load a thesaurus file in SQL Server, and you receive the following error message: "ERROR_INTERNAL_DB_CORRUPTION"
- 2019126 - A Data Collector collection set may fail to upload if a cache file is corrupted
- 2003450 - You encounter SQL Server error 17308 after you enable TDE on one of your databases in SQL Server
Backup and restore issues
- 951288 - SQL Server records a backup operation in the backupset history table when you use VSS to back up files on a volume
- 2014054 - Backing up a SQL Server database using a VSS backup application may fail for some databases
- 2022254 - SQL Server may report 18272 error during restore operations
Replication, subscription
- 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"
- 969159 - SQL Server 2005 and SQL Server 2008 Websync Internet timeouts may not show any symptoms in Replication Monitor
- 972006 - Error message when you try to batch insert data on a publisher of a merge replication in SQL Server 2008 or SQL Server 2005: "Msg 548, Level 16, State 2, Line 1. The insert failed"
- 2000228 - The distribution agent may experience high latency when you configure transactional replication with articles that are configured not to replicate changes as parameterized statements
- 2000383 - Error message when the Distribution Agent tries to apply to the initial snapshot to an Oracle 11g subscriber: “ORA-00932: inconsistent datatypes”
- 2002474 - Parameterized ALTER TABLE statement to switch a partition may fail for a database that is published for transactional replication in SQL Server 2008
- 2003609 - Schema changes are repeatedly enumerated by merge agent during synchronization operation of merge replication in SQL Server
Database mirroring, Logshipping
- 2006312 - Logshipping monitor incorreclty raises error number 14420 instead of 14421 when the secondary database is out of sync
- 978947 - A non-yielding issue may cause a database mirroring failover in SQL Server 2005 and in SQL Server 2008
Database Mail
- 2002452 - The formatting of the columns is incorrect when using Excel to view csv file attachments sent from SQL Server's Database Mail
- 2008286 - Error message when you use Database Mail after applying service pack: “System.IndexOutOfRangeException: timeout”
DBCC errors
- 2015748 - How to troubleshoot database consistency errors reported by DBCC CHECKB
- 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
- 960791 - Error message when you run the DBCC CHECKDB command on a computer that contains a SQL Server database: "Error 8967"
- 2002606 - OS Errors 1450 and 665 are reported for database data files
DTS issues
- 917420 - BUG: You receive an error message when you use the Package Migration Wizard to migrate a DTS package
- 962874 - In SQL Server 2005 or 2008, the DTS designer application cannot be started on a Windows Vista-based computer or on a Windows Server 2008-based computer
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
- 922549 - The SQL Server login name is not updated in the sys.syslogins catalog compatibility view after you change the computer name
- 972387 - SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the non-owner node
- 2002062 - Users experience login issues to SQL Server when Logon Triggers are enabled
Server Management Studio / Visual Studio and database maintenance issues
- 915849 - Error message when you try to modify a large table by using SQL Server Management Studio: "Timeout expired"
- 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)"
- 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
- 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"
- 983332 - You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010
failover cluster issues
- 2216476 - "Value does not fall within the expected range" error when you install Clustered Analysis Services on a server that is running SQL Server 2008
- 2000403 - SQL Server 2005 cluster resources fail after a side by side installation of SQL Server 2008 on a Windows Server 2008
- 2019402 - "No mapping between account names and security IDs was done" error when adding a node to a SQL Server 2008 Failover Cluster
Misc. issues
- 968759 - SQL Server fails to start if NIC has multiple IP address
- 231347 - SQL Server databases not supported on compressed volumes
- 924947 - SQL Server significantly increases the unused space for some tables
- 945142 - The query result is corrupted or incomplete when an application uses Microsoft ODBC driver for SQL Server to query a SQL Server database
- 971249 - Microsoft ODBC drivers can return unexpected results when using parameter markers after any function in a T-SQL Statement
- 970878 - You may receive a "FCB::RemoveAlternateStreams: Operating system error <error number>" when starting up databases on an instance of SQL Server 2005 or SQL Server 2008
- 2000471 - You may notice a continuous growth in tempdb data file size with a corresponding increase in mixed_extent_page_count after upgrading SQL server
- 2007728 - You get "The certificate received from the remote server was issued by an untrusted certificate authority" error message when using SSL with SQL server
- 2019779 - You may receive incorrect values when using SCOPE_IDENTITY() and @@IDENTITY
|
