SQLServerCentral » Latest topics
latest timestamp multiple databases
Hi dbas
can you tell me a quick way to check timestamp on multiple user databases in a SQL Server Instance.
For Ex:
select db_name(), max(doj) as latest_dATE from tablename
need this looped across 70 databases
can you tell me a quick way to check timestamp on multiple user databases in a SQL Server Instance.
For Ex:
select db_name(), max(doj) as latest_dATE from tablename
need this looped across 70 databases
No comments:
Post a Comment