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 ?