Print statement not displaying message

Question

hi,

 

This is my stored procedure :

 

USE [kiwi]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[uspAddMemberTeam]
@TeamID INT,
@MemberID INT,
@MemberRole TINYINT

AS BEGIN

SET NOCOUNT ON;
DECLARE @MemberLoginID INT;
select @MemberLoginID =[MemberLoginID] FROM [MemberLogin] WHERE MemberID=@MemberID;

INSERT INTO TeamMember(TeamID,MemberID,MemberRole,MemberJoinedDate,MemberLoginID)values(@TeamID,@MemberID,@MemberRole,GETUTCDATE(),@MemberLoginID);

Print 'Added success..';

END

 

When I execute this procedure not displaying Print statement.