http://dbshelp.devio.at/index.php?action=history&feed=atom&title=Dbo.ErrorLogtable 2026-05-02T11:42:51Z Revision history for this page on the wiki MediaWiki 1.30.0 http://dbshelp.devio.at/index.php?title=Dbo.ErrorLogtable&diff=2540&oldid=prev 2010-06-23T22:07:26Z

<p>New page: == wikibot == {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot; |- valign=&quot;top&quot; | &#039;&#039;&#039;Table | dbo.ErrorLog |- valign=&quot;top&quot; | &#039;&#039;&#039;Description | Audit table track...</p> <p><b>New page</b></p><div>== wikibot ==<br /> <br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- valign=&quot;top&quot;<br /> | '''Table<br /> | dbo.ErrorLog<br /> |- valign=&quot;top&quot;<br /> | '''Description<br /> | Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.<br /> |}<br /> <br /> === Columns ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Column<br /> | '''Data Type<br /> | '''Nullable<br /> | '''Default<br /> | '''Description<br /> <br /> |- valign=&quot;top&quot;<br /> | ErrorLogID<br /> | int<br /> | not null<br /> | <br /> | Primary key for ErrorLog records.<br /> |- valign=&quot;top&quot;<br /> | ErrorTime<br /> | datetime<br /> | not null<br /> | (getdate())<br /> | The date and time at which the error occurred.<br /> |- valign=&quot;top&quot;<br /> | UserName<br /> | sysname<br /> | not null<br /> | <br /> | The user who executed the batch in which the error occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorNumber<br /> | int<br /> | not null<br /> | <br /> | The error number of the error that occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorSeverity<br /> | int<br /> | null<br /> | <br /> | The severity of the error that occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorState<br /> | int<br /> | null<br /> | <br /> | The state number of the error that occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorProcedure<br /> | nvarchar(126)<br /> | null<br /> | <br /> | The name of the stored procedure or trigger where the error occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorLine<br /> | int<br /> | null<br /> | <br /> | The line number at which the error occurred.<br /> |- valign=&quot;top&quot;<br /> | ErrorMessage<br /> | nvarchar(4000)<br /> | not null<br /> | <br /> | The message text of the error that occurred.<br /> |}<br /> <br /> === Primary Key ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Primary Key<br /> | '''Columns<br /> |- valign=&quot;top&quot;<br /> | PK_ErrorLog_ErrorLogID<br /> | ErrorLogID<br /> |}<br /> <br /> === Dependencies ===<br /> {| border=&quot;1&quot; cellpadding=&quot;5&quot; cellspacing=&quot;0&quot; style=&quot;border-collapse:collapse&quot;<br /> |- style=&quot;background:silver&quot;<br /> | '''Reference Type<br /> | '''Object Type<br /> | '''Referencing Object<br /> <br /> |- valign=&quot;top&quot;<br /> | Insert<br /> | Procedure<br /> | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]<br /> <br /> |}</div>

Bot