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 |
|
svicky9
Posting Yak Master
232 Posts |
 Posted - 2007-09-05 : 10:56:59
|
| Hi Friends I want to know the datecreated for a column in a table. How do i query it?I found crdate in sysobjects but columns not objectsNo entry in syscolumns eitherthanks in advanceVic |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-05 : 11:17:43
|
I don't believe there is any way to pull this information except maybe creating custom metadeta with SSIS.
Future guru in the making. |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-09-05 : 11:18:48
|
| I don't think you can.You can use auditing triggers on system tables in SQL 2005, so you could "log" changes to the table etc. and deduce it from that.You could possibly use a 3rd party log reader, from am company such as Lumicent(sp?)We script all database changes, in sequentially numbered scripts (so that we can repeat the changes on TEST, QA, BETA, STAGING and PRODUCTION databases), and store the scripts in a version control system.Thus for me, given that environment, I could just review the scripts to find out when a specific change to a table had been made.Kristen |
|
|
|
|
|
|
Column Creation Date