Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

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)

Query all objects created or modified after specified date

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.

Total article views: 1569 | Views in the last 30 days: 1
 
Related Articles
FORUM

Last Modified

Last Modified Date

FORUM

Modify Check constraint

Modify Check constraint

SCRIPT

Modify columns' name in batches

Modify columns' name in batches.

FORUM

Modify table - Merge Replication

Information about modifying table while Merge Replication

FORUM
Tags
deployment    
modified    
objects    
search    
troubleshooting    
 
Contribute