SQLSquirrel
Technical User
Can someone suggest and/or supply a quick and efficient generic solution to identifying the most recent access (date/time/logon id) on a SQLServer (7.0 and/or 2000) database? (excluding the id used by the SQLAgent)?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Identifying last database access
- Thread starter SQLSquirrel
- Start date
- Status
mrdenny
Programmer
- May 27, 2002
- 11,595
If you monitor the database with SQL Profiler you can see who is accessing your database in real time. SQL Does not track historically who is logged into the database.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
