Database schema change of result in query sql server

Kanav Sharma 25

How we can get database schema change result in query sql server? Is there any tool ? Suppose we do any change in schema. I want the result of that change in query.

1 answer

PercyTang-MSFT 12,501 Reputation points Microsoft Vendor

2023-11-20T06:47:31.6666667+00:00

Hi @Kanav Sharma

You can use the Schema Changes History report available in SQL Server Management Studio.

To access this report, right click the database then from the context menu choose Reports -> Standard Reports -> Schema Changes History.

You can refer to the previous thread.

https://learn.microsoft.com/en-us/answers/questions/1104823/can-we-get-the-table-schema-changes-from-sql-serve

Best regards,

Percy Tang
Please sign in to rate this answer.
Marie Phillips 0 Reputation points

2024-12-05T17:12:39.58+00:00

Hi Percy, how can I extend the period of this log, it only shows the last few days for me. Is there a way to set a start date and retain the log for all schema changes after that date?

Erland Sommarskog 113.5K Reputation points MVP

2024-12-05T22:05:46.39+00:00

I believe that report reads from the default trace. Possibly, you could change how many rollover files and/or the size of the files, but I am not sure it is a good idea. That trace collects quite more information.

It's better to set up separate audit for DDL changes, for instance with SQL Server Audit.

If you have followup questions, please do not them here, but ask a new Question, describing your problem from start to end.

Marie Phillips 0 Reputation points

2024-12-06T18:03:35.93+00:00

ok, thank you for your timely response! Much appreciated!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Database schema change of result in query sql server

1 answer

Your answer