Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
after that, i write down the results in a sheet and then create the report on excel sheet with database's name. is there a way, i can run the script just one time, not to select different names of databases and generate the report of all the databases at one time.
USE [dBase1] GO Select MAX(DateOfLastUpdate) AS lastUpdate1 from Table1 Select MAX(DateOfLastUpdate) AS lastUpdate2 from Table2 Select MAX(DateOfLastUpdate) as lastUpdate3 from Table3
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Dynamically Construct and Execute a SQL Server Statements||10||50|
|SQL 2012 Report Builder 3.0 query||2||16|
|Complex SQL Server WHERE CLause||9||36|
|SQL Server 2012 to SQL Server 2016||24||51|
Join the community of 500,000 technology professionals and ask your questions.