CREATE PROCEDURE Usp_Member_Profile
@TfmID int NOT NULL
WITH EXECUTE AS OWNER, SCHEMABINDING, NATIVE_COMPILATION
BEGIN ATOMIC WITH (TRANSACTION ISOLATION LEVEL = SNAPSHOT, LANGUAGE = N'us_english')
Select * from techforum_member_list
WHERE TfmID = @TfmID
Message showing :
Msg 1054, Level 15, State 1, Procedure Usp_Member_Profile, Line 44
Syntax '*' is not allowed in schema-bound objects.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.