August 23, 2005 at 8:13 am
Is there anyway we could find out if any databse objects has been created or modified currently . crdate column on sysobjecst do give us the date when objects is created/modified/compiled but what if someone changes a st.proc from EM. does that record a date and time somewhere? any help will be greatly appreciated.
TIA
August 23, 2005 at 9:45 am
to My knowledge, sql does not maintain record of objects being changed.
you would need to use some third party application to monitor changes.
August 24, 2005 at 2:49 am
try source control - have all development come from source control - and use a tool that supplies the link between source control and deploying changes - DB Ghost http://www.dbghost.com
regards,
Mark Baekdal
+44 (0)141 416 1490
+44 (0)208 241 1762
Build, Comparison and Synchronization from Source Control = Database change management for SQL Server
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply