使用SQL中的xp_cmdshell在桌面上创建文件夹 [英] Creating a folder on desktop using xp_cmdshell in SQL

问题描述

hi。





我想在SQL 2000中使用xp_cmdshell在桌面上创建一个文件夹......



请帮助

hi.


I want to create a folder on to desktop using xp_cmdshell in SQL 2000...

Please help

推荐答案

阅读以下内容：

http://social.msdn.microsoft.com/Forums/en-US/ searchserverfaq / thread / 27d71076-7cb4-4689-82ec-d96d4501ce9d / [ ^ ]

Read the following:
http://social.msdn.microsoft.com/Forums/en-US/searchserverfaq/thread/27d71076-7cb4-4689-82ec-d96d4501ce9d/[^]

1）不要喊叫。你想要什么并不有意思。你来到这里请求帮助，而不是命令！

2）问题无法解答，因为没有桌面，所有用户都有不同的桌面，加上一个共同的一。

3）所以我们假设您想要改变普通桌面。那么，要做到这一点，您需要具有管理员和提升权限，或者以系统身份运行命令。哪个是危险的！

4）为什么你想这样做呢？如果您的sql server在服务器上运行，则没有人会看到它。如果它在桌面上运行你有其他方法来创建文件夹，你为什么要在sql server中做到这一点？



所以即使你按照Mehdi建议的路径Gholam，你最终没有任何用处。我建议你重新考虑你的申请。或者你可以和我们分享你在这个方向上的动机，也许有人可以给你更好的建议......

1) Don't shout. It is not interesting what you want. You came here to kindly ask for help, and not to command!
2) The question can not be answered because there is no "the desktop", there are different desktops for all users, plus a common one.
3) So let's assume you want to alter the common desktop. Well, to do that, you need to have administrator plus elevated rights or to run the command as system. Which is dangerous!
4) Why on earth do you want to do that? If your sql server runs on a server, nobody will see it. If it runs on a desktop you have other means to create folder, why would you do that from within sql server?

So even if you follow the path suggested by Mehdi Gholam, you will end up with nothing useful. I suggest you rethink your application. Or you could share with us your motivations in this direction, and maybe somebody could give you better advice...

这篇关于使用SQL中的xp_cmdshell在桌面上创建文件夹的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！