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 |
|
chetan9
Starting Member
3 Posts |
 Posted - 2009-09-08 : 02:03:15
|
| Hi all, Please let me know if there is any utility available to track the schema chenges in a SQL Server database.Regars,Phani Kumar PV |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-09-08 : 04:07:49
|
| using ddl trigger is best option to track schema changeshttp://connectsql.blogspot.com/2009/07/create-ddl-changes-log.html |
 |
|
|
chetan9
Starting Member
3 Posts |
Posted - 2009-09-08 : 06:38:30
|
quote:
Originally posted by lionofdezert
using ddl trigger is best option to track schema changeshttp://connectsql.blogspot.com/2009/07/create-ddl-changes-log.html
Hi lionofdezert, Thanks for the solution. Sorry for not stating my problem completely. I had one more problem, i dont have the permission to edit the database.In that case the solution given willl not work for me..Please let me know if you have any other solution apart from changing the database for this issue.Regards,Phani Kumar PV |
|
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2009-09-09 : 01:50:47
|
quote:
Originally posted by chetan9
quote:
Originally posted by lionofdezert
using ddl trigger is best option to track schema changeshttp://connectsql.blogspot.com/2009/07/create-ddl-changes-log.html
Hi lionofdezert, Thanks for the solution. Sorry for not stating my problem completely. I had one more problem, i dont have the permission to edit the database.In that case the solution given willl not work for me..Please let me know if you have any other solution apart from changing the database for this issue.Regards,Phani Kumar PV
The Schema changes history report can be useful..right click on database node->reports->standardreports->schemachangeshistory |
|
|
|
|
|
|
Utility to Track SQL server database changes