Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78

    Unanswered: See if a login has been used

    I have a login on my SQL Server which I think is old and not used any more but can't be 100% sure. I want to delete it as I think it's redundant, but is there any way I can check if it has been used at all or recently?

    Thanks.

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    First thought is a low level Profiler trace to capture Machine name if that login is used.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    Dec 2002
    Posts
    1,245
    Quote Originally Posted by tomh53
    First thought is a low level Profiler trace to capture Machine name if that login is used.
    What version of SQL are you using? If it's 2005, there are some things you can do with login triggers...

    Regards,

    hmscott
    Have you hugged your backup today?

  4. #4
    Join Date
    Feb 2004
    Location
    Burbank & Santa Cruz de la Sierra
    Posts
    3,716
    When I am faced with such quandries, I usually tighten down (aka "eliminate") all the permissions for the logon and see if anyone squeals.

    I love doing Research By Squeal.
    aka "Paul"
    Non est ei similis.

    I just read "100 Things To Do Before You Die". I was surprised that "Yell for help!!" wasn't one of them

  5. #5
    Join Date
    Sep 2003
    Location
    Hertfordshire, England
    Posts
    78
    Im using 2000. I will try the remove permissions thing and see if anyone squeels

Posting Permissions

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