Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mohit_sharan
Starting Member
22 Posts |
 Posted - 2004-10-14 : 07:49:45
|
| Hi ,I want to execute xp_cmdshell from normal sql server account not sysadmin member in SQL Server 2000. I had give execute privileges on xp_cmdshell to normal account... but its not working...Is it possible to execute xp_cmdshell from non sysadmin member account in SQL Server2000...Thanks in advance...-Mohit. |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-14 : 09:31:08
|
BoL says:quote:
By default, only members of the sysadmin fixed server role can execute this extended stored procedure. You may, however, grant other users permission to execute this stored procedure.
Does sp_helprotect 'xp_cmdshell'say anything useful?Kristen |
 |
|
|
|
|
|
Executing xp_cmdshell