.NET Framework - Event log file is full
Asked By Tony A.
16-Dec-09 12:35 AM
I creating an ASP .Net application with a SQL Server database backend. When
I try to create as connection using the wizard the following error appears
How can I clear this file? Where is the file located. Any assistance is
appreciated.
--
Tony
SQL Server
(1)
System.Diagnostics.EventLog
(1)
Computer
(1)
Database
(1)
Log
(1)
ManageExpand
(1)
IsI
(1)
Joe Cool replied to Tony A.
=A0When
s
e is
I recommend doing some research into the System.Diagnostics.EventLog
Class.
Chris Dunaway replied to Tony A.
Try this:
Right click on My Computer and choose Manage
Expand the Event Viewer node and you should see the logs.
Right click the event log in question and choose properties.
Under Log Size choose the option that says "Overwrite events as
needed".
Chris
Is Linq to SQL any good? .NET Framework I am a big fan of linq but in my opinion linq to sql is a complete waste of time. Why on earth take something that is already complex (sql) and make it more complex and difficult to write by creating a translation layer. I see people here struggling to write linq to sql queries. It also creates the problem of being locked into a particular product with regards to the database which is exactly the problem I thought a translation layer would be designed to solve as generally in newsgroups on those who disagree reply. :-) Thanks in advance, Michael C# Discussions SQL Server 6.5 (1) SQL Server (1) Windows Communication Foundation (1) MySQL (1) Entity Framework (1) Visual Studio (1) Silverlight
View timed out every now and then .NET Framework We are using SQL Server 2005 and VB.NET 2008. We have a view that is called by the application SELECT of 2 more views and a table. When I run the view on the SQL Server Management Studio, it runs for 2 seconds. Most of the time when the view is error "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.), even after I set the command time out to 45 seconds (which view runs fast most of the time, but very slow once or twice a day ? SQL Server machine has 8 processors of 2993 Mhz each and 32 MB of RAM. Right now the available physical memory there is 18.48 GB, and SQL Server is using 9-50% of CPU and 11, 358, 080K of RAM. It has
Timeout expired. The timeout period elapsed prior to completion ofthe operation or the server is not responding. .NET Framework Our application is in VB.NET 2008 and our database is SQL Server 2005. Our application runs on Windows Server 2003 R2 Standard Edition SP 2. The database runs on Windows Server 2003 R2 Enterprise x64 Edition SP 1. The database server has many databases. The database connection string in the program uses a name instance
UI.WebControls.DetailsViewInsertEventArgs) Handles DetailsView2.ItemInserting Dim student As Integer Dim comd As SqlCommand Dim sql, id As String ' check amount of student for project 'A' in table 'student' Using mConnection As New SqlConnection(param.ConnectionString) mConnection.Open() sql = "select count(*) from student where id = @id" comd = New SqlCommand sql, mConnection) comd.Parameters.AddWithValue("@id", 'A') student = comd.ExecuteScalar mConnection.Close() End Using If student WebControls.DetailsViewInsertedEventArgs) Handles DetailsView2.ItemInserted Page.ClientScript.RegisterClientScriptBlock(Me.GetType(), End Sub ASP.NET Discussions SQL Server (1) DetailsViewInsertedEventArgs (1) DetailsViewInsertEventArgs (1) SQL Server Books Online (1) RegisterClientScriptBlock (1) Page (1) Stored procedure (1) SqlConnection (1) There is nothing But the trigger would protect you if those naughty students try you out. - - Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Links for SQL Server Books Online: SQL 2008: http: / / msdn