How to know which sql login are been used or not by the users....

  • HI all,

    how can i know about unused login in sql server 2005 ???

    example-

    A login is xxx it was been created 22-01-2013 and i want to know that when was this login last used ??

    thanks

    Ivan

  • the mentor of this blogs please help:-)

  • You could set up a server-side trace and monitor usage for a while. I don't think there's a way to get historical data if you haven't already started auditing it.

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

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