Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Last database access Expand / Collapse
Author
Message
Posted Tuesday, February 9, 2010 6:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 4:30 AM
Points: 5, Visits: 159
Hi All,

There has been new assingment that has come up by the client to find the list of the database that was last accessed in sql server 2000.
As far as I know there is NO way to find this out, apart from just verifying through windows explorer. THe last modified date option.

have any one has a solution on this..

Help will Appreciated...
Thanks in advance...

Regards
Paritosh...
Post #862385
Posted Tuesday, February 9, 2010 7:20 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
By last accessed do you mean last modified or just reading it?


Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #862417
Posted Tuesday, February 9, 2010 7:58 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 5:03 AM
Points: 6,748, Visits: 8,544
If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.
This way, you will find a "database opened" message in your sqlserver errorlog file


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #862450
Posted Tuesday, February 9, 2010 8:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, February 11, 2013 8:27 AM
Points: 1,646, Visits: 1,947
ALZDBA (2/9/2010)
If this is to figure out if a db is still being used, just alter your db option "AUTO_CLOSE" to ON.
This way, you will find a "database opened" message in your sqlserver errorlog file


I would be better looking at the active sessions through Activity Monitor rather than setting that option. Since it would have an impact on the Performance..



Bru Medishetty

Blog -- LearnSQLWithBru

Join on Facebook Page Facebook.com\LearnSQLWithBru

Twitter -- BruMedishetty
Post #862457
Posted Tuesday, February 9, 2010 12:11 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, December 16, 2014 5:03 AM
Points: 6,748, Visits: 8,544
If they doubt it the db is still in use ??? So far for performance

Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #862654
Posted Wednesday, February 10, 2010 7:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, February 19, 2014 4:30 AM
Points: 5, Visits: 159
we want to find when was this database was last used or modified.
Post #863201
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse