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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only