Thank you Jeff for your wonderful post.

It has been extremely helpful to achieve faster speed in a test case I was creating on sql azure.

I referenced your post in the...

UPDATE:

also newly created views are shown as System.

In sysobjects i can see different and negative values for their Status field.

Anybody knows where sql stores the default Status for a newly...

I have created a table from Query Analyzer with this script:

CREATE TABLE [mario] (

 [aaa] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [bbb] [char] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

 [ccc] [char]...