I have a stored procedure that need to execute a batch file which located on the SQL server folder. I do find a very useful command which can do this : master..xp_cmdshell. However, no matter how I create a user, it still need the user which execute this command to be sysadmin. However, according to the MS SQL online book, it says :
Execute permissions for xp_cmdshell default to members of the sysadmin fixed server role, but can be granted to other users.
therefore, I think there should be a way to config a user which no need to be sysadmin role but still can execute master..xp_cmdshell as it says "...but can be granted to other users..."
Can anyone help ?