Jump to content

Recommended Posts

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
Posted

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

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...