stored procedure execute as

  • 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 ?

  • remove the < >

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply