Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Eric Russell,
There are occasions, such as following a deployment or while troubleshooting an unexpected issue, when it's useful to return a list of any objects recently modified. By default this script will query across all databases and return any objects created or modified in the past 24 hours. However, you can also provide an alternate value for @db_name_phrase or @modify_date to narrow the search.
Last Modified Date
Modify Check constraint
Modify columns' name in batches.
Information about modifying table while Merge Replication
Modifying the index