您必须至少连接才能在服务器上运行。

为此您需要登录（凭据）进行身份验证：

- windows

- SQL用户/密码

在这两种情况下，你应该对要查询的对象拥有最低的SELECT权限。

如果是这种情况，则不需要xp_cmdshell启用。

您可以使用：

1）BCP.exe，它几乎是任何一台机器的一部分。

2）Powershell

3）ISQL

3）任何连接服务器和执行查询的语言。



GB

Hi,
You have to connect as minimum in order to run something on the server.
For this you need login (credentials) to authenticate :
- windows
- SQL user/password
In the both cases you should have minimum SELECT permissions on the objects you want to query.
If it is the case, no need xp_cmdshell enabled.
You can use :
1)BCP.exe which is part of almost any machine.
2)Powershell
3)ISQL
3)Any language to connect to server and execute queries.

GB