Microsoft. SqlServer. Management. Sdk. Sfc

Reproduced http://hi.baidu.com/%CE%B5%C0%B6%B5%C4sky%CC%EC%BF%D5/blog/item/39a4b61b050143f8e0fe0be0.html

Problem: failed to Load file or assembly "Microsoft. SqlServer. Management. Sdk. Sfc, Version = 10.0.0.0, Culture =
Neutral, PublicKeyToken = 89845dcd8080cc91 "or one of its dependencies. The system cannot find the specified file.

Search answer: in Visual Studio, use "server resource manager-add connection" to add a connection to the SQLEXPRESS instance. Click "test connection" to connect to the instance correctly. Click "OK, the following prompt appears:
Unable to add Database
Failed to Load file or assembly "Microsoft. SqlServer. Management. Sdk. Sfc, Version = 10.0.0.0, Culture = neutral, PublicKeyToken = 89845dcd80cc91" or one of its dependencies. The system cannot find the specified file.
Directly Using Management Studio Express can manage databases, but it won't work in Visual Studio. Why?

Answer: You need to download the following feature package.

Http://www.microsoft.com/downloads/details.aspx? Displaylang = zh-cn & FamilyID = c6c3e9ef-ba29-4a43-8d69-a2bed18fe73c

Q: Can this friend introduce which package is needed? Or are all required?
In addition, the address you gave me is SQL Server 2008, and I use SQL Server 2005 Express Edition.
Thank you!

A: You can install Microsoft SQL Server 2008 to manage objects. It is used in VS2008 and has nothing to do with SQL 2005.
(The following is my practice based on the above Q & :)
Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a dynamic link library (DLL) that includes both the SQL ole db access interface and the SQL ODBC driver ). It provides runtime support for applications that use local code APIs (ODBC, ole db, and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or to enhance existing applications that need to take advantage of new features of SQL Server 2008. The SQL Native Client's reusable installer is used to install the Client components required for running, to take advantage of new features of SQL Server 2008, it can also install and develop header files required for applications using SQL Native Client APIs.

Microsoft SQL Server 2008 Native Client
Microsoft SQL Server 2008 Native Client (SQL Native Client) is a dynamic link library (DLL) that includes both the SQL ole db access interface and the SQL ODBC driver ). It provides runtime support for applications that use local code APIs (ODBC, ole db, and ADO) to connect to Microsoft SQL Server 2000, 2005, or 2008. SQL Native Client should be used to create new applications or to enhance existing applications that need to take advantage of new features of SQL Server 2008. The SQL Native Client's reusable installer is used to install the Client components required for running, to take advantage of new features of SQL Server 2008, it can also install and develop header files required for applications using SQL Native Client APIs.

Microsoft Core XML Services (MSXML) 6.0
Microsoft Core XML Services (MSXML) 6.0 is the latest version of the XML Processing Stack on the local machine. MSXML 6.0 provides standards-compliant implementation of XML 1.0, XML Schema (XSD) 1.0, XPath 1.0, and XSLT 1.0. In addition, it provides 64-bit support, enhances the security when using untrusted XML data, and improves the reliability compared with the previous MSXML version.

Microsoft SQL Server CLR type
The SQL Server CLR package contains components used to implement the new geometry, geography, and hierarchyid types in SQL Server 2008. This component can be installed separately from the server to allow client applications to use these types outside the server.

Note: Windows Installer 4.5 is required for this component.