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 |
|
prettyjenny
Yak Posting Veteran
57 Posts |
 Posted - 2005-03-28 : 11:23:07
|
| Hello,When I go to Enterprise Manager to view my tables and views, I only see the Create Date. How can I view the Modified Date?Is there any way that I can view modified date of my tables and views?Thanks,Jenny.There is no stupid question.www.single123.com |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-28 : 12:36:28
|
| There isn't one.And Enterprise Manager usually creates a new table, moves the data, drops the old, then renames the object...Alter is the only true to have updates to tables...but there's a reason that they built EM to do it that way.nr (Nigel) had a good discussion about the internals and how an ALTER can be very wasteful of space.Brett8-) |
 |
|
|
|
|
|
DATE MODIFIED help please