vs2013怎么查看vs2012 localdb ssms

来源：蜘蛛抓取(WebSpider) 时间：2016-01-25 09:31 标签： vs2012 localdb
SqlLocalDB Utility
SqlLocalDB Utility
Expand the table of content
SqlLocalDB Utility
SQL Server 2016
Use the SqlLocalDB utility to create an instance of Microsoft SQL Server 2016 Express LocalDB. The SqlLocalDB utility (SqlLocalDB.exe) is a simple command line tool to enable users and developers to create and manage an instance of SQL Server Express LocalDB. For information about how to use LocalDB, see .
SqlLocalDB.exe
| c ] &instance-name&
&instance-version& [-s ]
| [ delete
| d ] &instance-name&
| s ] &instance-name&
| p ] &instance-name&
[ -i ] [ -k ]
| h ] [" &user_SID& " | " &user_account& " ] " &private-name& " " &shared-name& "
| [ unshare
| u ] " &shared-name& "
| i ] &instance-name&
| [ versions | v ]
| t ] [ on | off ]
[ create | c ] &instance-name&
&instance-version& [-s ]Creates a new of instance of SQL Server Express LocalDB. SqlLocalDB uses the version of SQL Server Express binaries specified by &instance-version& argument. The version number is specified in numeric format with at least one decimal. The minor version numbers (service packs) are optional. For example the following two version numbers are both acceptable: 11.0, or 11.0.1186. The specified version must be installed on the computer. If not specified, the version number defaults to the version of the SqlLocalDB utility. Adding –s starts the new instance of LocalDB.[ share | h ]Shares the specified private instance of LocalDB using the specified shared name. If the user SID or account name is omitted, it defaults to the current user.[ unshared | u ]Stops the sharing of the specified shared instance of LocalDB.[ delete | d ] &instance-name&Deletes the specified instance of SQL Server Express LocalDB.[ start | s ] " &instance-name& "Starts the specified instance of SQL Server Express LocalDB. When successful the statement returns the named pipe address of the LocalDB.[ stop | p ] &instance-name& [-i ] [-k ]Stops the specified instance of SQL Server Express LocalDB. Adding –i requests the instance shutdown with the NOWAIT option. Adding –k kills the instance process without contacting it.[ info | i ] [ &instance-name& ]Lists all instance of SQL Server Express LocalDB owned by the current user.&instance-name& returns the name, version, state (Running or Stopped), last start time for the specified instance of SQL Server Express LocalDB, and the local pipe name of the LocalDB.[ trace | t ] on | offtrace on enables tracing for the SqlLocalDB API calls for the current user. trace off disables tracing.-?Returns brief descriptions of each SqlLocalDB option.The instance name argument must follow the rules for SQL Server identifiers or it must be enclosed in double quotes.Executing SqlLocalDB without arguments returns the help text.Operations other than start can only be performed on an instance belonging to currently logged in user.The following example creates an instance of SQL Server Express LocalDB named DEPARTMENT using the SQL Server 2016 binaries and starts the instance.
SqlLocalDB.exe create "DEPARTMENT" 12.0 -s
Open a command prompt using Administrator privileges.
SqlLocalDB.exe create "DeptLocalDB"
SqlLocalDB.exe share "DeptLocalDB" "DeptSharedLocalDB"
SqlLocalDB.exe start "DeptLocalDB"
SqlLocalDB.exe info "DeptLocalDB"
REM The previous statement outputs the Instance pipe name for the next step
sqlcmd –S np:\\.\pipe\LOCALDB#&use your pipe name&\tsql\query
CREATE LOGIN NewLogin WITH PASSWORD = 'Passw0rd!!@52';
CREATE USER NewL
Execute the following code to connect to the shared instance of LocalDB using the NewLogin login.
sqlcmd –S (localdb)\.\DeptSharedLocalDB -U NewLogin -P Passw0rd!!@52
IN THIS ARTICLE
Was this page helpful?
Additional feedback?
1500 characters remaining
Thank you!
We appreciate your feedback.
Your feedback about this content is important.Let us know what you think.
Additional feedback?
1500 characters remaining
Thank you!
We appreciate your feedback.
Help us improve MSDN.
Visit our UserVoice Page to submit and vote on ideas!
Dev centers
Learning resources&...&&sqllocaldb.msi
扫描二维码，下载文件到手机
发送给微博、QQ、MSN等好友吧
当前文件信息
浏览：168次
下载：54次
您的VIP会员已过期，是否续费？
用户应遵守著作权法，尊重著作权人合法权益，不违法上传、存储并分享他人作品。举报邮箱：
京网文[0号 京ICP证100780号随笔 - 297关于vs2013中localdb的数据库连接问题
[问题点数：100分]
关于vs2013中localdb的数据库连接问题
[问题点数：100分]
不显示删除回复
显示所有回复
显示星级回复
显示得分回复
只显示楼主
匿名用户不能发表回复！|
每天回帖即可获得10分可用分！小技巧：
你还可以输入10000个字符
(Ctrl+Enter)
请遵守CSDN，不得违反国家法律法规。
转载文章请注明出自“CSDN（www.csdn.net）”。如是商业用途请联系原作者。

我要回帖

更多关于 vs2012 localdb 的文章

 

随机推荐