Post reply

security question

  • May 26, 2009 at 2:36 am

    #130739

    Here my department is sql department.other than sqldepartment members are open the data of sqldepartment with the help of ip address or servername.so i need to know who are login the my server and which database they are connected?for that where can i seed the details about that?

    Thanks

    Kiran

  • May 26, 2009 at 5:37 am

    #999827

    sp_who2..........

    [font="Comic Sans MS"]+++BLADE+++[/font]:cool:

  • May 26, 2009 at 6:53 am

    #999863

    you can also use "Activity monitor" from SSMS

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

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

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