[Geek] SQL Query

[dancefloorlandmine]

Joy of Microsoft - one of our SQL databases is accessed via an Access front-end. Up until recently, ResearchFinn has been able to remove erroneous rows from the tables by bringing up the table in Access, selecting the row, and pressing Delete. Now, when she does that, an error box pops up which says:

ODBC--delete on a linked table 'dbo_tblAllData' failed.
[Microsoft][ODBC SQL Server Driver]Timeout expired (#0)

It also failed to delete when trying to use a delete query directly within SQL Server itself - it appeared to work when the query was run, but when the query box was then closed, it came up with an Operation cancelled by user message, and didn't commit. However, runnning a delete query from the Access front end worked. Eh?

I'm wondering whether this is any way connected with the recent server C drive problem (see posts passim). I'm going to see whether a reboot (to be scheduled for tonight) solves the problem. I've already tried stopping and restarting the SQLServer service.

Comments

[d-floorlandmine.livejournal.com]

Quite often you can fix a database that's got some minor corruption in without anyone noticing.
But ... but ... I want them to worship me for my l33t skillz. Well, OK, you're right, just getting the damn thing working the way it used to will make ResearchFinn happy, and she used to work at the Marquee, so that's fine ...