Hello all

I've been trying to write a script that will check mssqlserver status. I can do it from the command line using netsvc but I having trouble placing it in VB or ASP so I can capture the output text. If anybody knows of any solutions, I'm open

Thanks
EM

Take a look at the Windows Scripting Host objects, in particular the WScript.Shell object and its Exec method. When you use the Exec method to run a program, it returns a WshScriptExec object which provides access to stdout, which you can use to capture the netsvc output.

You need to set a ref to 'Windows Script Host Object Model' in your VB project.

hth
Phil

As an alternative to screen scraping the output of a command line utility to get the information you are looking for, you might also want to take a look at SQL-DMO (data management objects). This is a set of objects that comes with SQL Server that you can use to inspect (and modify) just about any operational aspect of a SQL Server instance.

See BOL index for SQL-DMO.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Jeff

Thanks for the DMO info. I will look into it and see if I can use it. Originally I tried to call netsvc from the xp_cmdshell which worked fine for local server but was giving a access violation on remote servers. The problem had to do with authentication for SQL server.