capturar error sql?

Article View: chile.comp.programacion

Article #552

Back to chile.comp.programacion Previous Next

#552

From: Pintamono
Date: Wed, 12 Mar 2008 20:21

21 lines
1486 bytes

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: <fr95et$sqk$1@tucows.gtdinternet.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!news.gtdinternet.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 1593cb,10a4f145272588b5,start
X-Google-Attributes: gid1593cb,public,usenet
X-Google-Language: SPANISH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!news.kjsl.com!news.nivel5.cl!news.gtdinternet.com!not-for-mail
From: Pintamono <Pintamono@NoMandeWeas.kk>
Newsgroups: chile.comp.programacion
Subject: capturar error sql?
Date: Wed, 12 Mar 2008 17:21:03 -0300
Organization: Gtd Internet S.A.
Lines: 21
Message-ID: <fr95et$sqk$1@tucows.gtdinternet.com>
NNTP-Posting-Host: kerberos.uno.cl
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Trace: tucows.gtdinternet.com 1205344541 29524 200.27.224.101 (12 Mar 2008 17:55:41 GMT)
X-Complaints-To: usenet@gtdinternet.com
NNTP-Posting-Date: Wed, 12 Mar 2008 17:55:41 +0000 (UTC)
User-Agent: Thunderbird 2.0.0.12 (Windows/20080213)