Hi,

Also I remowe Print.. I get the same result.
I have changed Stored procedure to use user defined message instead
string

SP_addmessage 500001,16,1, ' entry is nod valid'

CREATE PROCEDURE up_Validate @Field nvarchar(7)
AS
DECLARE @DBID INT
SET @DBID = DB_ID()

DECLARE @DBNAME NVARCHAR(128)
SET @DBNAME = DB_NAME()

Select * from Table1 where X = @Field

IF @@RowCount = 0
BEGIN
RAISERROR (50001, 16,1, @DBID, @DBNAME)
END

In query analyzer both alternatives work without problem