Surefire Method to Determine that SQL is running programmatically.

[Louis Frolio]

All, if I were to write an app that has one task, determine whether or
not an SQL Instance is running, what would be the easist method for
this? I personally think that a query against the masterdb would do
the trick. I would appreciate any feedback you can provide.

L

[Simon Hayes]

"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94**************************@posting.google.c om...

All, if I were to write an app that has one task, determine whether or
not an SQL Instance is running, what would be the easist method for
this? I personally think that a query against the masterdb would do
the trick. I would appreciate any feedback you can provide.

L

If you want to know if the SQL Server service is running, then you can use
any tool which can tell you the state of a Windows service - WMI is one way,
or the SQLDMO SQLServer2 object has a Status property.

Simon

[Louis Frolio]

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<40********@news.bluewin.ch>...

"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94**************************@posting.google.c om...

All, if I were to write an app that has one task, determine whether or
not an SQL Instance is running, what would be the easist method for
this? I personally think that a query against the masterdb would do
the trick. I would appreciate any feedback you can provide.

L

If you want to know if the SQL Server service is running, then you can use
any tool which can tell you the state of a Windows service - WMI is one way,
or the SQLDMO SQLServer2 object has a Status property.

Simon

Thank You Simon. I had a hunch that SQLDMO was the way to go.

L

[Louis Frolio]

"Simon Hayes" <sq*@hayes.ch> wrote in message news:<40********@news.bluewin.ch>...

"Louis Frolio" <fr*****@yahoo.com> wrote in message
news:94**************************@posting.google.c om...

All, if I were to write an app that has one task, determine whether or
not an SQL Instance is running, what would be the easist method for
this? I personally think that a query against the masterdb would do
the trick. I would appreciate any feedback you can provide.

L

If you want to know if the SQL Server service is running, then you can use
any tool which can tell you the state of a Windows service - WMI is one way,
or the SQLDMO SQLServer2 object has a Status property.

Simon

Thank You Simon. I had a hunch that SQLDMO was the way to go.

L