stored procedure execute as

• solus

  Hall of Fame

  Points: 3495

  More actions

  May 15, 2017 at 5:51 am

  #325598

  I need to execute a stored procedure under a specified login but im getting a syntax error
  
  CREATE PROCEDURE <ClearImportData>
  WITH EXECUTE AS 'name here'     
  AS
  BEGIN
  .........

  I get

  'Incorrect syntax near the keyword 'with'
  on the execute line, can anyone see where Im going wrong ?

• FridayNightGiant

  SSCertifiable

  Points: 7151

  More actions

  May 15, 2017 at 6:13 am

  #1942518

  remove the < >