Re: Report of the Best Practice Analyser

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

Date: Wed, 18 Aug 2004 11:45:13 +0100

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: SQL Server 2005 Resource Database
    ... from trying to separate the resource and master files. ... the SQL Server 2005 topic will be updated in the next scheduled release ... In 2008 the requirement for the Resource and Master database to remain ...
    (microsoft.public.sqlserver.setup)
  • Re: Timing out????
    ... Vyas, MVP ... Is .NET important for a database professional? ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.programming)
  • Re: Cluster will not fail over.
    ... Could not recover the master database! ... If you intend to stay on SP3 (for SQL Server), you should at least apply the ... >> From SQL server logs ...
    (microsoft.public.sqlserver.clustering)
  • Re: Server migration plan
    ... internal host name the master database you restored thinks it still is. ... Restoring a .mdf http://www.support.microsoft.com/?id=307775 Disaster Recovery Articles for SQL Server ... > 1) Restore master database, ...
    (microsoft.public.sqlserver.server)
  • Re: Report of the Best Practice Analyser
    ... I asked you if you have a dt_properties table in your master database? ... Vyas, MVP ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.tools)