dbo.dtproperties information

[Ray Watson]

Hi All

I understand the dbo.dtpropertie s tables is a system table, but it appears
under "User Tables" in my Query Analyzer.

Is this normal , or does it signify a problem ? I have never seen it there
before.

In the sysobjects table, the xtype field and type field for dtproperties
table, have been set to 'U', which I thought meant User.

Perhaps I should just set them back to 'S' ?

All sugestions welcomed

Cheers

Ray

[Erland Sommarskog]

Re: dbo.dtpropertie s information

Ray Watson (rwatson@oztell .com) writes:[color=blue]
> I understand the dbo.dtpropertie s tables is a system table, but it appears
> under "User Tables" in my Query Analyzer.
>
> Is this normal , or does it signify a problem ? I have never seen it there
> before.
>
> In the sysobjects table, the xtype field and type field for dtproperties
> table, have been set to 'U', which I thought meant User.
>
> Perhaps I should just set them back to 'S' ?[/color]

No. That's the one table that has type = U, but Objectproperty( id,
'IsMSShipped') = 1.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarsk og.se

Books Online for SQL Server SP3 at

http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp