How to find schema changes report in SQL Server ?
Select o.name As [Objcet_Name],
Select o.name As [Objcet_Name],
s.name [Schema_Name],
o.type_desc [Description],
o.create_date [Creation_Date],
o.modify_date [Modified_Date]
from sys.all_objects o
Left outer join sys.schemas s
on o.schema_id=s.schema_id
where create_date >(GETDATE()-7) or modify_date >(GETDATE()-7)
Or
We can check SSMS Wizard .
Step 1:- Select Database
Step 2:-click right mouse button and Select Report.
Step 3:- Select Standard
Step 4: finally Select Schema change History .
No comments:
Post a Comment