SQL Server Performance Forum – Threads Archive

How to check creation date for a column

Hi, i wanna check the columns added to a table on a certain date.
SYSOBJECTS have crdate, but how to find the creation date for new columns into a table. Howdy ——————————————————————-
A DBA seems to work only when the users can’t, so i scarcely work!

There is no way to know this until you run Profiler and save the informations at that time
Otherwise you need to maintain a document that records the changes you are doing Madhivanan Failing to plan is Planning to fail

quote:Originally posted by thebeginner Hi, i wanna check the columns added to a table on a certain date.
SYSOBJECTS have crdate, but how to find the creation date for new columns into a table.

There is no native support for that in SQL Server. You can use third party tools for source control —————————————-
http://spaces.msn.com/members/dineshasanka

Hi, it will not show you creation / modification date of any modification in any object by any user , please refer below threads FYI: <a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2508′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2508′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2508>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=2508</a></a> <a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8322′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8322′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8322>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8322</a></a> <a href=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9736′ target=’_blank’ title=’http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9736′<a target="_blank" href=http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9736>http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=9736</a></a> [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Regards Hemantgiri S. Goswami ghema[email protected] "Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami

]]>