Question on table 'dtproperties'.

Is 'dtproperties' a system table? And what does this table usually be used for?
Any information or reference resource would be appreciated!
dtproperties holds any database diagrams that might exist. Yes, it is a
system table even though I have seen situations where it seems to be marked
as a user table...
"Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
news:574C866A-01D2-47F2-B702-A1498F5A1893@.microsoft.com...
> Is 'dtproperties' a system table? And what does this table usually be used
for?
> Any information or reference resource would be appreciated!
|||>dtproperties holds any database diagrams that might exist.
Thank you very much!

>Yes, it is a
>system table even though I have seen situations where it seems to be marked
>as a user table...
In the Management Console, it is displayed in the Tables list, and marked with the Type of 'system';
And However, just as you said, it will be grouped into 'User Tables' in the Query Analyzer.
|||Yes, I've never liked this fact...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
news:410909B0-CA2A-4034-9C34-FE9E26723CA9@.microsoft.com...
> Thank you very much!
> In the Management Console, it is displayed in the Tables list, and marked
> with the Type of 'system';
> And However, just as you said, it will be grouped into 'User Tables' in
> the Query Analyzer.
>
|||I've never liked the fact that EM shows it as 'system'
Dtproperties actually doesn't have any properties of a system table.
Its ID is > 100, it doesn't start with 'sys' and it doesn't have
sysobjects.type value of 's'.
For all intents and purposes it is a USER table.
EM uses it for its own special purposes, so EM displays it as a system
table, but that is only EM.
SQL Server itself has no idea there is anything special about this table.
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OeoahUzKEHA.3472@.TK2MSFTNGP09.phx.gbl...[vbcol=seagreen]
> Yes, I've never liked this fact...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
> news:410909B0-CA2A-4034-9C34-FE9E26723CA9@.microsoft.com...
marked
>
|||It seems dtproperties is somewhere between a system table and a user table.
It's not marked as system but it isn't really user-created either as
indicated by the following:
SELECT OBJECTPROPERTY(OBJECT_ID('dtproperties'), 'IsMSShipped')
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23aWjAbzKEHA.3292@.TK2MSFTNGP11.phx.gbl...[vbcol=seagreen]
> I've never liked the fact that EM shows it as 'system'
> Dtproperties actually doesn't have any properties of a system table.
> Its ID is > 100, it doesn't start with 'sys' and it doesn't have
> sysobjects.type value of 's'.
> For all intents and purposes it is a USER table.
> EM uses it for its own special purposes, so EM displays it as a system
> table, but that is only EM.
> SQL Server itself has no idea there is anything special about this table.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:OeoahUzKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> marked
in
>
|||This doesn't mean anything. Anybody, or any app, can make a table they
create have the value 'IsMSShipped'.
USE pubs
go
CREATE TABLE sillytable
(a INT)
go
EXEC sp_ms_marksystemobject 'sillytable'
go
SELECT OBJECTPROPERTY(OBJECT_ID('sillytable'), 'IsMSShipped')
sillytable is most certainly user created. :-)
HTH
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:e2b0qlzKEHA.1192@.TK2MSFTNGP11.phx.gbl...
> It seems dtproperties is somewhere between a system table and a user
table.[vbcol=seagreen]
> It's not marked as system but it isn't really user-created either as
> indicated by the following:
> SELECT OBJECTPROPERTY(OBJECT_ID('dtproperties'), 'IsMSShipped')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23aWjAbzKEHA.3292@.TK2MSFTNGP11.phx.gbl...
table.
> in
>

Question on table 'dtproperties'.

Is 'dtproperties' a system table? And what does this table usually be used f
or?
Any information or reference resource would be appreciated!dtproperties holds any database diagrams that might exist. Yes, it is a
system table even though I have seen situations where it seems to be marked
as a user table...
"Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
news:574C866A-01D2-47F2-B702-A1498F5A1893@.microsoft.com...
> Is 'dtproperties' a system table? And what does this table usually be used
for?
> Any information or reference resource would be appreciated!|||>dtproperties holds any database diagrams that might exist.
Thank you very much!

>Yes, it is a
>system table even though I have seen situations where it seems to be marked
>as a user table...
In the Management Console, it is displayed in the Tables list, and marked wi
th the Type of 'system';
And However, just as you said, it will be grouped into 'User Tables' in the
Query Analyzer.|||Yes, I've never liked this fact...
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
news:410909B0-CA2A-4034-9C34-FE9E26723CA9@.microsoft.com...
> Thank you very much!
>
> In the Management Console, it is displayed in the Tables list, and marked
> with the Type of 'system';
> And However, just as you said, it will be grouped into 'User Tables' in
> the Query Analyzer.
>|||I've never liked the fact that EM shows it as 'system'
Dtproperties actually doesn't have any properties of a system table.
Its ID is > 100, it doesn't start with 'sys' and it doesn't have
sysobjects.type value of 's'.
For all intents and purposes it is a USER table.
EM uses it for its own special purposes, so EM displays it as a system
table, but that is only EM.
SQL Server itself has no idea there is anything special about this table.
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
news:OeoahUzKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> Yes, I've never liked this fact...
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>
> "Laser Lu" <anonymous@.discussions.microsoft.com> wrote in message
> news:410909B0-CA2A-4034-9C34-FE9E26723CA9@.microsoft.com...
marked[vbcol=seagreen]
>|||It seems dtproperties is somewhere between a system table and a user table.
It's not marked as system but it isn't really user-created either as
indicated by the following:
SELECT OBJECTPROPERTY(OBJECT_ID('dtproperties')
, 'IsMSShipped')
Hope this helps.
Dan Guzman
SQL Server MVP
"Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
news:%23aWjAbzKEHA.3292@.TK2MSFTNGP11.phx.gbl...
> I've never liked the fact that EM shows it as 'system'
> Dtproperties actually doesn't have any properties of a system table.
> Its ID is > 100, it doesn't start with 'sys' and it doesn't have
> sysobjects.type value of 's'.
> For all intents and purposes it is a USER table.
> EM uses it for its own special purposes, so EM displays it as a system
> table, but that is only EM.
> SQL Server itself has no idea there is anything special about this table.
> --
> HTH
> --
> Kalen Delaney
> SQL Server MVP
> www.SolidQualityLearning.com
>
> "Aaron Bertrand [MVP]" <aaron@.TRASHaspfaq.com> wrote in message
> news:OeoahUzKEHA.3472@.TK2MSFTNGP09.phx.gbl...
> marked
in[vbcol=seagreen]
>|||This doesn't mean anything. Anybody, or any app, can make a table they
create have the value 'IsMSShipped'.
USE pubs
go
CREATE TABLE sillytable
(a INT)
go
EXEC sp_ms_marksystemobject 'sillytable'
go
SELECT OBJECTPROPERTY(OBJECT_ID('sillytable'), 'IsMSShipped')
sillytable is most certainly user created. :-)
--
HTH
--
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com
"Dan Guzman" <danguzman@.nospam-earthlink.net> wrote in message
news:e2b0qlzKEHA.1192@.TK2MSFTNGP11.phx.gbl...
> It seems dtproperties is somewhere between a system table and a user
table.
> It's not marked as system but it isn't really user-created either as
> indicated by the following:
> SELECT OBJECTPROPERTY(OBJECT_ID('dtproperties')
, 'IsMSShipped')
> --
> Hope this helps.
> Dan Guzman
> SQL Server MVP
> "Kalen Delaney" <replies@.public_newsgroups.com> wrote in message
> news:%23aWjAbzKEHA.3292@.TK2MSFTNGP11.phx.gbl...
table.[vbcol=seagreen]
> in
>