I don't see why not, in DTS simply use a query to extract the data from the file and put the conditional constraint in there.

Also, because you are using index defrag you are fortunate in the fact that everything that has been done to the point in time that it timed out is still...

I'd never want TempDB to fill up, if you're getting errors like this then you need to make sure that it is made much larger.

I currently have 4 MDF (one...

We had a couple of phone conferences with a few supliers when we were looking into the feasibility of iSCSI for our databases to live on.

Almost all of their storage...

I'd sure they'd be ok with it.

Who in their right minds would smoke cigarrettes? they (and I'm talking about all manufacturers of lethal devices here) make them as simple ornaments...

and why would you want to give anything back to the OS (greed thing that it is), might as well keep it for SQL to use

I don't know about 'ghost' records but I've had to deal with a few 'zombie' processes in my time

I've had a few problems in the past changing the owner back to SA, it always said that SA was already a member of the database.

To get around it I...

I think you might have answered your own questions.  It sounds to me as if you have some bad memory in the server and it's causing SQL to throw an...

Personally I'd go for 3a if you can arrange to have the downtime

the latest CTP releases are all branded beta3 on the splash screens so that's probably where the confusion is comming from.

Thanks Frank,

I'd forgotten to add the update stats bit after the online defrag, but thought that Clive was experienced enough to know that anyway

You could always try an online defrag, but we all know how transaction log hungry that is.

Sounds like there's a whole lot of insert/update/delete activity going on so maybe it's...

There really is no substitute for learning this sort of thing for yourself, however, I think that Quest Central does what you are asking (although I can't say how well...

If it's hard to say whether the table is split across both files or not then you should probably think what would you do if it was just the one...