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 Developer

Article ID Article Title Hidden
941232 How to apply a hotfix for SQL Server in a replication topology
944837 Description of the Replay Markup Language (RML) Utilities for SQL Server
945934 How to register Microsoft Filter Pack IFilters with SQL Server
949080 Error message when you execute a CLR routine or use an assembly in SQL Server: "Assembly in host store has a different signature than assembly in GAC. (Exception from HRESULT: 0x80131050)"
950599 An SPN for the SQL Server Browser service is required when you establish a connection to a named instance of SQL Server Analysis Services
955392 How to update or slipstream an installation of SQL Server 2008
955396 How to identify SQL Server 2008 setup issues in the setup log files
955445 FIX: Access violations may occur after you enable a 64-bit version of SQL Server 2008 to use large code pages on Windows Server 2008
955493 The installation fails when you try to install a new instance of SQL Server 2008 on an x64-based computer
955499 How to uninstall an instance of SQL Server 2008
955626 Error message when you try to run the Sqlmaint Utility after you upgrade to SQL Server 2008 or a later version: "The SQLDMO 'Application' object failed to initialize"
955644 Description of the "access check cache bucket count" and "access check cache quota" options that are available in the sp_configure stored procedure
955648 Error message when you start SQL Server Management Studio in SQL Server 2008: "Unable to read the list of previously registered servers on this system"
955725 Known issues installing SQL Server on Windows 7 or Windows Server 2008 R2
955763 The SQL Server Agent service does not start after you upgrade from SQL Server 2008 Express or from SQL Server 2008 Express with Advanced Services to SQL Server 2008 Developer, to SQL Server 2008 Enterprise, or to SQL Server 2008 Standard
955850 Error message when you try to use the binaries from the SQL Server System CLR Types package (SQLSysClrTypes.msi): "Unable to load DLL 'SqlServerSpatial.dll': This application has failed to start because the application configuration is incorrect"
956013 Error message when you open SQL Server Configuration Manager in SQL Server: "Cannot connect to WMI provider. You do not have permission or the server is unreachable"
956032 Error message when you run the Distribution Agent in SQL Server 2008 or in SQL Server 2008 R2: "The distribution agent failed to create temporary files"
956139 Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed
956176 Error message when you try to save a table in SQL Server: "Saving changes is not permitted"
956893 Support policy for Microsoft SQL Server products that are running in a hardware virtualization environment
959773 FIX: When you try to use a subselect query that has calculated members in Excel 2007, the query returns an unexpected error
959774 FIX: Calculated members in a SQL Server 2008 database are not evaluated, and the advanced filters return unexpected results when you run the Filter function in an Excel 2007 PivotTable report
967103 The Full Text Search component installation fails when you try to install the SQL Server 2008 database engine from an installation DVD on a computer that has SQL Server 2008 Express edition installed
967576 Microsoft SQL Server Database Engine Input/Output requirements
968872 How to open the firewall port for SQL Server on Windows Server 2008
969052 How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
969962 Various memory errors are logged to SQL Server error log when using SQL CLR objects
971249 Microsoft ODBC drivers can return unexpected results when using parameter markers after any function in a T-SQL Statement
971261 PRB: 'Script table as' reports an error for linked servers created using MSDASQL provider in SQL Server 2005 and SQL Server 2008
971268 "Evaluation period has expired" error message when working with SQL server
972387 SQL Server Failover Cluster Instance is taken offline when you change the password for the service account on the passive node
977051 How to apply a hotfix for SQL Server in a transactional replication and database mirroring topology
983332 You cannot open a Business Intelligence project after you upgrade the project to the format that is used by Visual Studio 2010
2009160 High CPU use occurs when you run queries in SQL Server
2009214 Collection sets running under proxy account will fail in WOW environment.
2027537 Best Practice recommendations for SQL Server Database Backups
2027550 Recommended MSDTC settings for using Distributed Transactions in SQL Server
2027770 Understanding the .NET Framework requirements for various versions of SQL Server
2028436 Database operations take a long time to complete, or they trigger errors when the transaction log has numerous virtual log files
2028589 SQL Server reports errors for exceptions, assertions, and hang conditions
2028697 Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server
2028712 Understanding Password Policy for SQL Server Logins.
2029023 Guidelines on Securing folders for Database Files and Program Files of a SQL Server Installation
2032911 You may encounter problems when installing SQL Server on a domain controller
2033238 Performance and consistency issues when certain modules are loaded into SQL Server address space
2033448 Winsock Layered Service Providers (LSP) may result in network or server stability problems for SQL Server
2033523 Separate database and transaction log files on different drives for optimal performance and disaster recovery
2033590 SQL Server records the date/time of the most recent database consistency check with no errors
2078345 ​The database PAGE_VERIFY CHECKSUM option can help detect database consistency problems with the system I/O path