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

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » what is the use of dbo.dtproperties, can this...

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

Rate Topic

Display Mode

Topic Options

Author

Message

asir83

Posted Monday, December 10, 2012 2:14 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:02 AM
Points: 21, Visits: 167

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]

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

Post #1394492

GilaMonster

Posted Monday, December 10, 2012 2:20 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

It's created when someone creates a database diagram

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #1394496

asir83

Posted Monday, December 10, 2012 3:29 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:02 AM
Points: 21, Visits: 167

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

Post #1394518

Bhuvnesh

Posted Monday, December 10, 2012 3:54 AM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1394526

GilaMonster

Posted Monday, December 10, 2012 4:14 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 3:07 PM
Points: 37,687, Visits: 29,946

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 2008, MVP
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

Post #1394534

asir83

Posted Monday, December 10, 2012 6:28 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:02 AM
Points: 21, Visits: 167

Thanks for all your inputs.

Post #1394575

« Prev Topic | Next Topic »

Permissions