Just reattach. In SQL2K right click databases, select attach, browse to find the files. In SQL 7 use sp_attach. See BOL for details.

Andy

This wont work?

Select * from whatever where field between 'al' and 'com'

Andy

Neil, Im not having this problem, was just commenting. I try to avoid 80% anyway!

Andy

So you still have the mdf? In SQL2K, just right click on databases in Enterprise Manager, selet attach, then browse and select the file. In SQL7 you'll need to use...

Saw this same error tonight in another context - had dropped a transactional publication and replaced with trans + immediately updating subscriber, got the error when it tried to do...

Im not sure what you're referring to - do you mean a text field in a table? Or a file in the file system?

Andy

Thanks for the follow up!

Andy

Im running the same software config on two boxes, one an 8 processor box with 8G of ram, the other 4 processors 4G, have not seen this problem.

Andy

I have to ask - why would you move the error logs?

Andy

I've seen this - it does show up in the error log, so at least once you start looking for a problem there is a clue left!

Andy

Very cool fellow readers! Great example of working through a problem to find a better solution.

Andy

David, you could create an empty mdf that has this issue and email it to me?

Andy

Lots of different ways to build connect strings, here is one that should work:

Provider=SQLOLEDB.1;Password=test;Persist Security Info=True;User ID=TestUser99;Initial Catalog=master;Data Source=eg

I use the trick of creating a empty text file, renaming with...

Sounds like a permission problem maybe?

Andy

I like the temp table idea as a start, maybe even step back and look for another way to solve it - maybe something like getting your criteria into a...