MSSQL 2005 Clear Event Log

[Dinh]

Can anyone tell me how to clear the EVENT log file in MSSQL 2005 Express? I got this error when I tried to open any table in MSSQL 2005 Express. I tried to google the answer but it came up empty. Any advice would be great.

===================================

The event log file is full (Microsoft.SqlServer.Express.SQLEditors)

------------------------------
Program Location:

at System.Diagnostics.EventLog.InternalWriteEvent(UInt32 eventID, UInt16 category, EventLogEntryType type, String[] strings, Byte[] rawData, String currentMachineName)
at System.Diagnostics.EventLog.WriteEntry(String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type, Int32 eventID, Int16 category, Byte[] rawData)
at System.Diagnostics.EventLog.WriteEntry(String source, String message, EventLogEntryType type)
at Microsoft.VisualStudio.Data.DataProvider.LogError(String providerName, String message)
at Microsoft.VisualStudio.Data.DataProviderException..ctor(String providerName, String message)
at Microsoft.VisualStudio.DataTools.DataServices.DataProvider.CreateConnectionProperties(Guid dataSource)
at Microsoft.VisualStudio.DataTools.DataServices.DataProviderManager.CreateConnectionProperties(Guid source, Guid provider)
at Microsoft.VisualStudio.DataTools.DataServices.DataProviderManager.CreateConnectionProperties(Guid provider)
at Microsoft.VisualStudio.DataTools.Providers.SqlServer.SqlDataSourceSpecializer.DeriveDataSource(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataProvider.DeriveDataSource(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnection.SetConnectionStrings(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnection..ctor(DataProvider provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionFactory.CreateDataConnectionImpl(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.Data.DataConnectionFactory.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString, Boolean update)
at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.Microsoft.VisualStudio.Data.Interop.IVsDataConnectionManager.GetDataConnection(Guid& guidProvider, String bstrConnectionString, Boolean fEncryptedString)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

 

[CrazyArcad]

To view the content, you need to sign in or register

the second search result on this search page should help...

have fun

or you could try this

Execute the following script in Query Editor to cycle (reset, clear) the server error log. This system stored procedure closes the current error log file and cycles the error log extension numbers just like a server restart.

USE master;
EXEC sp_cycle_errorlog ;  
GO

 

[Dinh]

Thanks for the quick reply . I went to event viewer and cleared all the logs...it seems to work because it doesn't show any more event log full error, however, it now shows this:

===================================

An unexpected error occurred in the .NET Framework Data Provider for SQL Server. Please contact the provider vendor to resolve this problem. (Microsoft.SqlServer.Express.SQLEditors)

------------------------------
Program Location:

at Microsoft.VisualStudio.DataTools.DataServices.DataProvider.CreateConnectionProperties(Guid dataSource)
at Microsoft.VisualStudio.DataTools.DataServices.DataProviderManager.CreateConnectionProperties(Guid source, Guid provider)
at Microsoft.VisualStudio.DataTools.DataServices.DataProviderManager.CreateConnectionProperties(Guid provider)
at Microsoft.VisualStudio.DataTools.Providers.SqlServer.SqlDataSourceSpecializer.DeriveDataSource(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataProvider.DeriveDataSource(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnection.SetConnectionStrings(String connectionString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnection..ctor(DataProvider provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionFactory.CreateDataConnectionImpl(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.Data.DataConnectionFactory.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.CreateDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString, Boolean update)
at Microsoft.VisualStudio.Data.DataConnectionManager.GetDataConnection(Guid provider, String connectionString, Boolean encryptedString)
at Microsoft.VisualStudio.DataTools.DataServices.DataConnectionManager.Microsoft.VisualStudio.Data.Interop.IVsDataConnectionManager.GetDataConnection(Guid& guidProvider, String bstrConnectionString, Boolean fEncryptedString)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.CreateDesigner()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDataDesignerNode.Open()
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VirtualProject.Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ISqlVirtualProject.CreateDesigner(Urn origUrn, DocumentType editorType, DocumentOptions aeOptions, IManagedConnection con)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.ScriptFactory.CreateDesigner(DocumentType editorType, DocumentOptions aeOptions, Urn parentUrn, IManagedConnection mc)
at Microsoft.SqlServer.Management.UI.VSIntegration.Editors.VsDocumentMenuItem.CreateDesignerWindow(IManagedConnection mc, DocumentOptions options)

===================================

The provider does not implement the data connection properties object.

Ok, I got the database error fixed by restored the whole windows XP back about a month. Then I proceed to install the Cabal like when I first did and I ran into the same problem, which is I can pass the user name and password screen, but then I cannot log into the channel itself. I've already applied youyou's auth server patch and did everything I could possibly think off. I'm gonna post a fresh batch of log file here...Chumpy, cypher, or anyone else...please help me.

I'm using CentOS 5 and had the server running for over a month. It just suddenly stop working!

Log file can be found in this thread: http://forum.ragezone.com/f451/getq-108-error-506015/

Most of the log file has the "Getq 108 Error" but the one i'm most concern with is the LoginSvr_01:

[Fri Dec 5 2008 00:26:30.207588 3086195184]: accept success 11(192.168.1.1:1259)
[Fri Dec 5 2008 00:26:30.207906 3086195184]: 1.open user 11 [93C24D8] (192.168.1.1)
[Fri Dec 5 2008 00:26:30.217405 3077893008]: AuthRequest: UserID(tester), Addr(192.168.1.1)
[Fri Dec 5 2008 00:26:30.249637 3077893008]: AuthResult: UserID(tester), Addr(192.168.1.1), Result(32), UserNum(8)
[Fri Dec 5 2008 00:27:06.409246 3086195184]: 1.close user 11 [93C24D8] (192.168.1.1)
[Fri Dec 5 2008 00:27:54.021826 3086195184]: sock 9 ->LinkHandler close
[Fri Dec 5 2008 00:27:56.121803 3086195184]: sock 7 ->LinkHandler close
[Fri Dec 5 2008 00:27:59.021906 3086195184]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38180)
[Fri Dec 5 2008 00:27:59.021971 3086195184]: try connect 127.0.0.1:38180, Sync
[Fri Dec 5 2008 00:27:59.022264 3086195184]: sock -1 ->LinkHandler close
[Fri Dec 5 2008 00:27:59.022335 3086195184]: [##ERROR##] connect 127.0.0.1:38180 fail
[Fri Dec 5 2008 00:28:01.122263 3086195184]: [##ERROR##] remoteAddr(127.0.0.1), connectRetryNum_(9,0), serverAddr(127.0.0.1:38170)
[Fri Dec 5 2008 00:28:01.122320 3086195184]: try connect 127.0.0.1:38170, Sync
[Fri Dec 5 2008 00:28:01.122458 3086195184]: sock -1 ->LinkHandler close
[Fri Dec 5 2008 00:28:01.122523 3086195184]: [##ERROR##] connect 127.0.0.1:38170 fail
[Fri Dec 5 2008 00:28:02.649935 3086195184]: SIGTERM
3086195184: work_pending_i: Interrupted system call
[Fri Dec 5 2008 00:28:03.237172 3077893008]: CProcessLayer(0)::svc Terminated [3077893008]
[Fri Dec 5 2008 00:28:15.539241 3086498288]: open log file '/var/log/cabal/LoginSvr_01.log'
[Fri Dec 5 2008 00:28:15.539308 3086498288]: LOG LEVEL: 3
[Fri Dec 5 2008 00:28:15.539327 3086498288]: MemPoolUnitSizeClass(0): 14336Bytes
[Fri Dec 5 2008 00:28:15.539862 3086498288]: Start LoginSvr_01 Server
[Fri Dec 5 2008 00:28:15.539895 3086498288]: SITE_CHN, GAMEGUARD_V25, APEX_V10
[Fri Dec 5 2008 00:28:15.539916 3086498288]: TestChannelGroupIdxStartPoint=50
[Fri Dec 5 2008 00:28:15.539950 3086498288]: affiliatedCorpIP=121.170.135.;
[Fri Dec 5 2008 00:28:15.539973 3086498288]: AdminIP=121.170.135.;
[Fri Dec 5 2008 00:28:15.539998 3086498288]: client_version=22
[Fri Dec 5 2008 00:28:15.540013 3086498288]: IgnoreClientVersion(1)
[Fri Dec 5 2008 00:28:15.540030 3086498288]: UseAntiOnlineGameAddictionSystem(1)
[Fri Dec 5 2008 00:28:15.540045 3086498288]: AdultAge(18)
[Fri Dec 5 2008 00:28:15.540059 3086498288]: DefaultAgeAdult(1)
[Fri Dec 5 2008 00:28:15.540075 3086498288]: UsePSS(0)
[Fri Dec 5 2008 00:28:15.540089 3086498288]: CachedPSS(0)
[Fri Dec 5 2008 00:28:15.540103 3086498288]: PssCacheDurationMin(1440)
[Fri Dec 5 2008 00:28:15.540118 3086498288]: CutIfPssUserNotFound(0)
[Fri Dec 5 2008 00:28:15.540133 3086498288]: PssLogLevel(0)
[Fri Dec 5 2008 00:28:15.540147 3086498288]: InstantPlayTimeClearIntervalMin(300)
[Fri Dec 5 2008 00:28:15.540161 3086498288]: IDC(1)
[Fri Dec 5 2008 00:28:15.540175 3086498288]: SharedPssPersonId(0)
[Fri Dec 5 2008 00:28:15.540190 3086498288]: NormalClientMagicKey(1168110)
[Fri Dec 5 2008 00:28:15.540206 3086498288]: UseImageAuth(0)
[Fri Dec 5 2008 00:28:15.540221 3086498288]: ImageAuthDataPath(./ImageAuth/)
[Fri Dec 5 2008 00:28:15.540235 3086498288]: ImageAuthMaxTryCount(5)
[Fri Dec 5 2008 00:28:15.540251 3086498288]: ImageAuthWaitTime(120000)
[Fri Dec 5 2008 00:28:15.540265 3086498288]: BlockIfImageAuthFail(0)
[Fri Dec 5 2008 00:28:15.540280 3086498288]: UseServerListManualOrder(0)
[Fri Dec 5 2008 00:28:15.540294 3086498288]: 00:00 => 0
[Fri Dec 5 2008 00:28:15.540307 3086498288]: V1 = 22, V2 = 5834620, V3 = 0, V4 = 0
[Fri Dec 5 2008 00:28:15.540321 3086498288]: ImageAuthDataMgr Init Begin
[Fri Dec 5 2008 00:28:16.747133 3086498288]: ImageAuthDataMgr Init End(Count:1995)
[Fri Dec 5 2008 00:28:16.748111 3086498288]: try connect 127.0.0.1:38170, Sync
[Fri Dec 5 2008 00:28:16.749521 3086498288]: sock 7 ->LinkHandler Open
[Fri Dec 5 2008 00:28:16.749575 3086498288]: SendIPSConnect2Svr (195:128:01:00)
[Fri Dec 5 2008 00:28:16.753923 3086498288]: try connect 127.0.0.1:38180, Sync
[Fri Dec 5 2008 00:28:16.754476 3086498288]: sock 9 ->LinkHandler Open
[Fri Dec 5 2008 00:28:16.754514 3086498288]: SendIPSConnect2Svr (195:128:01:00)
[Fri Dec 5 2008 00:28:16.754567 3086498288]: try listening 38101 port
[Fri Dec 5 2008 00:28:17.517615 3078196112]: CProcessLayer(0)::svc Start [3078196112]
[Fri Dec 5 2008 00:28:17.517806 3078196112]: ServerState changed(0 -> 0)