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: Microsoft SQL Server 2005 Standard Edition

Article ID Article Title Hidden
86903 Description of caching disk controllers in SQL Server
139444 How to remove duplicate rows from a table in SQL Server
169377 How to access SQL Server in Active Server Pages
195565 Statistical maintenance functionality (AutoStats) in SQL Server
196909 How to increase the number of SQL Server error logs
198891 How to run a DLL-based COM object outside the SQL Server process
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
240872 How to resolve permission issues when you move a database between servers that are running SQL Server
243589 How to troubleshoot slow-running queries on SQL Server 7.0 or on later versions
244980 How to change the network IP addresses of SQL Server failover cluster instances
246133 How to transfer logins and passwords between instances of SQL Server that are running older versions of SQL Server
247931 Authentication methods for connections to SQL Server in Active Server Pages
253817 How to back up the last transaction log when the master and the database files are damaged in SQL Server
254321 Clustered SQL Server do's, don'ts, and basic warnings
263889 How to troubleshoot blocking caused by compile locks
264474 You cannot restore system database backups to a different build of SQL Server
265808 How to connect to SQL Server by using an earlier version of SQL Server
269587 Windows Authentication mode is the default security mode after a typical installation of SQL Server 2000 or of SQL Server 2005
271566 The behavior is different when comparing between columns and constants with different data types in SQL Server 7.0 and later versions of SQL Server
273673 Description of SQL Virtual Server client connections
280106 How to set up and troubleshoot a linked server to an Oracle database in SQL Server
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
294453 How to set up SQL Server to listen on multiple static TCP ports
298475 How to troubleshoot SQL Server performance issues
301520 Error message when you install SQL Server cluster on Windows Server 2003-based computers where Terminal Services is installed: "Setup failed to perform required operations on the cluster nodes"
303411 You receive a "Warning SuperSocket Info" warning information when a SQL Server service account is a domain user
304261 Description of support for network database files in SQL Server
306397 How to use Excel with SQL Server linked servers and distributed queries
306985 Error message when you connect to a cluster virtual server by using the named pipes protocol: "The machines selected for remote communication is not available at this time."
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
316005 How to import XML into SQL Server with the XML Bulk Load component
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
319578 Error message when you change the IP address on a SQL Server failover cluster node: "Bind failed"
319723 How to use Kerberos authentication in SQL Server
321185 How to determine the version, edition, and update level of SQL Server and its components
321363 How to adjust memory usage by using configuration options in SQL Server
321836 How to retrieve a specific table or rows from database backups or transaction log backups in SQL Server
324321 How to troubleshoot error 15401
325877 How to control access to a database on a Web server in Windows Server 2003