在SQL Express中附加数据库 [英] Attach DB in SQL Express

问题描述

大家好，

我是SQL Express 2008的新手，仅使用普通的SQL Server
前.

我还需要知道如何附加数据库
请连接字符串.

Hi all,

I am new to SQL Express 2008, only used normal SQL server
before.

I need to know how to attach the db also
the connection string please.

Any help would be appriciated.

推荐答案

尝试从Visual Studio的服务器资源管理器中打开本地SqlExpress服务器.

如果能够从服务器资源管理器中打开sqlexpress，则可以检查任何数据库的属性窗口并在其中找到连接字符串.

P.S. sqlexpress是sqlserver的子集，因此您在使用它时不会发现很多困难.

Try to open the local SqlExpress server from the server explorer of visual studio.

If you are able to see get the sqlexpress open from server explorer you can check the property window of any database and find the connectionstring there.

P.S. sqlexpress is a subset of sqlserver so you wont find much difficulty in using it.

Here is what my connection string looks like (the private information is changed):

"Data Source="MACHINENAME\\SQLEXPRESS";User ID="Admin";Password="the_password";InitialCatalog="MyDatabase";Integrated Security=True";

如果这不起作用，请尝试此链接..！
http://stackoverflow.com/questions/997169/c-sharp- 2008-sql-server-express-connection-string [ ^ ]

if this is not work try this link..!
http://stackoverflow.com/questions/997169/c-sharp-2008-sql-server-express-connection-string[^]

http://www .connectionstrings.com/ [ ^ ]

这篇关于在SQL Express中附加数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！