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
>

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
>system table even though I have seen situations where it seems to be marke
>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...
> >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.
>|||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...
> > >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.
> >
>|||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...
> > 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...
> > > >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.
> > >
> >
> >
>|||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...
> > 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...
> > > > >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.
> > > >
> > >
> > >
> >
> >
>

Question on SQL Cluster Resource Groups

I have a sql cluster with my virtual server name, IP address, etc. in one
group. In the other group I have my sql instance, san attached disk
resources, sql agent etc. In this second group I also have a ftp server that
utilizes the vbscript for fail over and uses a san disk resource.
The problem I have is if the second group fails over say, due to a sql
server error which has happened, then my ftp site dies as users put to the
ftp site via the name / ip of the virtual server but then the virtual server
cannot see the disk resources that are part of the second group.
Is there any issues with putting the virtual server name & ip address in the
same group with sql, sql agent, disk resources, etc.? In essence, putting
everything in one group.
Thanks in advance,
John
You have a couple of options, and I'm sure different people may have
different opinions w.r.t. their pros and cons.
Option 1:
Move the resources from group 1 into the second group, and edit the
dependencies property of your virtual server to include the disk resources
you mentioned. In order to protect the HA of your SQL Server instance, you
may want to edit the advanced property tab of the resources--moved over from
group 1--so that their faulire doesn't affect the group.
Option 2:
Keep the groups as they are. Create a file share resource(s) in group 2, and
use the file share via the virtual server. I don't know the nature of your
particular virtual server, so I'm not sure this works for you.
Personally, I prefer to keep the SQL Server group clean, and will try very
hard to question any attempt to include additional resources in that group.
However, in your situation you already have a bunch of non-SQL Server native
resources in the SQL group so adding a few more may not do a great deal more
potential harm (of course that all depends on the details of the virtual
server in question.)
Linchi
"John - PDX" <JohnPDX@.discussions.microsoft.com> wrote in message
news:D5396113-A4A6-4EA3-973F-B4CBF2021CDB@.microsoft.com...
>I have a sql cluster with my virtual server name, IP address, etc. in one
> group. In the other group I have my sql instance, san attached disk
> resources, sql agent etc. In this second group I also have a ftp server
> that
> utilizes the vbscript for fail over and uses a san disk resource.
> The problem I have is if the second group fails over say, due to a sql
> server error which has happened, then my ftp site dies as users put to the
> ftp site via the name / ip of the virtual server but then the virtual
> server
> cannot see the disk resources that are part of the second group.
> Is there any issues with putting the virtual server name & ip address in
> the
> same group with sql, sql agent, disk resources, etc.? In essence, putting
> everything in one group.
> --
> Thanks in advance,
> John
|||I think your biggest problem is one of definition. By definition, each
Cluster Resource Group IS A SEPARATE VIRTUAL SERVER.
Each group has its own Disk, IP, Network Name, and application resources.
If the FTP server is dependent on the SQL Server instance, then define the
FTP site resources within the SQL Server Cluster Resource Group; otherwise,
create a separate Cluster Resource Group for IIS.
Every Cluster has at least 1 resource group BEFORE there exists any failover
applications, the Cluster Group itself, which must stay independent and
uncontaminated by other resources.
Cluster Resource Group:
Quorum Disk, Cluster IP, Cluster Network Name.
Microsoft Distributed Transaction Coordinator (MS DTC) Resource Group:
MSDTC dedicated Disk, MSDTC IP, MSDTC Network Name.
SQL Server Resource Group:
SQL Server dedicated Disk, SQL Server IP, SQL Server Network Name, SQL
Server Instance, SQL Agent.
Internet Information Server (IIS) Resource Group:
IIS dedicated Disk, IIS IP, IIS Network Name, FTP Site.
Although possible to include the IIS resources within the SQL Server
Resource Group, you would be better off creating a separate group dedicated
to IIS resources. End users would connect to SQL Server through the SQL
Server Cluster Resource Group Network Name and SQL Server Instance name
defined within that group. End users would connect to the FTP site through
the IIS Cluster Resource Group Network Name and FTP site name defined within
that group.
Whenever a Cluster Resource Group fails over, the Disk, IP, Network Name,
and dependent application resources defined within that group fail over
together. Even if the SQL Server resource group failed over, the FTP site
would still be available on the original host through the IIS Cluster
Resource Group Network Name. They are independent.
You use the physical node names to define cluster resources and to manage
non-clustered components on each node, like the OS and swap spaces, Network
Backup software, etc. You use the Cluster Resource Group Network Name to
manage the cluster as a whole. You use the MS DTC Network Name to manage MS
DTC, the SQL Server Network Name to manage SQL Server, and, finally, the IIS
Network Name to manager IIS. All independently but from within the same
cluster.
To go one step farther, you should really install separate hardware and
cluster IIS using Microsoft Network Load Balancing high availability
clustering, not Sever Cluster failover clustering.
Hope this helps.
Sincerely,
Anthony Thomas

"Linchi Shea" <linchi_shea@.NOSPAMml.om> wrote in message
news:OqN4Qps0FHA.2932@.TK2MSFTNGP10.phx.gbl...
> You have a couple of options, and I'm sure different people may have
> different opinions w.r.t. their pros and cons.
> Option 1:
> Move the resources from group 1 into the second group, and edit the
> dependencies property of your virtual server to include the disk resources
> you mentioned. In order to protect the HA of your SQL Server instance, you
> may want to edit the advanced property tab of the resources--moved over
from
> group 1--so that their faulire doesn't affect the group.
> Option 2:
> Keep the groups as they are. Create a file share resource(s) in group 2,
and
> use the file share via the virtual server. I don't know the nature of your
> particular virtual server, so I'm not sure this works for you.
> Personally, I prefer to keep the SQL Server group clean, and will try very
> hard to question any attempt to include additional resources in that
group.
> However, in your situation you already have a bunch of non-SQL Server
native
> resources in the SQL group so adding a few more may not do a great deal
more[vbcol=seagreen]
> potential harm (of course that all depends on the details of the virtual
> server in question.)
> Linchi
> "John - PDX" <JohnPDX@.discussions.microsoft.com> wrote in message
> news:D5396113-A4A6-4EA3-973F-B4CBF2021CDB@.microsoft.com...
the[vbcol=seagreen]
putting
>