Jump to content
Pulseway 9.14 🔥

Featured Replies

Posted

I would love to be able to send a query to my MS SQL server and compare the contents of what is returned. This would test that the server is working properly. Another test would be to test that I can login properly as SA or another user.

Thanks.

Randy

  • Administrators

In the mean time you can execute queries from premade batch files to see if everything is alright using sqlcmd.


@echo off

sqlcmd -d AdventureWorks2008R2 -q "SELECT FirstName, LastName FROM Person.Person WHERE LastName LIKE 'Whi%';"

You can write this in a batch file and you can call it from terminal on a mobile device.

  • 3 months later...

Create an account or sign in to comment