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 Express Edition

Article ID Article Title Hidden
139444 How to remove duplicate rows from a table in SQL Server
169377 How to access SQL Server in Active Server Pages
198891 How to run a DLL-based COM object outside the SQL Server process
224071 Troubleshooting SQL Server backup and restore operations
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
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
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
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
298475 How to troubleshoot SQL Server performance issues
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
307356 How to understand Merge Replication article processing order
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
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
322336 How to verify and change the system administrator password in MSDE or SQL Server 2005 Express Edition
324321 How to troubleshoot error 15401
325877 How to control access to a database on a Web server in Windows Server 2003
328306 Potential causes of the "SQL Server does not exist or access denied" error message
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
814574 Error message when you shrink the transaction log file of a database in SQL Server: "Cannot shrink log file ..."
822101 Description of the waittype and lastwaittype columns in the master.dbo.sysprocesses table in SQL Server 2000 and SQL Server 2005
822400 Description of disaster recovery options for Microsoft SQL Server
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
873235 Recover from a full transaction log in a SQL Server database
889615 You may receive a "Not associated with a trusted SQL Server connection" error message when you try to connect to SQL Server 2000 or SQL Server 2005
901039 Description of the type mapping of the new SQL Server 2005 data types in Microsoft Data Access Components
907511 How to shrink the transaction log file in SQL Server 2005
909967 How to manually uninstall an instance of SQL Server 2005
910229 SQL Server 2005 Express Edition Readme
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#