Is there an equivalent of ping for checking connectivity to SQL Server? -

Is there an equivalent of ping for checking connectivity to SQL Server? -

is there equivalent of ping checking connectivity sql server?

i'm finding our biztalk admin console during long operations, e.g. importing big bindings file, "connection" beingness lost, i.e. reddish box appears on console. connectivity comes back. sql server on different machine biztalk.

also saw issue connection sso db lost min or ... worse, production environment!

sql dba has checked , sql fine, showing no network issues ...

i can ping -t see if happens connection between 2 machines, there equivalent function check ongoing connectivity sql server itself?

and if there such function, there someway automate checking can have flag occurance of disconnect ... sending email ops first step

you can utilize powershell

add-pssnapin sqlservercmdletsnapin100 add-pssnapin sqlserverprovidersnapin100 $query = "select top 1* bts_application" invoke-sqlcmd -query $query -serverinstance '.' -database 'biztalkmgmtdb'

sql-server sql-server-2008-r2 biztalk biztalk-2010