This is when you need to focus on automation tools like Windows PowerShell. To query any SQL database from PowerShell, you need to have the SQLPS module installed along with a few supporting packages.

SQL Advisor PowerShell vs. SQL Server Management Studio While PowerShell doesn't duplicate the complete functionality of SSMS, it can duplicate a lot of it. By David Ramel 06/24/2011 When I (along ...