software to repair SQL database

[jonshaw_uk]

I been using a piece of software to audit our PCs and software at work. All was going fine until the damn software crashed and its saying there is a problem with the SQL database. As i dont have a clue about SQL i was wondering if anybody knows of a decent app to try and resurect it from the dead before i have to start all over again

 

thanks

[Attero]

REPAIR db_name_here

 

I know that works for MySQL anyway...

[Soop Dogg]

What is the precise error message that you are getting?

 

(A screenshot is always best)

[jonshaw_uk]

this is from the log file, but i have no idea what it all means

 

2010-12-06 19:16:30,136 [1] ERROR AuditWizardv8.LaytonCabApplication Exception occurred in Main().

Microsoft.Practices.CompositeUI.Services.ModuleLoadException: Failed to load module from assembly Layton.AuditWizard.Network, Version=8.3.0.22690, Culture=neutral, PublicKeyToken=null. Error was:

Failed to load module from assembly Layton.AuditWizard.Network, Version=8.3.0.22690, Culture=neutral, PublicKeyToken=null. Error was:

There is no row at position 0. ---> System.IndexOutOfRangeException: There is no row at position 0.

at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex)

at System.Data.RBTree`1.get_Item(Int32 index)

at System.Data.DataRowCollection.get_Item(Int32 index)

at Layton.AuditWizard.Network.NetworkExplorerViewPresenter.InitializeNetworkView()

at Layton.AuditWizard.Network.NetworkExplorerView.RefreshView()

at Layton.AuditWizard.Network.NetworkWorkItemController.RefreshView()

at Layton.AuditWizard.Network.NetworkWorkItemController.ActivateWorkItem()

at AuditWizardv8.LaytonToolbarsController.toolbarsWorkspace_AfterRibbonTabSelected(Object sender, RibbonTabEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnAfterRibbonTabSelected(RibbonTabEventArgs e)

at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)

at Infragistics.Win.UltraWinToolbars.Ribbon.OnSelectedTabItemChanged(Object sender, SelectedTabItemChangedEventArgs e)

at Infragistics.Win.UltraWinTabs.TabManager.set_SelectedTabItem(ITabItem value)

at Infragistics.Win.UltraWinToolbars.Ribbon.InitializeTabManagerSelectedTab(ITabItem tabToSelect, Boolean ignoreSelectedTabEvents, Boolean allowMinimizeRibbonDropDown)

at Infragistics.Win.UltraWinToolbars.Ribbon.SetSelectedTab(RibbonTab tab, Boolean expandRibbonIfCollapsed, Boolean forceSkipEvents)

at Infragistics.Win.UltraWinToolbars.Ribbon.set_SelectedTab(RibbonTab value)

at Layton.Cab.Interface.LaytonWorkItemController.Initialize()

at Layton.Cab.Interface.LaytonModuleInit.Load()

at Microsoft.Practices.CompositeUI.Services.ModuleLoaderService.ModuleMetadata.InitializeModuleClasses(WorkItem workItem)

--- End of inner exception stack trace ---

at Microsoft.Practices.CompositeUI.Services.ModuleLoaderService.ModuleMetadata.ThrowModuleLoadException(Exception innerException)

at Microsoft.Practices.CompositeUI.Services.ModuleLoaderService.ModuleMetadata.InitializeModuleClasses(WorkItem workItem)

at Microsoft.Practices.CompositeUI.Services.ModuleLoaderService.InnerLoad(WorkItem workItem, IModuleInfo[] modules)

at Microsoft.Practices.CompositeUI.Services.ModuleLoaderService.Load(WorkItem workItem, IModuleInfo[] modules)

at Microsoft.Practices.CompositeUI.CabApplication`1.LoadModules()

at Microsoft.Practices.CompositeUI.CabApplication`1.Run()

at AuditWizardv8.LaytonCabApplication.Main()