Posted by Erland Sommarskog on 10/01/63 11:23

Ray Watson (rwatson@oztell.com) writes:
> I understand the dbo.dtproperties 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' ?

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


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]