Please correct me if I have wrong logic ,I want to show to use that email invalid so I thought to send him the print message from SQL server
how do catch in my web application or tell the user that 'Email invalid' from my below procedure
I need to send to my web application the PRINT message Email invalid' from the procedure
USE [DBAPP]
GO
/****** Object: StoredProcedure [dbo].[spChangePassword] Script Date: 09/05/2014 11:38:29 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spChangePassword]
@Email varchar(75),
@iOldPassword varchar(20),
@NewPassword varchar(20)
--@ConfirmPassword varchar(20)
-- need to check old password if ex ...
Go to the complete details ...