You are here: Re: xp_cmdshell sql server 2000 « MsSQL Server « IT news, forums, messages
Re: xp_cmdshell sql server 2000

Posted by Erland Sommarskog on 02/08/07 23:03

shark (xavier.sharon@gmail.com) writes:
> does anybody know how to enable/disable xp_cmdshell in sql server
> 2000.
>
> i our server this sp has been disbaled for security puropse.but i need
> to use it in a job.so please can any body guide me?

As far as I know, you cannot disable xp_cmdshell in SQL 2000, only in
SQL 2005. It's of course possible to revoke or even deny permissions on
it, and maybe you can play with the proxy user.

So to know how to enable it, we would need to know how it was "disabled".
What happens if you try to run it?

....and of course, if someone disabled it, it was for a reason. Maybe
that person would not like if you turned it on again. Or are you in
charge these days?

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация