December 11, 2008 at 9:15 am
I was developing a web app with SQL 2008 but I've managed to get my database into a right knot. I was altering a LINQ to SQL dbml file in visual studio (dragging and dropping tables into the schema). I ran up the application and next thing all subsequent queries fail. Futhermore I can't expand any of the stored procedure folders in ANY database. I keep getting the above error. I see lots of posts to the effect...try re-running the query with without the NOLOCK hint or whatever. What query??? I didn't run a query. I was working on a database through visual studio GUI.
I dropped every database except the system databases but still get the same error.
I rebuilding the system data. Same error!!!
Now I feel I've no alternative to reinstall SQL server which is a big deal.
Anybody have any ideas.
December 11, 2008 at 12:12 pm
From an older post on this forum - the suggestion there was to check for corruption...since you didn't mention this in the list of things you already did you might want to check it out...
http://www.sqlservercentral.com/Forums/Topic473623-146-1.aspx
December 11, 2008 at 4:16 pm
I actually saw that post. However it did not expand on how to diagnose if a database was corrupted. I ran a dbcc checkdb against all the system databases and it didn't show up anything.
In the end I had to repair the sql server installation and this did the trick. Its an unsatisfactory solution though as I'm still non the wiser if there's a more elegant solution.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply