0

Is there any possibility or workaround to execute sp_setapprole in a stored procedure? I read its not possible but maybe someone knows a workaround?

Thomas5897
  • 61
  • 2
  • 9
  • Refer this link: https://stackoverflow.com/questions/15802511/execute-a-stored-procedure-in-another-stored-procedure-in-sql-server – Laxmi May 03 '18 at 11:13
  • 2
    One workaround is to avoid application roles. But we cannot suggest alternatives without know what you are trying to accomplish. – Dan Guzman May 03 '18 at 11:25

0 Answers0