CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. August 27th, 2001, 02:38 AM #1
    chris mandl
    chris mandl is offline Member
    Join Date
    Mar 2000
    Location
    graz
    Posts
    26

    SQL Server Status (WindowsNT)

    How can I get the status of SQL Server (MSQLServer) with Visual Basic as easy as possible under WindowsNT V4.0 Sp xx? I don't like to use the NTService control!

    chris
    Reply With Quote Reply With Quote
  2. August 27th, 2001, 03:48 AM #2
    Cakkie's Avatar
    Cakkie
    Cakkie is offline Elite Member
    Join Date
    Jan 2000
    Location
    Olen, Belgium
    Posts
    2,477

    Re: SQL Server Status (WindowsNT)

    I don't have any code on this, cause I haven't installed it on this PC, but I know that it can be done using SQLDMO, the object model of SQL server. This is also used by enterprise manager and all the other tools that come with SQL server. try looking at MSDN, you might find some examples there.

    Tom Cannaerts
    [email protected]

    Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook
    Tom Cannaerts
    email: [email protected]
    www.tom.be (dutch site)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured