To Find the login history - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

To Find the login history

Author

Topic

linganagouda
Starting Member

5 Posts

Posted - 2012-03-25 : 06:39:15

Hi,

I want to get the last login history,I mean SOMEONE is deleted one row from table,We have recoverd that but we want find the who is deleted that row.

Please can any one suggest me.How to track this?

Platform:windows 32 bit
DB:MS SQL SERVER 2000

I can really appreciate who will answer for this.

Lingan G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-25 : 13:44:43

You'll need a third party tool (not free) plus the transaction log backup that contains the event.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

linganagouda
Starting Member

5 Posts

Posted - 2012-03-26 : 10:37:43

Hi,

Thanks for your update,

I have trasaction logs backup.How to find the login history of particular user,Is there any Default table to save the login history,

If u have any query to pocess the issue ,Please let me know

quote:
Originally posted by tkizer

You'll need a third party tool (not free) plus the transaction log backup that contains the event.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Lingan G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-26 : 12:34:03

Did you purchase a third party tool to read the backups?

There is no query to run here. You are out of luck.

You really need to upgrade to at least SQL Server 2008 R2 where you could at least implement change tracking and have DMV's with more historical information.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

X002548
Not Just a Number

15586 Posts

Posted - 2012-03-26 : 12:49:13

Or..you could write your own triggers and have a history table for each table

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

linganagouda
Starting Member

5 Posts

Posted - 2012-03-26 : 15:03:46

Hi,

We did not have third party tool to take backup,i just schedule daily full backup and trasaction logs into disk.

my application owner has asked me to give login history details which was deleted by one user...ok

I have trasction log backup,is it possble to get login history details from trasaction logs

please help me ..i am oracle dba i have to take care the sql server database also here.

[
quote]Originally posted by X002548

Or..you could write your own triggers and have a history table for each table

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

[/quote]

Lingan G

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-26 : 15:16:21

You missed my point. I am not referring to purchasing a third party backup tool. I'm referring to purchasing a third party backup reader. Try ApexSQL for instance.

The triggers that Brett mentioned are for you to implement to catch future occurrences like this. It does not help you solve the current problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

linganagouda
Starting Member

5 Posts

Posted - 2012-03-27 : 14:51:35

Hi,
Thanks for your quick replay

quote:
Originally posted by linganagouda

quote:
Originally posted by tkizer

You missed my point. I am not referring to purchasing a third party backup tool. I'm referring to purchasing a third party backup reader. Try ApexSQL for instance.

The triggers that Brett mentioned are for you to implement to catch future occurrences like this. It does not help you solve the current problem.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Lingan G

Lingan G

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources