soif I put that 3 GB switch on that boot.ini file, then sql server can get up to 32 GB of physical Ram (assuming that is what that box has)? ...

Hi ,

I ran that whole query from

CREATE Table SpaceUsedByObject   to  ... UPDATE SpaceUsedByObject

part.

I have sql server...

Dynamite.  It worked.  The dropping and recreateing the clustered index part.

I used dbcc dbreindex...

thank you very much in solving this complex...

Do you have another server beside this one? if so, you can copy from syslogins (using bcp) - the builtin administrator row from server A to server B's master.  Builtin Administrator...