Post reply

how to find the login which is running more than 2 days in sql server

  • November 23, 2014 at 8:07 pm

    #397677

    Hi all,

    How to find the login which is running more than 2 days in sql server

    I mean we need to intimate the users[logins ] who have been running there sessions more than 1 or 2 days to close there sessions or re connect for that we want to find those logins

    can any one please send the script or procedure for that=...

    Thanks

    Naga.RohitKumar

    Thanks
    Naga.Rohitkumar

  • November 23, 2014 at 10:09 pm

    #1760397

    You can you the old master.dbo.sysprocesses or the newer dmv

    sys.dm_exec_sessions

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

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