none
Natively Compiled Stored Procedures

    Question

  • CREATE PROCEDURE Usp_Member_Profile 
       @TfmID int NOT NULL
    WITH EXECUTE AS OWNER, SCHEMABINDING, NATIVE_COMPILATION
    AS
    BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = N'us_english')
     Select * from techforum_member_list
    
        WHERE TfmID = @TfmID
    END;
    GO

    Message showing :

    Msg 1054, Level 15, State 1, Procedure Usp_Member_Profile, Line 44
    Syntax '*' is not allowed in schema-bound objects.
    

    Tuesday, July 08, 2014 9:36 PM

Answers