Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: SQL Server 2008 Enterprise

Article ID Article Title Hidden
86903 Description of caching disk controllers in SQL Server
195565 Statistical maintenance functionality (AutoStats) in SQL Server
196909 How to increase the number of SQL Server error logs
200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries
224071 Troubleshooting SQL Server backup and restore operations
224453 INF: Understanding and resolving SQL Server blocking problems
230785 Description of logging and data storage algorithms that extend data reliability in SQL Server
231347 Description of support for SQL Server databases on compressed volumes
231619 How to use the SQLIOSim utility to simulate SQL Server activity on a disk subsystem
234656 Information about using disk drive caches with SQL Server that every database administrator should know
263889 How to troubleshoot blocking caused by compile locks
294209 How to rebuild or move a MSDTC installation to be used with a SQL failover cluster
304261 Description of support for network database files in SQL Server
307356 How to understand Merge Replication article processing order
307487 How to shrink the tempdb database in SQL Server
307864 Error message when you connect to an instance of SQL Server: "Cannot open user default database"
310834 Description of common causes of SQL Server error message 844 or error message 845
315512 Considerations for the "autogrow" and "autoshrink" settings in SQL Server
316898 How to enable SSL encryption for an instance of SQL Server by using Microsoft Management Console
317375 A transaction log grows unexpectedly or becomes full in SQL Server
321185 How to determine the version, edition, and update level of SQL Server and its components
327270 SQL Server is not supported on Windows Server 2003 or Windows Server 2008 Terminal Server application server
327489 How to use the DisallowAdHocAccess setting to control access to linked servers
327518 The Microsoft Support Policy for Clustered Configurations of SQL Server with Windows Server
555332 "Login failed for user" error message when you log on to SQL Server
811889 How to troubleshoot the "Cannot generate SSPI context" error message
822499 Naming schema and Fix area descriptions for SQL Server software update packages
823938 How to configure SQL Server to listen on a specific port
833770 Support for SQL Server on iSCSI technology components
835185 Microsoft Windows Failover cluster resource dependencies in SQL Server
897284 Diagnostics in SQL Server help detect stalled and stuck I/O operations
903643 The Ntbackup.exe operation may break the differential backup chain of a SQL Server database and may invalidate the differential backups when you perform a snapshot backup of the database
910378 Scalable shared databases are supported by SQL Server 2005
912262 The auto update statistics option, the auto create statistics option, and the Parallelism setting are turned off in the SQL Server database instance that hosts the BizTalk Server BizTalkMsgBoxDB database
914288 How to generate a script of the necessary database metadata to create a statistics-only database in SQL Server
917047 Microsoft SQL Server I/O subsystem requirements for the tempdb database
917825 How to use the Sqldumper.exe utility to generate a dump file in SQL Server
918483 How to reduce paging of buffer pool memory in SQL Server
918760 SSIS package does not run when called from a SQL Server Agent job step
918992 How to transfer logins and passwords between instances of SQL Server
919023 SQL Server 2005 connectivity and Volume Shadow Copy Service (VSS)
919155 Error message when you run the DBCC CHECKDB statement on a database that contains one or more very large tables in SQL Server: "Timeout occurred while waiting for latch"
920093 Tuning options for SQL Server when running in high performance workloads
920925 Detours or similar techniques may cause unexpected behaviors with SQL Server
922672 Support policy for untested .NET Framework assemblies in the SQL Server CLR-hosted environment
923247 Troubleshooting DBCC error 2570 in SQL Server 2005 and later versions
926150 Using database mirroring for cross-database transactions or distributed transactions is not supported in SQL Server
926824 How to install service packs and hotfixes on an instance of SQL Server that is configured to use database mirroring
926930 Hard disk drive sector-size support boundaries in SQL Server
928518 Error message when you run any of the DBCC CHECK commands in SQL Server: "The database could not be exclusively locked to perform the operation"