Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Find out when a diagram was last updated

Author  Topic 

asdftwice
Starting Member

1 Post

Posted - 2002-06-19 : 10:48:31
Hello, is there a way to find out when I DB diagram was last updated? I noticed that there is no modified date when looking at the DB diagrams through ent. manager. I'm assuming that this information can be accessed through some system table or informative stored procedure.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-06-19 : 11:00:14
The diagram info is stored in the dtproperties table, but it's all binary data. There's no single column with a modified date, and there's little chance you can decode that data to find the modified date (if it's even stored in there)

Go to Top of Page
   

- Advertisement -