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 |
|
Dennis Falls
Starting Member
41 Posts |
 Posted - 2007-11-13 : 10:08:08
|
| I'm trying to figure out why the Create date for one of my tables, as displayed in enterprise manager, has recently changed. Is there something that will modify this date other than actually creating a table? I've been very careful to always uncheck Include all dependent objects whenever I copy objects, so I don't believe I have copied it over from another db. Plus, the data in the table seems to be correct.I have made some modifications to the indexes on that particular table, but that shouldn't change the create date should it? |
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-13 : 10:13:20
|
| Have you changed any thing on the table its self, and this will do a drop recreate. |
 |
|
|
Dennis Falls
Starting Member
41 Posts |
Posted - 2007-11-13 : 10:28:38
|
| Brilliant. That's it. I did increase one of the field sizes. Thanks |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 05:21:23
|
| No problem, its worth remembering that doing a modify will in fact drop the table and then recrate it. |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-11-14 : 07:59:13
|
only via Enterprise Manager. sysobjecs.crdate will not change if you use the "alter table" command
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
dirtydavey
Yak Posting Veteran
80 Posts |
Posted - 2007-11-14 : 08:51:52
|
| Yep, sorry should have made that clear, thanks khtan. |
|
|
|
|
|
|
Create Date