|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
March 2nd, 2004, 01:29 AM
|
|||
|
|||
|
stored procedure error views
Dear Team,
Can any body tell in which table the stored procedure eror details are stored. When any stored procedure is compiled the compilation errors are stored in which table. i.e equivalent to user_errors as in Oracle. Any help will be greatly appeciated. Regards, DBA (DataBase Admiror)
|
|
#2
March 4th, 2004, 03:57 PM
|
|||
|
|||
|
master..sysmessages contains all the system messages. Is this what you're looking for?
__________________
Up the Irons What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
|
|
#3
March 5th, 2004, 03:12 AM
|
|||
|
|||
|
Thanks for the info. sysmessages table has only the messages with severity and other details. But I want to know how the QueryAnalyser is able to corelate the error messages and executed procedure. i.e When I compile a procedure by name "MyProc" during error scenario the QueryAnalyser displays the error details and the line no, name of the procedure etc. I believe that the DataBase will be storing these details in any table.
|
|
#4
March 5th, 2004, 09:16 AM
|
||||
|
||||
|
from within the database, try running this query
Code:
SELECT A.name, B.text FROM sysobjects A INNER JOIN syscomments B On (A.id = B.id) WHERE (A.xtype = 'p') ORDER BY A.name
|
|
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > stored procedure error views |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
