Posted by Hugo Kornelis on 12/27/06 23:00

On Wed, 27 Dec 2006 15:36:53 +0100, fireball wrote:

>how to try-catch sp_addrolemember?

Hi fireball,

This should work

BEGIN TRY
EXEC sp_addrolemember ......
END TRY
BEGIN CATCH
PRINT 'Oops, error!'
END CATCH

--
Hugo Kornelis, SQL Server MVP

[Back to original message]