sql server comand行执行一个.sql fike [英] sql server comand line execute an .sql fike
问题描述
我要提出一个问题，我有一个从sql server 2005数据库创建的文件数据库(模式)，我想将其插入(执行文件以创建数据库)到sql server express 2008服务器(win7)和winxp目标机器，win7开发人员，win xp客户端)，我已经尝试过(在Windows cmd中启动sqlcmd)而无需管理工作室，键入了sqlcmd.exe，但我需要连接字符串.
询问1我如何找到默认实例名称(我的PC Win7)，却找不到数据库或服务控制台(控制面板)的文件
问2 sspi(我只有Windows身份验证)是Windows身份验证吗? (我想使用com在目标计算机上创建客户端服务器
问问vc#(vc#2010 Express)中的3是否可以在本地网络上使用...待续
谢谢
Kyriakos(aluooss)
I have a question to make, I have a create to file database from an sql server 2005 database (schema), I want to insert (execute the file to create the database) it to an sql server express 2008 sever (win7 and winxp target machines, win7 developer, win xp client), I have tried (in windows cmd starting sqlcmd) to do it without managment studio, have typed sqlcmd.exe but I thing I need the connection string.
ask 1 How do I find the default instance name (my pc win7) I thing theough the file of the database or the services console (contro; panel)
ask 2 The sspi (I have only windows authrntication) is the windows authentication? (I want to use com to create the client(s) server in the target machine(s)
ask 3 in vc# (vc# 2010 express) can I use in local network on...to be continued
Thank you
Kyriakos (aluooss)
推荐答案
要找出实例，
转到开始菜单->程序-> Microsoft Sql Server 2008->配置工具-> SQL Server配置管理器
在配置管理器中，选择"SQL Server服务". &在右侧，您将在括号中看到带有实例名称的实例
如果您在Windows身份验证上运行，请使用集成安全性= sspi;
您必须至少在客户端计算机上进行客户端安装才能访问服务器
是的，您可以使用本地网络连接到服务器，可以使用以下语法作为服务器名称:MACHINE_NAME \ INSTANCE_NAME
To find out the instance,
goto start menu -> programs -> Microsoft Sql Server 2008 -> Configuration Tools -> Sql Server Configuration Manager
In the config manager, select SQL Server Services
& to the right you''ll see the instances with the instance name in the bracket
If y''r running on windows authentication, use integrated security = sspi;
You must at least do the client installation in the client machines to access the server
Yes, you can use local network to connect to the server you can use this syntax for the server name is MACHINE_NAME\INSTANCE_NAME
这篇关于sql server comand行执行一个.sql fike的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
