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

• Next in forum: Replacement for my LIKE Clause
• Prev in forum: Re: Selecting last date
• Thread view: Re: how to try-catch 'sp_addrolemember'?

[Reply to this message]