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.
| Author |
Topic |
|
avmreddy17
Posting Yak Master
180 Posts |
 Posted - 2008-02-21 : 21:55:30
|
| Is there a way to see the last modified date on the Table structure or a stored Procedure in SQL Server 2000?Thx |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-02-21 : 22:10:14
|
| No, you need kind of auditing tool. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-02-21 : 23:00:42
|
| Or you need to have audit log table on your table which defaults to GETDATE() and take MAX() of this to see when table was last modified. The audit table will be populated by a DDL trigger which checks for changes in table structure. |
|
|
|
|
|
|
Modified date