kbupdate.info ›
Daily Updated!
SQL Server 2005 articles, fixes and updates - letter H
Daily Updated!
chronological list: 2010 | 2009/12 11 10 9 8 7 6 5 4 3 2 1 | 2008/12 ... 2003
alphabetical list: A B C D E F G H I K L M N O P Q R S T U V W Y
This list contains all of the known Microsoft Knowledge Base articles, howtos, fixes, hotfixes, webcasts and updates of Microsoft SQL Server 2005 starts with letter H that have been released. The list is daily updated.
- 918483 How to reduce paging of buffer pool memory in the 64-bit version of SQL Server Q918483 KB918483 February 26, 2010
- 2009160 High CPU utilization may occur with your queries on SQL Server 2005 and SQL Sever 2008 servers compared to SQL Server 2000 Q2009160 KB2009160 January 13, 2010
- 945934 How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008 Q945934 KB945934 January 7, 2010
- 917409 How to configure SQL Server 2008 Analysis Services and SQL Server 2005 Analysis Services to use Kerberos authentication Q917409 KB917409 December 11, 2009
- 977051 How to apply a hotfix for SQL Server 2005 or SQL Server 2008 in a transactional replication and database mirroring topology Q977051 KB977051 November 18, 2009
- 959823 How to customize the quota for the TokenAndPermUserStore cache store in SQL Server 2005 Service Pack 3 Q959823 KB959823 August 21, 2009
- 910230 How to install SQL Server 2005 Analysis Services on a failover cluster Q910230 KB910230 August 14, 2009
- 811889 How to troubleshoot the "Cannot generate SSPI context" error message Q811889 KB811889 August 11, 2009
- 319723 How to use Kerberos authentication in SQL Server Q319723 KB319723 August 11, 2009
- 968872 How do I open the firewall port for SQL Server on Windows Server 2008? Q968872 KB968872 August 5, 2009
- 938245 How to install and how to configure SQL Server 2005 Reporting Services on a computer that is running Windows Server 2008 Q938245 KB938245 July 22, 2009
- 314546 How to move databases between computers that are running SQL Server Q314546 KB314546 July 13, 2009
- 934162 How to install a 32-bit version of SQL Server 2005 Reporting Services on a computer that is running a 64-bit version of Windows Q934162 KB934162 June 22, 2009
- 137983 How to troubleshoot orphaned connections in SQL Server Q137983 KB137983 April 30, 2009
- 321185 How to identify your SQL Server version and edition Q321185 KB321185 April 8, 2009
- 914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server 2005 and in SQL Server 2008 Q914288 KB914288 April 7, 2009
- 263712 How to impede Windows NT administrators from administering a clustered instance of SQL Server Q263712 KB263712 April 3, 2009
- 271509 How to monitor blocking in SQL Server 2005 and in SQL Server 2000 Q271509 KB271509 March 30, 2009
- 969200 How to return uniqueidentifier initialized with NEWSEQUENTIALID() function to the .Net client Q969200 KB969200 March 18, 2009
- 244980 How to change the network IP addresses of SQL Server failover cluster instances Q244980 KB244980 March 11, 2009
- 932881 How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult Q932881 KB932881 February 13, 2009
- 823938 How to configure an instance of SQL Server to listen on a specific TCP port or a dynamic port Q823938 KB823938 February 12, 2009
- 283811 How to change the SQL Server or SQL Server Agent service account without using SQL Enterprise Manager in SQL Server 2000 or SQL Server Configuration Manager in SQL Server 2005 Q283811 KB283811 February 11, 2009
- 917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server 2005 Q917825 KB917825 February 6, 2009
- 958998 How to troubleshoot IIS configuration issues in SQL Server 2005 Reporting Services Q958998 KB958998 February 4, 2009
- 240872 How to resolve permission issues when you move a database between servers that are running SQL Server Q240872 KB240872 January 27, 2009
- 316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console Q316898 KB316898 December 29, 2008
- 913089 How to obtain the latest service pack for SQL Server 2005 Q913089 KB913089 December 20, 2008
- 953504 How to change SQL Server parameters in a clustered environment when SQL Server is not online Q953504 KB953504 October 21, 2008
- 953200 How to migrate SQL Server 2005 Service Pack 2 failover clustered instances from Windows Server 2003 Service Pack 2 to Windows Server 2008 Q953200 KB953200 September 22, 2008
- 956600 How to use the SubscriptionStreams parameter of Distribution Agent to test for improved disk subsystem throughput in SQL Server 2005 Q956600 KB956600 August 14, 2008
- 953199 How to configure and troubleshoot the SubscriptionStreams parameter of the Distribution Agent in SQL Server 2005 Q953199 KB953199 August 14, 2008
- 319942 How to determine proper SQL Server configuration settings Q319942 KB319942 July 17, 2008
- 314783 How to plan SQL Server CE, SQL Server 2005 Compact Edition, or SQL Server 2005 Mobile Edition security for mobile devices in IIS and SQL Server 2000 Windows CE Edition Q314783 KB314783 July 3, 2008
- 953740 How to identify and enable disabled SQL Server instances in SQL Server 2000 Q953740 KB953740 June 19, 2008
- 952114 How the impersonation information option of a SQL Server 2005 Analysis Services database affects deployment and synchronization Q952114 KB952114 May 14, 2008
- 941151 How to enable the Sqldumper.exe utility to generate dump files for processes that are related to SQL Server 2005 Integration Services with Service Pack 2 Q941151 KB941151 May 1, 2008
- 325877 How to control access to a database on a Web server in Windows Server 2003 Q325877 KB325877 December 3, 2007
- 923398 How to configure an IPv6 resource for a SQL Server 2005 cluster on a Windows Server 2008-based computer Q923398 KB923398 November 22, 2007
- 942177 How to determine the version of SQL Server 2005 Integration Services Q942177 KB942177 November 20, 2007
- 937682 How to add a Windows user to the sysadmin fixed server role in SQL Server 2005 as a failure recovery mechanism Q937682 KB937682 November 20, 2007
- 936492 How to use Windows Management Instrumentation in SQL Server 2005 to change the account of the SQL Server service or the password of the SQL Server service programmatically Q936492 KB936492 November 20, 2007
- 934653 How to use the 64-bit SQL Server Agent to schedule a SQL Server 2005 Integration Services package Q934653 KB934653 November 20, 2007
- 931975 How to prepare SQL Server 2005 and SQL Server 2000 for changes to daylight saving time in 2007 Q931975 KB931975 November 20, 2007
- 930615 How to schedule a database backup operation by using SQL Server Management Studio in SQL Server 2005 Q930615 KB930615 November 20, 2007
- 928907 How to improve concurrency in a SQL Server 2005 application by using built-in functions Q928907 KB928907 November 20, 2007
- 926930 Hard disk drive sector-size support boundaries in SQL Server 2005 Q926930 KB926930 November 20, 2007
- 926824 How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring Q926824 KB926824 November 20, 2007
- 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 Q922670 KB922670 November 20, 2007
- 917040 How to use the timestamp column of a table for optimistic concurrency control in SQL Server 2005 Q917040 KB917040 November 20, 2007
- 913967 How to add the SQL Server 2005 tools or SQL Server 2005 Integration Services to an existing instance of SQL Server 2005 Q913967 KB913967 November 20, 2007
- 912911 How to run a SQL Server 2005 Integration Services package as a SQL Server Agent job step Q912911 KB912911 November 20, 2007
- 909967 How to uninstall an instance of SQL Server 2005 manually Q909967 KB909967 November 20, 2007
- 909953 How to uninstall SQL Server Management Studio Q909953 KB909953 November 20, 2007
- 908360 How to configure SQL Server Agent to send job status notifications and alert notifications in SQL Server 2005 64-bit editions Q908360 KB908360 November 20, 2007
- 907877 How to use the DBCC MEMORYSTATUS command to monitor memory usage on SQL Server 2005 Q907877 KB907877 November 20, 2007
- 827968 How to estimate the size of a SQL Server CE or SQL Server 2005 Mobile Edition database Q827968 KB827968 November 20, 2007
- 324321 How to troubleshoot error 15401 Q324321 KB324321 November 9, 2007
- 910401 How to use Microsoft System Center Data Protection Manager 2006 to help protect a SQL Server database Q910401 KB910401 November 2, 2007
- 906566 How to use XQuery to query XML data from a SQL Server 2000 database in SQL Server 2005 Q906566 KB906566 November 2, 2007
- 306397 How to use Excel with SQL Server linked servers and distributed queries Q306397 KB306397 November 2, 2007
- 265808 How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server Q265808 KB265808 November 2, 2007
- 246133 How to transfer logins and passwords between instances of SQL Server Q246133 KB246133 November 2, 2007
- 196909 How to increase the number of SQL Server error logs Q196909 KB196909 November 2, 2007
- 70956 How to remove duplicate rows from a SQL Server table by using a script Q70956 KB70956 November 2, 2007
- 814130 How to help secure network connectivity for SQL Server 2000 local databases Q814130 KB814130 October 29, 2007
- 841249 How to configure Windows XP Service Pack 2 (SP2) for use with SQL Server Q841249 KB841249 October 26, 2007
- 224071 How to move SQL Server databases to a new location by using Detach and Attach functions in SQL Server Q224071 KB224071 October 2, 2007
- 934164 How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer Q934164 KB934164 September 5, 2007
- 912914 How to use a stored procedure to monitor traces in SQL Server 2005 Q912914 KB912914 September 4, 2007
- 294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster Q294209 KB294209 August 21, 2007
- 941232 How to apply a hotfix for SQL Server 2005 in a replication topology Q941232 KB941232 August 16, 2007
- 325335 How to transfer a database from one collation to another collation in SQL Server Q325335 KB325335 August 16, 2007
- 934163 How to upgrade SQL Server 2005 Reporting Services on a Windows Vista-based computer Q934163 KB934163 June 22, 2007
- 915852 How to use certificates for SQL Server 2005 Service Broker remote security on multiple instances of SQL Server 2005 Q915852 KB915852 May 31, 2007
- 319930 How to connect to an instance of SQL Server Desktop Edition or of SQL Server 2005 Express Edition Q319930 KB319930 May 18, 2007
- 932376 How to configure SharePoint Server 2007 to use a database that is hosted on a server that is running SQL Server in an untrusted domain Q932376 KB932376 May 14, 2007
- 917407 How to upgrade or downgrade an assembly that has a referenced assembly for a CLR object in an instance of SQL Server 2005 Q917407 KB917407 May 11, 2007
- 912426 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# Q912426 KB912426 May 11, 2007
- 814576 How to consolidate physical files and rename the logical file name in SQL Server 2000 and in SQL Server 2005 Q814576 KB814576 May 11, 2007
- 912907 How to specify the location of a temporary database in SQL Server 2005 Compact Edition Q912907 KB912907 May 3, 2007
- 933837 How to make an MDX query return a value in the numeric format in SQL Server 2005 Analysis Services Q933837 KB933837 April 24, 2007
- 933032 How to hide a dimension name when no members are visible for a security role in SQL Server 2005 Analysis Services Q933032 KB933032 April 3, 2007
- 875447 How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page Q875447 KB875447 April 3, 2007
- 315521 How to troubleshoot SQL Server merge replication problems Q315521 KB315521 March 29, 2007
- 231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem Q231619 KB231619 March 16, 2007
- 323630 How to resolve blocking problems that are caused by lock escalation in SQL Server Q323630 KB323630 February 22, 2007
- 321363 How to adjust memory usage by using configuration options in SQL Server Q321363 KB321363 February 22, 2007
- 288809 How to recover SQL Server after a tempdb database is marked suspect Q288809 KB288809 February 22, 2007
- 287737 How to enumerate available instances of SQL Server by using the SQLDMO components Q287737 KB287737 February 22, 2007
- 262499 How to specify output parameters when you use the sp_executesql stored procedure in SQL Server Q262499 KB262499 February 22, 2007
- 246800 How to correctly parse quotation marks in Full Text Search queries Q246800 KB246800 February 22, 2007
- 243899 How to access additional information about errors that are returned when you use the OLE Automation system stored procedures Q243899 KB243899 February 22, 2007
- 199037 How to capture error messages that are sent to clients from an instance of SQL Server Q199037 KB199037 February 22, 2007
- 198891 How to run a DLL-based COM object outside the SQL Server process Q198891 KB198891 February 22, 2007
- 162294 How to schedule SQL Server backup or DBCC commands by using AT scheduler command Q162294 KB162294 February 21, 2007
- 306212 How to troubleshoot error 7391 that occurs when you use a linked server in SQL Server Q306212 KB306212 February 16, 2007
- 920769 How to use custom assemblies or embedded code in Reporting Services Q920769 KB920769 January 26, 2007
- 813731 How to retrieve data from a SQL Server CE 2.0 database or from a SQL Server 2005 Compact Edition database and save the data in an XML document Q813731 KB813731 December 7, 2006
- 169377 How to access SQL Server in Active Server Pages Q169377 KB169377 November 20, 2006
- 919711 How to configure SQL Server 2005 Analysis Services to generate memory dump files Q919711 KB919711 October 24, 2006
- 909801 How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005 Q909801 KB909801 October 2, 2006
- 906560 How to write information to the Application event log by using a Script task in a SQL Server 2005 Integration Services package Q906560 KB906560 September 22, 2006
- 253817 How to back up the last transaction log when the master and the database files are damaged in SQL Server Q253817 KB253817 September 11, 2006
- 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 Q918481 KB918481 August 4, 2006
- 918992 How to transfer the logins and the passwords between instances of SQL Server 2005 and SQL Server 2008 Q918992 KB918992 July 11, 2006
- 917446 How to install SharePoint Portal Server 2003 Service Pack 2 and Windows SharePoint Services Service Pack 2 in a deployment that uses SQL Server 2005 as the database back end Q917446 KB917446 June 26, 2006
- 917400 How to obtain the SQL Server Runtime license Q917400 KB917400 June 23, 2006
- 233332 How to run the SQLdiag utility on a clustered instance of SQL Server or on virtual SQL Server Q233332 KB233332 June 9, 2006
- 295732 How to create databases or change disk file locations on a shared cluster drive on which SQL Server was not originally installed Q295732 KB295732 June 7, 2006
- 919157 How to display a report that contains a subreport by using the ReportViewer control in Visual Studio 2005 Q919157 KB919157 May 31, 2006
- 919160 How to enable the snapshot transaction isolation level in SQL Server 2005 Analysis Services Q919160 KB919160 May 24, 2006
- 841251 How to enable SQL Server connectivity on Windows XP Service Pack 2 Q841251 KB841251 April 18, 2006
- 915856 How to set a default member of a dimension to a calculated member in SQL Server 2005 Analysis Services Q915856 KB915856 April 14, 2006
- 842425 How to move a Reporting Services database from a computer that is running Reporting Services to another computer Q842425 KB842425 April 7, 2006
- 810056 How to manually re-create the resource-specific registry keys for SQL Server cluster resources Q810056 KB810056 April 7, 2006
- 290624 How to configure MSDTC in a Windows 2000 cluster environment Q290624 KB290624 April 7, 2006
- 916784 How to perform full-text search related tasks in SQL Server 2005 Express Edition with Advanced Services Q916784 KB916784 April 3, 2006
- 914277 How to configure SQL Server 2005 to allow remote connections Q914277 KB914277 March 22, 2006
- 319716 How to populate a SQL Server 2005 database by using information from Active Directory Q319716 KB319716 March 21, 2006
- 908460 How to add an incremental counter in a SQL Server 2005 Integration Services package by using a Script component in a Data Flow task Q908460 KB908460 March 11, 2006
- 906564 How to use SQL Server Business Intelligence Development Studio or the dtutil utility to regenerate the package ID of an SSIS package that was duplicated Q906564 KB906564 March 11, 2006
- 906563 How to interpret data that is logged by using a SQL Server 2005 Integration Services log provider Q906563 KB906563 March 11, 2006
- 906562 How to use the dtutil utility (Dtutil.exe) to set the protection level of a batch of SQL Server Integration Services (SSIS) packages in SQL Server 2005 Q906562 KB906562 March 11, 2006
- 906547 How to create a dynamic subject or message for the Send Mail task in SQL Server 2005 Integration Services Q906547 KB906547 March 11, 2006
- 914278 How SQL Server 2005 Express Edition determines the CPU count and uses the CPUs during processing Q914278 KB914278 March 2, 2006
- 908018 How to create a package template in SQL Server Business Intelligence Development Studio Q908018 KB908018 February 24, 2006
- 186133 How to dynamically number rows in a SELECT Transact-SQL statement Q186133 KB186133 February 14, 2006
- 907716 How to obtain SQL Server Management Studio Express (SSMSE) community technology preview (CTP) Q907716 KB907716 January 31, 2006
- 911839 How to change the SQL Server 2005 service accounts by using the Windows Management Instrumentation (WMI) Provider for Configuration Management Q911839 KB911839 January 23, 2006
- 839980 How to use a script to programmatically open ports for SQL Server to use on systems that are running Windows XP Service Pack 2 Q839980 KB839980 January 11, 2006
- 318605 How SQL Server uses a certificate when the Force Protocol Encryption option is turned on Q318605 KB318605 January 2, 2006
- 312292 How to enable replication agents for logging to output files in SQL Server Q312292 KB312292 December 30, 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
- 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
- 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
- 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
- 175574 How to rotate a table in SQL Server Q175574 KB175574 December 15, 2005
- 321686 How to import data from Excel to SQL Server Q321686 KB321686 December 14, 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
- 321836 How to retrieve a specific table or rows from database backups or transaction log backups in SQL Server Q321836 KB321836 December 13, 2005
- 75722 How to reduce lock contention in SQL Server Q75722 KB75722 December 13, 2005
- 873235 How to stop the transaction log of a SQL Server database from growing unexpectedly Q873235 KB873235 December 12, 2005
- 298568 How to rebuild the master database on a virtual SQL Server instance Q298568 KB298568 December 10, 2005
- 322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition Q322336 KB322336 December 8, 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
- 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
- 324401 How to manually remove a replication in SQL Server 2000 or in SQL Server 2005 Q324401 KB324401 November 23, 2005
- 139444 How to remove duplicate rows from a table in SQL Server Q139444 KB139444 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
- 907511 How to use the DBCC SHRINKFILE statement to shrink the transaction log file in SQL Server 2005 Q907511 KB907511 November 1, 2005
- 243428 How to move extended stored procedures out of process Q243428 KB243428 November 3, 2004