Re: how to surpress a server error msg?
From: == Steve Pdx== (lins_at_nospam.portptld.com)
Date: 05/21/04
- Next message: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Previous message: Ivan Alexander Laverde: "Error repair DB with dbcc checkdb"
- In reply to: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Next in thread: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Reply: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Reply: Aaron Bertrand - MVP: "Re: how to surpress a server error msg?"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 21 May 2004 09:09:46 -0700
well, i'd rather not to change the system stored procedure since that would
mean i have to change that particular sp on all servers!
i'd prefer a solution to control the display.
i was calling the sp thru SQL pass thru in Access and return the query
result to display in an Access report. (the query set, not the error msg)
"Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in
message news:OExOyt0PEHA.2236@TK2MSFTNGP10.phx.gbl...
> That would be a client issue, but I assume that you are using QA and it
doesn't have any awareness of any
> particular stored procedures; it just displays whatever error comes back.
One option can be to copy the source
> code for the proc and modify it so it doesn't return that error message (I
assume that there's a RAISERROR
> with that error somewhere in the source code).
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> "== Steve Pdx==" <lins@nospam.portptld.com> wrote in message
news:%23xdrpj0PEHA.640@TK2MSFTNGP12.phx.gbl...
> > background sql2k on nt5.
> >
> > when using stored procedure sp_helprotect against a login. I've got the
> > following msg in query analyzer messages tab.
> >
> > Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
> > There are no matching rows on which to report.
> >
> >
> > is it possible to surpress that msg and just display the Grid tab?
> >
> > thank you.
> >
> >
> > steve
> >
> >
>
>
- Next message: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Previous message: Ivan Alexander Laverde: "Error repair DB with dbcc checkdb"
- In reply to: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Next in thread: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Reply: Tibor Karaszi: "Re: how to surpress a server error msg?"
- Reply: Aaron Bertrand - MVP: "Re: how to surpress a server error msg?"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
