|
|
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
Navigation:
[Reply to this message]
|