Do Basically Anything 😀

Hello,

Glad to see that we are not the only people on earth who still have to maintain a SQL 2000 cluster 😛

I never did this type of change myself but...

Hi,

I would not rely too much on sp_MSforeachdb because it might skip one or several databases on a busy server.

Also I would not skip dbo either, dbo can be mapped...

I got it wrong because I was reading 'Data files can be moved...' when I was actually thinking 'Data can be moved..'

Welll, reading questions correctly is also part of the...

I tried a couple of things and you are right Update statistics doesn't prevent access to data (read, update or write).

However it does hold some locks at the table level...

You are right that won't always be the most efficient option.

However I performed several benchmarks and between the two queries (with and without hint) it tends to only have 200/300...

Hello,

I have a similar issue with my database restore script (on SQL Server 2005 SP3).

The script loops into a database name list and is designed to continue if any error...

TheSQLGuru (7/12/2011)

Ninja's_RGR'us (7/11/2011)

Anyway, I think there was at least one unanswered question about why dbcc updateusage 'prevents' the problem....

Hi, thanks for the proposal but I work in Paris 😉

Hi all,

I did not give up on it and I'd like to give a final update on this thread for the people who kindly tried to help and for those...

heehee I was sure someone would jump to the compatibility level 80 😀

The DB is still in sql 2000 mode for many reasons (probably bad reasons) but unfortunately my company...

Thanks to you for your quick reply and suggestions.

@david-2, I'll look to you links, maybe I will find some clues for my issue.

The indexing is pretty simple....