Logging exceptions
- From: "Avi" <m@xxxxx>
- Date: Mon, 4 Jul 2005 17:01:40 +0300
Hi experts,
I'm using C# to write a .NET service. I would like to be able to log all
error messages related to the database into my log file. In other words all
exception that originated from a query, command, connection objects etc.
will be logged to my file and then thrown back.
What is the best way of doing it?
Thanks a million,
Avi
.
Relevant Pages
- Re: How to attach db with missing log file?
... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
(microsoft.public.sqlserver.server) - RE: Shrink File?
... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
(microsoft.public.sqlserver.setup) - Re: PerfMon recording to SQL 2005
... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
(microsoft.public.sqlserver.server) - Transaction log problems
... just before you backup the ... database change the recovery model to ... Simple, shrink the log file then change it back to Full, ... >transaction log and it is causing us some problems. ...
(microsoft.public.sqlserver.server) - Re: sp_attach_single_file_db
... Being that Rob has access to the database and can still ... Stop sql server and rename the existing MDF to a new one and copy the ... Now execute the undocumented DBCC to create a log file ...
(microsoft.public.sqlserver.server) |
|
