Re: Report of the Best Practice Analyser

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 13:43:55 +0100

If you drop the table, the constraints will go as well.

This table gets created when you create database diagrams in a database.
Even clicking on the 'Diagrams' node in Enterprise Manager, results in this
table creation. If you don't have any database diagrams, then you may drop
this. There is absolutely no harm in having this table though. 

-- 
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"Mueller-Lynch Thomas" <MuellerLynchThomas@discussions.microsoft.com> wrote
in message news:627E3CF7-84A0-47F5-ACB3-CF9A932D3A75@microsoft.com...
Do I delete these constraints
pk_dtproperties PK PRIMARY KEY constraint
DF__dtpropert__versi__4A0EDAD1 D Default or DEFAULT constraint
automatically while dropping the table dtproperties?
Can you exlain me why I have these contraints? Did someone create them in
the past?
Thanks Thomas
"Narayana Vyas Kondreddi" wrote:
> dtproperties is used for storing diagrams. Can be dropped if you wish to.
> -- 
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
>
>
> "Mueller-Lynch Thomas" <MuellerLynchThomas@discussions.microsoft.com>
wrote
> in message news:280AD69E-DF68-4B9F-B91D-924E942028F9@microsoft.com...
> I have a dtproperties tabel in my master database - not a dt_properties
> table.
>
> Thomas
>
>
> "Narayana Vyas Kondreddi" wrote:
>
> > I asked you if you have a dt_properties table in your master database?
Can
> > you confirm that?
> > -- 
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> >
> >
> > "Mueller-Lynch Thomas" <MuellerLynchThomas@discussions.microsoft.com>
> wrote
> > in message news:7E022F01-B89A-4A9C-8685-F626D1E6479E@microsoft.com...
> > Yes theses constraints exist in the master database!
> > But how to delete them?
> > Should I delete them?
> >
> > Thomas
> >
> > "Narayana Vyas Kondreddi" wrote:
> >
> > > Seems like these constraints are associated with a table dt_properties
> > (used
> > > for storing database diagrams). Can you check if this exists in your
> > master
> > > database?
> > > -- 
> > > HTH,
> > > Vyas, MVP (SQL Server)
> > > http://vyaskn.tripod.com/
> > >
> > >
> > > "Mueller-Lynch Thomas" <MuellerLynchThomas@discussions.microsoft.com>
> > wrote
> > > in message news:63A92A40-BF14-4DE6-B43B-30C400266365@microsoft.com...
> > > First of all I have to say THANK YOU to Microsoft for that tool.
> > > It is a great tool for managing SQL databases - we got many many
> > intersting
> > > hints to enhance our SQL servers.
> > >
> > > Using that tool we now got two interesting things:
> > >
> > > On our server we're also hosting the Sharepoint databases of the
> > Sharepoint
> > > Services - a Microsoft product!
> > >
> > > When scanning the server with BPA the most reported databases were the
> > > Sharepoint databases! I gave this information to Mike Fitzmaurice of
the
> > > Sharepoint team yet!
> > >
> > > But we have an own problem too! Maybe someone can help:
> > > We had (don't know why!) some tables an stored procedures in our
master
> > > database - BPA told us this!
> > > Then we dropped these objects because we don't need them.
> > > Now BPA tells us that 2 user objects remained in the master database:
> > >
> > > Scan Details
> > > ....
> > > Object Name Object Type Object Type Description
> > > pk_dtproperties PK PRIMARY KEY constraint
> > > DF__dtpropert__versi__4A0EDAD1 D Default or DEFAULT constraint
> > > ....
> > >
> > > How can we get rid of these objects?
> > >
> > > Many thanks in advance
> > >
> > > Thomas
> > >
> > >
> > >
> >
> >
> >
>
>
>

Relevant Pages

  • Re: A real world example
    ... If a constraint is defined in terms of successive states of a database, ... Yes, that's all facts are, though constraints mean that your facts are ... value of a candidate key determines the values of all other attributes, ... The frame of reference for a candidate key is a ...
    (comp.databases.theory)
  • Re: A real world example
    ... If a constraint is defined in terms of successive states of a database, ... facts cannot be thought of just in terms of instances of predicates. ... Yes, that's all facts are, though constraints mean that your facts are ...
    (comp.databases.theory)
  • Re: A real world example
    ... If a constraint is defined in terms of successive states of a database, ... Yes, that's all facts are, though constraints mean that your facts are ... model already allows surrogate keys. ...
    (comp.databases.theory)
  • Re: A real world example
    ... If a constraint is defined in terms of successive states of a database, ... facts cannot be thought of just in terms of instances of predicates. ... Yes, that's all facts are, though constraints mean that your facts are ... referencing all of the attribute values, nor, given only the key value, ...
    (comp.databases.theory)
  • Re: Declarative constraints in practical terms
    ... It is a portion of one or more software applications, ... The definition of a database should be all that is required to ... Constraints are an integral ... declarative constraints: SQL declarations enforced by a DBMS engine ...
    (comp.databases.theory)