that yields proper result (^ is delimiter):

/* object_id^name^column_id^system_type_id^user_type_id^max_length^precision^scale

^collation_name^is_nullable^is_ansi_padded^is_rowguidcol^is_identity^is_computed^is_filestream^is_replicated^is_non_sql_subscribed^is_merge_published^is_dts_replicated^is_xml_document^xml_collection_id^default_object_id^rule_object_id

-105^name^1^231^256^256^0^0

^SQL_Latin1_General_CP1_CS_AS^0^1^0^0^0^0^0^0^0^0^0^0^0^0

-105^xtype^3^175^175^2^0^0

^SQL_Latin1_General_CP1_CS_AS^0^1^0^0^0^0^0^0^0^0^0^0^0^0

-105^type^14^175^175^2^0^0

^SQL_Latin1_General_CP1_CS_AS^1^1^0^0^0^0^0^0^0^0^0^0^0^0

*/

Note that our table is not in sys.system_objects.

sp_help SysOurTables

/*

Column_name^Type^Computed^Length^Prec^Scale

^Nullable^TrimTrailingBlanks^FixedLenNullInSource^Collation

:::

Name^varchar^no^40^ ^

^yes^no^yes^SQL_Latin1_General_CP1_CS_AS

:::

*/

sp_help sysobjects

/* Column_name^Type^Computed^Length^Prec^Scale

^Nullable^TrimTrailingBlanks^FixedLenNullInSource^Collation

name^sysname^no^256^ ...

checked collation. It is correct for all databases & both tables.

as stated at top, everything is collation of SQL_Latin1_General_CP1_CS_AS.

Only interested in SQL 2005 (2000 is working fine).

the columns are *not* identical ... unless SQL changed the rules for identifiers.

 `sp_dbcmptlevel ThisDb, 80` only worked yesterday; it stopped working today.   Any chance the...

Solved CREATE DATABASE on other drive.  Permissions issue.

Windows Start -> Administrative Tools -> Component Services -> Services (local) -> MSSQLServer, right clicked Properties.

LogOn was `Local System account`, changed to `This...

 but may be related.  No solution yet.

Getting very similar situation when trying to make a new database.

SQL Server 2005 just installed (after uninstalled 2000 but...

What language are we storing in the db?  Case matters most to the people writing reports, so if your data is sEnSitive so...

Curious if Microsoft is going to do anything to keep it from crashing in this case. Should be possible to have it report db name as `problem with owner`...

Thank you all for responding. While I know SQL does not guarantee any consistent sorting ( despite inconsistencies in the documentation which imply you can do it), I am...

needs to be order of entry, which precludes an index in this case.

We did go to latest service pack in late January... can't recall if it was 3 or 6.