Post reply

Logged into a SQL Server and not active state

  • October 7, 2012 at 2:09 am

    #265411

    Hi I need a little help in creating an email alert to my Team mentioning the list not active persons(Disconnected) on the server. I could see a lot of people logging into the server and when they are done, they never log off. They disconnect from the server.

    1) How to send an email listing out the names of people that are logged in?

    2) What are the disadvantages of people not logging off from the server.

  • October 7, 2012 at 3:27 am

    #1546481

    As in remote desktop connections or sleeping SQL connections?

    How many are you talking about?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • October 7, 2012 at 7:53 pm

    #1546537

    Well Technically not more than 2 people can be active on our boxes. But I see 2 in active and atleast 5-6 disconnected.

    1) What are the disadvantages if a person does not log out off the server.

    2) How send an email to my team listing the disconnected aliases on the box.

  • October 7, 2012 at 7:54 pm

    #1546538

    Oh forgot to answer your first question. I was curious only about remote desktop connections

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply