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 |
mohan123
Constraint Violating Yak Guru
252 Posts |
Posted - 2013-09-04 : 01:40:41
|
if we want to get the changes happened in database we will get through sys.objects or sys.tables .but we are only getting it table name . But how to get by table name and what the column added to that table or what column has been modified (datatype or constraint) . for example if i added employee table column called deptid it should be shown in changes in geiven date SELECT modify_date ,type_desc ,name FROM sys.objects WHERE is_ms_shipped=0 --AND modify_date>='yyyy/mm/dd' <--optionally put in your date here ORDER BY 1 DESC how to get column name of a table which is modifiedP.V.P.MOhan |
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2013-09-04 : 08:46:11
|
in SSMS Reports -> Standard Reports -> Schema Changes Historymohammad.javeed.ahmed@gmail.com |
|
|
|
|
|