How do I supress dbcc messages?

• Rickard Jansson

  SSChasing Mays

  Points: 608

  More actions

  May 9, 2007 at 1:27 am

  #91104

  Hi all.

  I'm trying to create a login handler that will be transparent through SQL versions ( 2000 and onward ).

  My first problem is that for example sp_addlogin run "dbcc auditevent" and by that return a message that I would like to supress.

  My second problem is that trying to bundle the login control into a procedure is not possible since for example sp_addlogin check @@trancount and if <> 1 procedure won't run.

  I would like to do it all in SQL.

  Any idea's on how to continue?

  Regards

  Rickard Jansson

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  May 9, 2007 at 4:05 am

  #705165

  hi

  to supress the messages use the "WITH NO_INFOMSGS" option with the command.

  "Keep Trying"