Thanks Howard, the dynamic SQL from that blog is just what I needed.

No, the .mdf contains the entire database, and there's a single log file. If a new log file were created in a location with more space, I'm thinking that might...

It's a char field, we're just expanding it from 10 to 64. It's not being updated, there's an index being dropped to expand it, and then the index is added...

update- I find if I full screen SSMS it will return the display and normalcy resumes.

We ended up not being able to resolve this one, and got the developer to add an index hint if it determines the requisite index exists.

Well it worked out on my QA server which has the same customer db schema and was producing the same problem, but not on the actual customer one. I'll have...

I believe a (sync,datatype) index was tried, but I'm not sure more than that ( I have a colleague that's been trying to play with it). I'll give your suggestions...

I don't know about 2000, but 2005 has the SQL Upgrade Advisor tool which runs against the older DB and reports what things will need to be addressed for 2005....

Still looking for opinions on this!

I'm looking at a similar situation, but my servers have replication running. Are there any ramifications to that? Accounting for changing the sql service account, I don't know if I...

Yep that does it. Thanks so much.

It's still putting in an additional zero, but I'll figure that out. The syntax is a little over my head so this is a good project for me.

Aaah, well I don't have control of the schema but that makes sense. Thanks! 🙂

Yes I did try that one, and it didn't appear to make a modification, but I ran it again, here's a snippet of the results:

Original ...

Interesting, definitely some syntax in there I have to learn..

Jeff, your "auto magic" one came the closest but I got some extra zeros I haven't quite figured yet -

Original...