find who accessed

Question

Post reply

find who accessed

sqlpro

Hall of Fame

Points: 3859
More actions
December 29, 2003 at 5:24 pm

#83275

Hi friends
Is there any way what object was lasttime accessed by a particular user.
for example i've a stored proc (i.e pt_worktime) and i want 2 know when it was executed lasttime by a particular user(say user sa).
is there any system procedure/function to get that info.
Thank you very much 🙂

Viewing 13 posts - 1 through 12 (of 12 total)

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

noeld SSC Guru Points: 96590 More actions · Answer 1

you can code that in the procedure!

otherwise --> Profiler or third party tools

* Noel

sqlpro Hall of Fame Points: 3859 More actions · Answer 2

thanks for that.

so you r saying there is no system table/proc to query, right?

now i cannot modify my procedure bcoz its constantly being used.

let me know if there is any other way otherthan 3rd party tools.

thank you very much.

cheers

jxflagg Hall of Fame Points: 3817 More actions · Answer 3

quote:
so you r saying there is no system table/proc to query, right?

Noeld is correct. Profiler is the only way to do this without recoding or using third party tools.

sqlpro Hall of Fame Points: 3859 More actions · Answer 4

thanks for ur reply.

yes u r right abt profiler.but we had a problem with a user .he says he did not login yesterday at all.

i want to findout when he lasttime logged in.

cheers

jxflagg Hall of Fame Points: 3817 More actions · Answer 5

quote:
yes u r right abt profiler.but we had a problem with a user .he says he did not login yesterday at all.
i want to findout when he lasttime logged in.

Unfortunately, if you don't audit logins, we're back to the third party solutions.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 6

Other than Profiler, is your SQL Server configured to audit successful logins? If so, the info is in the application log of the server of who logged on to the system and when they did so.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

sqlpro Hall of Fame Points: 3859 More actions · Answer 7

thanks friends

how do i know SQL Server is configured to audit successful logins?

if so how can i read application log.

thanks for ur help

sqlpro Hall of Fame Points: 3859 More actions · Answer 8

hi brian

i checked my server properties unde security tab but unfortunately the audit level is none.

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 9

If he used a SQL Server login, then unfortunately you'll not be able to verify if he logged in or not. If he used Windows authentication and logging is on at the OS level you might have something in the Security event log.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

sqlpro Hall of Fame Points: 3859 More actions · Answer 10

sorry Brian it's sql server login.

anyway i changed our server audit level to success.seems like i need 2 restart our server.i'll restart our server when there r no logged in users.

thanks for ur time.

cheers

K. Brian Kelley SSC Guru Points: 114642 More actions · Answer 11

Yes, the restart is required.

K. Brian Kelley, GSEC

http://www.truthsolutions.com/

Author: Start to Finish Guide to SQL Server Performance Monitoring

http://www.netimpress.com/

K. Brian Kelley
@kbriankelley

sqlpro Hall of Fame Points: 3859 More actions · Answer 12

Hi brian

if i can ask another question on replication.

we have an application in our office MSDE8 as backend and visual foxpro as frontend.now

we want to enable replication.i mean users can take our application on their laptop and do some changes to data in offline mode.when they relogin to our main database server we need to update latest data from laptop.

its a new concept for me

i wonder if u could suggest any article or some sort which get me some idea on this issue.

my initial idea is to install MSDE on every laptop that'll b going offline and copy data from main server to these offline databases.

once they relogin to main server then i need to write a program that transfers newly added data /modified data to main database server.

am i going right way?

thank you so much for ur suggestion.