SQL Server 2000 is fine for stuff written in the days of SQL Server 2000.

The basic point here is 'if it broke don't fix it'. If it is broken (or...

Thanks RBarryYoung for being absolutely correct in your comment.

I am the Director of Database Services for a company that is a Microsoft Gold partner for SQL Server Competences.

I hope this...

How about the more experienced posters get together for mutual benefit then:

http://www.sqlservercentral.com/Forums/Topic669857-61-2.aspx

I really support that idea. I think a more private invited members forum would enable me to speak more freely/

Although I am a rookie here, I am also a Microsoft...

Oh, and Steve Jones, a couple of points for you based on your comment, which was considered and useful.

First, I think you write really well (by which I mean you...

I now realise created this thread in an unreasonable fit of self interested annoyance, and then picked out Gail who amongst the best contributors on the site. SORRY GAIL!

It seems...

OK, there are some great points here and perhaps I was being rather uncharitable when I wrote it. It came off the back of trying to research an issue and...

Perhaps you real experts who know lots of stuff can tell me why you persist in advising people who can't blow their nose yet.

This is not a sarcastic point .....

Thank you very much for your help. I have emailed my contact with the information supplied.

I gather that since you are now putting the build into production, you must be...

Its free...

http://technet.microsoft.com/en-us/sysinternals/bb897428.aspx

There is also a tool called DiskView.exe which visualises the fragmentation.

I just did a smallish test defragmenting a 5GB MDF in a dozen pieces on a highly fragmented drive,...

I'm not really familiar with the locking characteristics of the underlying API calls that contig.exe uses (nor how much data it tries to move at a time).

Can you run it...

Thanks for the update. The Diskeeper build that failed for me was 13.0.835. It sounds like you are running a later one.

Diskeeper asked me for some further information early last...

I think disk fragmentation is bad, and should be fixed. SQL Server files are just files like any other and when these are in many pieces there will inevitably be...

Great, thanks

Interesting that you have got the same problem. I was 90% sure that Diskeeper 2009 had prompted it but not certain.

Note that the problem machine was SQL Server 2005 SP2...