My Journey with Microsoft SQL Server as SQL Server DBA!
Stories on Issues Faced, Struggled, Hacked, Profiled, Troubleshooted, Resolved, Fixed and .... Restarted!
Wednesday, December 10, 2008
Known Issues to note before planning to migrate/upgrade to SQL 2005 64-bit on Windows 2003 64-bit server (EM64 or x64, IA64)
New link has updated document with more precise known issues.
Please click on link below to access the new document.
http://www.sqlserverdba.co.cc/2009/03/sql-server-32bit-to-64-bit-migration.html
Thanks!
Microsoft SQL Server installation errors and troubleshooting steps - 2000, 2005, 2008 32-bit 64-bit EM64 or IA64
907284 - Changes to the readme file for SQL Server 2005
910229 - SQL Server 2005 Express Edition Readme
905395 - A change to the Readme.htm file for SQL Server 2005 Mobile Edition
910070 - The SQL Server 2005 Setup program may take a very long time to be completed
916760 - 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
915846 - Best practices for setting up domain groups when you install a SQL Server 2005 cluster
910230 - How to install SQL Server 2005 Analysis Services on a failover cluster
910233 - Migrate a SQL Server 2000 Analysis Services cluster to a SQL Server 2005 Analysis Services cluster
934164 - How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer
918481 - How to install Microsoft Operations Manager (MOM) 2005 Service Pack 1 databases and MOM 2005 Reporting on a computer that has Microsoft SQL Server 2005 installed
924000 - How to upgrade the initial release of Windows Small Business Server 2003 R2 to include the final release version of SQL Server 2005 Workgroup Edition
926824 - How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring
941232 - How to apply a hotfix for SQL Server 2005 in a replication topology
Known installation problems
Upgrade errors
876234 - How to troubleshoot the installation of SQL Server 2008 CTP or the upgrade to SQL Server 2008 CTP
914158 - 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
936892 - Error message in the SQL Server Errorlog file after you upgrade SQL Server 2000 to SQL Server 2005 on a server that is running Windows Server 2003: "Unable to update password policy"
953741 - SQL Server 2005 installers stop dependent services
953739 - SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled state
Vista and Windows 2008 installation errors
936302 - List of known issues when you install SQL Server 2005 on Windows Server Code Name "Longhorn"
920201 - You receive a warning message on the System Configuration Check page of the SQL Server 2005 Setup program on a computer that is running Windows Vista or a Server Core installation of Windows Server "Longhorn"
929105 - Error message when you install SQL Server 2005 Express Edition Service Pack 1 in Windows Vista: "Windows NT user or group '
929150 - 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
934750 - Some shared components are not installed in the correct folder when you install SQL Server 2005 Express Edition on a computer that is running a 64-bit version of Windows Vista
938245 - How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server code name "Longhorn"
947986 - Error message when you install SQL Server 2005 on a Windows Server 2008-based RODC: "Failure creating local group SQLServer2005SQLBrowserUser$
948210 - Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster
955966 - SQL Server Compact 3.5 Service Pack 1 Server Tools are not installed in WOW mode when you run IIS 7.0 on a 64-bit Windows Server 2008-based computer or on a 64-bit Windows Vista-based computer
Express Edition installation errors
921110 - 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"
919392 - 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"
920114 - 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"
929589 - Error message when you install SQL Server 2005 Express Edition with Advanced Services: "SQL Server Setup failed to retrieve the SSL Certificate Name"
933833 - BUG: Error message when you install SQL Server 2005 Express Edition with Advanced Services: "An installation package for the product Microsoft SQL Server Native Client cannot be found"
Mobile / Compact Edition installation issues
909751 - The NorthwindOleDb sample application is not available when you install SQL Server Mobile Edition from a SQL Server 2005 installation
945317 - A file and some registry entries are missing when you upgrade SQL Server Compact 3.5 Beta to SQL Server Compact 3.5
64-bit installation errors
907261 - BUG: 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
908454 - 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
936491 - After you install a 64-bit version of SQL Server 2005 on a 64-bit version of Windows, the 32-bit entries for SQL Native Client Configuration and for SQL Server 2005 Network Configuration appear in SQL Server Configuration Manager
937684 - You may be prompted to restart the computer after you install the 64-bit version of SQL Server 2005 Service Pack 2 even if the Setup program does not report that some components are locked
Cluster installation errors
910851 - You receive error messages when you try to set up a clustered instance of SQL Server 2005
913815 - Error message when you install a SQL Server 2005 failover cluster on a node: "The drive specified cannot be used for program location"
926621 - Error message when you try to install SQL Server 2005 in a cluster environment: "SQL Server Setup could not validate the service accounts"
934749 - BUG: Error message when you try to install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 from the existing active node: "The product instance
943525 - You cannot start the SQL Server Agent service of a failover cluster of SQL Server 2005 if the build of SQL Server build is 3179 or a later build
945937 - The SQL Server 2005 Setup program generates an incorrect error message when you install a SQL Server 2005 failover cluster and the Setup program cannot access the cluster resource
948208 - An additional resource group that contains no resources is created after you install a second failover clustered instance of SQL Server 2005 on a Windows Server 2008-based server
948210 - Problems occur in Windows Server 2008 after you uninstall a SQL Server 2005 failover cluster, or after you install SQL Server 2005 Service Pack 2 or a Service Pack 2-based hotfix on a SQL Server 2005 failover cluster
SP / hotfix package installation problems
925976 - 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"
929151 - A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005
932011 - BUG: The Installation Progress dialog box displays a status of Failure for the Database Services component when you install SQL Server 2005 Service Pack 1 or SQL Server 2005 Service Pack 2 on an instance of SQL Server 2005
932012 - Only the "Backward Compatibility" component is selected on the "Feature Selection" page when you install a localized version of SQL Server 2005 SP2
932869 - 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"
934652 - You cannot install SQL Server 2005 Service Pack 2 on a computer that is running SQL Server 2005 Reporting Services after you install the .NET Framework 2.0
935297 - SQL Server Setup fails unexpectedly when you try to install SQL Server 2005 Service Pack 2
935371 - Error message when you install SQL Server 2005 SP2, SQL Server Express SP2, or SQL Server Express with Advanced Services SP2: "SQL Server Setup failed to execute a command for server configuration. CREATE DATABASE failed"
936488 - When you install a SQL Server 2005 service pack or a SQL Server 2005 hotfix, the installation stops unexpectedly
940971 - SQL Server 2005 Service Pack 2 installation fails, and a "The Transaction Manager is not available" error message is logged in the Summary.txt file
947988 - You cannot install SQL Server 2005 Service Pack 1 on a SQL Server 2005 failover cluster if the failover cluster is behind a firewall
947989 - You cannot install SQL Server 2005 Service Pack 2 when the database file of the Resource database is not in the same folder as the log file of the Resource database
957008 - SQL Server 2005 Service Pack 2 is not successfully updated when you try to install or to uninstall security update KB948108 or security update KB948109
Misc. installation errors
908503 - Description of the "Error 1619 installing sqlncli.dll" error message that you may receive when you install SQL Server 2005
911936 - 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
917827 - Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"
918685 - Error message when you install SQL Server 2005: "The file C:\Windows\Microsoft.NET\Framework\Meaningless_string\mscorlib.tlb could not be loaded"
919398 - Error message when you try to install SQL Server 2005: "Could not find a package to install on the installation media"
919944 - Error message when you try to modify or reinstall the existing installation of SQL Server Native Client: "The file 'Folder\sqlncli.msi' is not a valid installation package for the product Microsoft SQL Server Native Client"
921902 - 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
922669 - 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"
927230 - You may receive an error message when you try to install the UDDI Services database components on an instance of SQL Server 2005 that is running on a Windows Server 2003-based computer
933945 - Issues that you may encounter when you install a named instance of one or more SQL Server 2005 components and specify different installation locations for one or more of the components
934012 - Error message when you try to install SQL Server 2005 on a volume mount point: "There is not enough space on the destination disk for the current SQL Server installation"
945935 - Error message when you install the WOW version of SQL Server 2005 on a 64-bit operating system: "Windows Installer has stopped working"
948907 - You receive error messages after you uninstall SQL Native Client from a server that is running SQL Server 2005
954835 - You cannot install SQL Server 2005 on a server when the number of processors of the server is not a power of 2
955500 - Error message when you try to install an instance of SQL Server 2005 on a computer that has an instance of SQL Server 2008 already installed: "An instance with the same name is already installed on this computer"
Uninstalling previous versions / hotfix packages
290991 - How to manually remove SQL Server 2000 default, named, or virtual instance
909967 - How to uninstall an instance of SQL Server 2005 manually
How do I remove previous versions of SQL Server 2005 / Whidbey? - on ASPFAQ.com
915854 - You receive an error message when you try to uninstall the second named instance of SQL Server 2005
955250 - Error message when you try to uninstall a SQL Server 2005 Express Edition hotfix package: "1731 The source installation package for the product [2] is out of sync with the client package"
922209 - The SQL Server 2005 Setup program does not remove all IP address cluster resources when you uninstall SQL Server 2005
909953 - How to uninstall SQL Server Management Studio
How to: Uninstall SQL Server Express
922670 - 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
290301 - Description of the Windows Installer CleanUp Utility
How to uninstall an application when it does not appear in Add/Remove Programs
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 '
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 '
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 '
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