question

eghetto avatar image
eghetto asked

EXEC xp_servicecontrol N'QUERYSTATE', 'MsDtsServer100' --> Error

Dear all, One of our users ('myUser1') who would like to know if the SSIS service is still running. If he executes the following statement: EXEC xp_servicecontrol N'QUERYSTATE', 'MsDtsServer100' an error occurs: ***"A severe error occurred on the current command. The results, if any, should be discarded."*** For me as sysadmin the code works perfect. But myUser1 cannot execute this code. Execute permissions have been granted (`GRANT EXECUTE ON xp_servicecontrol TO myUser1`) What's wrong? thanks!
sql-server-2008error-messageservicesxp_servicecontrol
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
pkeisler avatar image
pkeisler answered
xp_servicecontrol requires sysadmin permission in order to execute it, regardless of what other permissions are granted to a user.
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Thanks Patrick! I'm afraid you're right. Now I have to find an alternative way...
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.