SQL Server 2005 articles, fixes and updates - Year 2005

This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 that have been released in Year 2005. The list is daily updated.

• 328383 SQL Server clients may change protocols when the client computers try to connect to an instance of SQL Server Q328383 KB328383 December 30, 2005
• 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 December 30, 2005
• 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 Q911847 KB911847 December 29, 2005
• 314530 Error message when you execute a linked server query in SQL Server: "Timeout Expired" Q314530 KB314530 December 29, 2005
• 268481 A SQL Server backup is invalid when the backup is performed on a computer that is configured to use a DPT RAID controller card Q268481 KB268481 December 28, 2005
• 183692 SQL Server Setup program stops responding after you copy the files successfully Q183692 KB183692 December 28, 2005
• 912412 Error message when you use Service Broker or database mirroring to connect to an instance of SQL Server 2005: "Connection handshake failed" Q912412 KB912412 December 27, 2005
• 316005 How to import XML into SQL Server with the XML Bulk Load component Q316005 KB316005 December 23, 2005
• 308737 How to identify the cause of recompilation in an SP:Recompile event Q308737 KB308737 December 23, 2005
• 298475 How to troubleshoot SQL Server performance issues Q298475 KB298475 December 23, 2005
• 295108 Incomplete transaction may hold large number of locks and cause blocking Q295108 KB295108 December 23, 2005
• 280106 How to set up and troubleshoot a linked server to an Oracle database in SQL Server Q280106 KB280106 December 23, 2005
• 274750 How to configure SQL Server to use more than 2 GB of physical memory Q274750 KB274750 December 23, 2005
• 263889 Description of SQL Server blocking caused by compile locks Q263889 KB263889 December 23, 2005
• 911821 Item labels in the SQL Server Integration Services toolbox window may appear in an incorrect language Q911821 KB911821 December 22, 2005
• 314520 How to pass a variable to a linked server query Q314520 KB314520 December 22, 2005
• 309256 How to troubleshoot SQL Server error 8645 Q309256 KB309256 December 22, 2005
• 321247 How to configure security for SQL Server log shipping Q321247 KB321247 December 21, 2005
• 307487 How to shrink the tempdb database in SQL Server Q307487 KB307487 December 21, 2005
• 910892 SQL Server 2005 Notification Services does not start successfully when you restart the computer Q910892 KB910892 December 20, 2005
• 828339 Error message 823 may indicate hardware problems or system problems in SQL Server Q828339 KB828339 December 20, 2005
• 288577 How to troubleshoot problems that occur when you use a Database Maintenance plan in SQL Server Q288577 KB288577 December 20, 2005
• 248915 How to show expanding hierarchies by using SQL Server Q248915 KB248915 December 20, 2005
• 111401 How to iterate through a result set by using Transact-SQL in SQL Server Q111401 KB111401 December 20, 2005
• 911838 How to measure the rate at which rows pass through a particular data flow task in a SQL Server 2005 Integration Services (SSIS) package Q911838 KB911838 December 16, 2005
• 243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions Q243589 KB243589 December 15, 2005
• 217395 You receive an "Error 18482" error message when you try to make a remote procedure call (RPC) from one server to another in SQL Server Q217395 KB217395 December 15, 2005
• 175574 How to rotate a table in SQL Server Q175574 KB175574 December 15, 2005
• 300488 How to run SQL Server stored procedures from an ASP Page Q300488 KB300488 December 14, 2005
• 294453 How to set up SQL Server to listen on multiple static TCP ports Q294453 KB294453 December 14, 2005
• 322112 Comparing SQL collations to Windows collations Q322112 KB322112 December 13, 2005
• 321836 How to retrieve a specific table or rows from database backups or transaction log backups in SQL Server Q321836 KB321836 December 13, 2005
• 262973 "Possible thread starvation detected" message may be reported in the SQL Server error log when all worker threads for a particular UMS scheduler are in a wait state in SQL Server Q262973 KB262973 December 13, 2005
• 75722 How to reduce lock contention in SQL Server Q75722 KB75722 December 13, 2005
• 329133 Description of error message 14420 and error message 14421 that occur when you use log shipping in SQL Server Q329133 KB329133 December 10, 2005
• 298568 How to rebuild the master database on a virtual SQL Server instance Q298568 KB298568 December 10, 2005
• 839269 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 Q839269 KB839269 December 9, 2005
• 818182 You receive an "Unspecified error" error message when SQL Server accesses a linked server that uses Microsoft OLE DB provider for Jet 4.0 Q818182 KB818182 December 9, 2005
• 303722 How to grant access to SQL logins on a standby database when the guest user is disabled in SQL Server Q303722 KB303722 December 8, 2005
• 243588 How to troubleshoot the performance of Ad-Hoc queries in SQL Server Q243588 KB243588 December 8, 2005
• 272093 Description of the effects of nonlogged and minimally logged operations on transaction log backup and the restore process in SQL Server Q272093 KB272093 December 7, 2005
• 232580 Description of storing UTF-8 data in SQL Server Q232580 KB232580 December 7, 2005
• 86903 Description of caching disk controllers in SQL Server Q86903 KB86903 December 7, 2005
• 207187 You cannot back up databases to a network drive if your account have not sufficient permissions to access the network drive Q207187 KB207187 December 2, 2005
• 841394 You may not be able to connect to an instance of SQL Server that is configured to use the TCP/IP server network library on a computer that is running Windows XP Service Pack 2 Q841394 KB841394 December 1, 2005
• 69133 How to convert CHAR values into DATETIME values in SQL Server Q69133 KB69133 December 1, 2005
• 313295 How to use the server name parameter in a connection string to specify the client network library Q313295 KB313295 November 30, 2005
• 302223 You receive an "Error 14114: (NULL) is not configured as a distributor" error message when you try to set up a SQL Server server as a distributor for replication Q302223 KB302223 November 30, 2005
• 324401 How to manually remove a replication in SQL Server 2000 or in SQL Server 2005 Q324401 KB324401 November 23, 2005
• 115519 How to use the Findstr tool to scan SQL error log files or DBCC output files for analysing errors Q115519 KB115519 November 23, 2005
• 870668 Reporting Services may not be able to run reports against Oracle databases Q870668 KB870668 November 22, 2005
• 908711 You receive an “Explicit value must be specified for identity column” error message when you use the replication feature to run an INSERT statement on a table in SQL Server 2005 Q908711 KB908711 November 19, 2005
• 909804 SQL Server Reporting Services may stop responding for several minutes on an x64-based computer in SQL Server 2005, 64-bit version Q909804 KB909804 November 18, 2005
• 910016 Release manifest for Microsoft SQL Server Native Client (9.00.1399.06) Q910016 KB910016 November 4, 2005
• 907886 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 Q907886 KB907886 November 3, 2005
• 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 Q908454 KB908454 November 1, 2005
• 818769 FIX: Trace Flag -T8002 Treats an Affinity Mask Like a Process Affinity Q818769 KB818769 October 25, 2005