There is a system table which has all the errors and corresponding error messages mapped in it. will
find and mail you at the earliest. But not sure whether that is the one you are looking for.

Cheers!!!
Vijay G



 Law Chin Choon wrote:Hi,

Is it possible for me to capture the sql server generated system error 
message into a local variable within a stored procedure? Any solution like 
extended procedure can help? Any resources to refer?

Thanks & Regards,
Chin Choon


---------------------------------
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes