Shulou(Shulou.com)06/02 Report--

This article mainly introduces VS 2003 SQLServer2005 how to configure the directory, has a certain reference value, interested friends can refer to, I hope you can learn a lot after reading this article, the following let Xiaobian take you to understand.

System: WinXP

1. Install VS2005 first.

I installed MicrosoftVisualStudio2005TeamEdition, which is available on the Internet. It's just a little big, more than 3 gigabytes, if the speed is OK, go ahead, or buy one. When I went to the store the other day, he said, no. I don't know if he hasn't sold out of VS2003.

2. Setting of VS 2003 SQLServer2005 Express

This doesn't have to be set in the first place. If you don't believe it, try "create a personal site" and you can see its performance. But if you want to have the same interface as Enterprise Manager in SQL2000, you need to do a little work.

VS 2003 SQLServer2005 Express was installed when VS2005 was installed during the National Day holiday, which is described as follows:

SQLServerExpress is a free and easy-to-use database product based on SQLServer2005 technology, which aims to provide a very easy-to-use database platform that can be quickly deployed according to its target situation. The reason why it is easy to use is first of all because it has a simple and reliable graphical user interface (GUI) installer that can guide users through the installation process. The free GUI tools included with SQLServerExpress include: SQLServerManagementStudioExpressEdition (a preview version of the technology that can be used at startup), SurfaceAreaConfigurationTool, and SQLServerConfigurationManager. These tools simplify basic database operations. Through the integration with the VisualStudio project, the design and development of database applications become easier. In addition, I'll introduce the ability to deploy a database application by moving it, just like moving a typical Windows file. Services and patching have also been simplified and automated.

SQLServerExpress uses the same reliable, high-performance database engine as other SQLServer2005 versions, as well as the same data access API (such as ADO.NET, SQLNativeClient, and T-SQL). In fact, it differs from other SQLServer2005 versions only in the following aspects:

1. Lack of functional support for Enterprise Edition

2. Only one CPU

3. Buffer pool memory is limited to 1GB

4. Database * * is 4GB

By default, in SQLServerExpress, features such as automatic shutdown and database replication like file replication are enabled, while high availability and business intelligence features are disabled. It is also easy to scale if necessary, because SQLServerExpress applications can be used seamlessly with SQLServer2005WorkgroupEdition, SQLServer2005StandardEdition, or SQLServer2005EnterpriseEdition. Download files through Web for free, fast and convenient deployment

In the next SSMS-EE, you can see the interface you haven't seen for a long time:

MicrosoftSQLServerManagementStudioExpress makes it easy for you to manage databases and perform query analysis functions. SQLServerExpress is designed for ease of use, with its graphical user interface (GUI) tool MicrosoftSQLServerManagementStudioExpress

Quick description

MicrosoftSQLServerManagementStudioExpress (SSMSE) is a free, easy-to-use graphics management tool for managing VS 2003 SQLServer2005 ExpressEdition and VS 2003 SQLServer2005 ExpressEdition with advanced services.

Thank you for reading this article carefully. I hope the article "how to configure the catalog of VS 2003 SQLServer2005" shared by the editor will be helpful to you. At the same time, I also hope you will support us and pay attention to the industry information channel. More related knowledge is waiting for you to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.