Re: capturar error sql?

Article View: chile.comp.programacion

Article #553

Back to chile.comp.programacion Previous Next

#553

From: Pintamono
Date: Thu, 13 Mar 2008 00:47

27 lines
1845 bytes

Ya lo "hice" en la pega tengo el link...


"Pintamono" <Pintamono@NoMandeWeas.kk> wrote in message 
news:fr95et$sqk$1@tucows.gtdinternet.com...
> como es posible capturar el erro sql cosa de poder insertarlo en una 
> tabla?
>
> Por ejemplo, si coloco select * from vv
> y la tabla vv no existe me arroja este error
>
> Server: Msg 208, Level 16, State 1, Line 1
> Invalid object name 'vv'.
>
> yo lo que quiero es insertar el numero del error y el mensaje del error, o 
> sea, Invalid object name 'vv'.
>
> sin embargo al obtener el error desde la tabla de mensajes
>
> select * from master.dbo.sysmessages where error = 208
>
>
> solo obtengo "Invalid object name '%.*ls'."
>
> existe algun sp_ALGO que me permita hacer lo que quiero?
>
> Gracias.

Technical Details

Message-ID: <fr9tkt$q4r$1@jagger.tie.cl>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!out04b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news-xfer.nntp.sonic.net!news.kjsl.com!news.nivel5.cl!news.tie.cl!not-for-mail

References: <fr95et$sqk$1@tucows.gtdinternet.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,10a4f145272588b5
X-Google-Attributes: gid1593cb,public,usenet
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!out04b.usenetserver.com!news.usenetserver.com!in01.usenetserver.com!news.usenetserver.com!news-xfer.nntp.sonic.net!news.kjsl.com!news.nivel5.cl!news.tie.cl!not-for-mail
From: "Pintamono" <pintamono@NoMandeWeas.kk>
Newsgroups: chile.comp.programacion
Subject: Re: capturar error sql?
Date: Wed, 12 Mar 2008 21:47:53 -0300
Organization: Telefonica Internet Empresa
Lines: 29
Message-ID: <fr9tkt$q4r$1@jagger.tie.cl>
References: <fr95et$sqk$1@tucows.gtdinternet.com>
NNTP-Posting-Host: 190-82-238-192.adsl.cust.tie.cl
X-Trace: jagger.tie.cl 1205369309 26779 190.82.238.192 (13 Mar 2008 00:48:29 GMT)
X-Complaints-To: news@jagger.tie.cl
NNTP-Posting-Date: Thu, 13 Mar 2008 00:48:29 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.2929
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.2929
X-RFC2646: Format=Flowed; Response

Reply to Parent Message