Issue was resolved by after updating to SP2 and applying CU15. sys.dm_db_index_physical_stats behaving correctly now.

Regarding SQL Server 2000 Personal and *Workgroup* editions, here is the upgrade path according to MSDN:

http://msdn2.microsoft.com/en-us/library/ms143393.aspx

However, when I checked the updated BOL, "Editions of SQL Server 2000" topic,...

Grin - You know my environment well.  Thanks for the tips.

-N

Thank you for your replies and sorry for being so vague.  My coworker is vague with me and its been nearly a year since we sat down together and converted...

I use Spotlight on SQL from Quest - great tool.

I've also got Log Explorer (don't use it as much as I thought I would)

I'm also in the process of building a MOM...

Your comments are much appreciated.  It is pretty much as I thought.  There is a better implementation of the Merlia driver that does not require modification to the master db...

I appreciate the assistance, but the condencending tone is neither helpful nor appropriate. I was merely stating my expectation that when a given table was recreated via the snapshot , it would be recreated with the same properties as the source...

Yeah, I tried that. There are constraints that prevent data refresh when the "keep the table unchanged" option is set.  I was surprised that the "drop the existing table and...

amackay_1 is correct. If you need to install SQL server on Win2k Professional, use the Personal Edition. It's on the 2nd CD.

Curiosity got the better of me and I opened a case with Microsoft. Looked like somebody had mucked with the sysobjects table. I can elaborate, but best to...

At one time, there were indeed 15 columns - a rowguid column had been created for replication, then deleted in favor of another strategy. But sp_depends does not reveal...

To answer mccork's questions:

1. There is no column referencing involved.

2. The column I want to change has colid=8 in syscolumns. 14 is the last colid...

Well under 8K - I'm not even able to increase size by 1.

I also posted this in the General forum and a couple of responders thought there might be confusion...

That was a good thought but the table doesn't approach the maximum row size.

I can't even increase the size of the coulumn by 1.

Is the Torn Page Detection option useful in SQL 2K?