SQLKnowItAll (1/18/2013)
..., but I don't know how to test.
Did someone steal your login credentials?
CREATE PROCEDURE TestErr
AS
DECLARE @Err NVARCHAR(255);
BEGIN TRY
SELECT 1 / 0
END TRY
BEGIN CATCH
SET @Err = 'Errrr';
RAISERROR(@Err, 16, -1);
END CATCH;
GO
EXEC TestErr;
GO
CREATE PROCEDURE TestErr2
AS
BEGIN TRY
DECLARE @Err NVARCHAR(255);
SELECT 1 / 0
END TRY
BEGIN CATCH
SET @Err = 'Err 2';
RAISERROR(@Err, 16, -1);
END CATCH;
GO
EXEC TestErr2;
GO
