Post reply

what is the use of dbo.dtproperties, can this be deleted?

  • December 10, 2012 at 2:14 am

    #285923

    Hello,

    One of our customer is running a desktop utility that compares DB structure to the strucuture included in the application. When the customer performs a schema validation of application database it comes back with a lot of extra procedures all stemming back to the table dbo.dtproperties.

    I did some initial research and the table comes back empty, as well as online (google) it appears that maybe this table was used in SQL 2000...but maybe not used any more?

    [refer to this link for info: http://social.msdn.microsoft.com/Forums/eu/vstsdb/thread/21c5fad2-b8a7-417f-8596-ccd2cebd0b1b%5D

    I'd like to determine what this table is used for, if it is necessary to keep it in SQL 2008, and if not can we drop it ?

    Thanks

    Asir

  • December 10, 2012 at 2:20 am

    #1566935

    It's created when someone creates a database diagram

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2012 at 3:29 am

    #1566954

    We donot maintain any DB diagram on the SQL 2008 Instance, modelling in done on a seprate tool.

    Wanted to know if this table can be deleted & will impact any other process?

    I bet this is appearing from sql 2000 & we no more use SQL Server to create diagrams.

    Thanks

    Asir

  • December 10, 2012 at 3:54 am

    #1566961

    asir83 (12/10/2012)

    Wanted to know if this table can be deleted & will impact any other process?

    Is it hampering your work ? i dont think aur i will frame it in another way . So you have any valid reason to wipe out this table ? u wont have i guess

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • December 10, 2012 at 4:14 am

    #1566967

    asir83 (12/10/2012)

    Wanted to know if this table can be deleted & will impact any other process?

    If you delete it then anyone who's created a database diagram (from SSMS) will lose it. If anyone tries to create a DB diagram, the table will recreate it.

    Best just to ignore it in your comparison tools. Surely there's an 'ignore' list?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2012 at 6:28 am

    #1567002

    Thanks for all your inputs.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply