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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Last Accessed

Status
Not open for further replies.
qsac

qsac

Programmer
Jan 22, 2002
242
US
Does anyone know a way to tell a last time a Database was accessed?

Thanks
Q
 
Sort by date Sort by votes
You would need to be running SQL Profiler somewhere in order to get that information.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tnguyen315
  • Locked
  • Question
When was my SQL Server Databases last accessed/used?
Replies
1
Views
82
TheBugSlayer
TheBugSlayer
dexterdg
  • Locked
  • Question
SQL SERVER: Query to get the last instance of an ID but return the first instance of that ID
Replies
2
Views
104
dexterdg
dexterdg
vpn2012
  • Locked
  • Question
take last updated data in file
Replies
1
Views
20
djj55
djj55
vpn2012
  • Locked
  • Question
take last databackup(data only)in small size
Replies
0
Views
36
vpn2012
vpn2012
vpn2012
  • Locked
  • Question
take last updated data from one database then put in another
Replies
0
Views
11
vpn2012
vpn2012

Part and Inventory Search

Sponsor

Back
Top