Last Transaaction sql server 2000

Question

Last Transaaction sql server 2000

SQL Galaxy

One Orange Chip

Points: 29472
More actions
December 10, 2008 at 11:09 pm

#75384

Hi Friends.
I need Urgent help.
Please give me query, How to identified last transaction in sql server2000?
Thanks for advance.
ananda

Viewing 6 posts - 1 through 5 (of 5 total)

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I'm not sure I understand you. How do you want to 'identify' a transaction? By last, the one that began most recently, ended most recently, something else?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 2

Thanks Gail for reply,

I need the transaction by the last result with date.

thanks

ananda

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

Hi,

Urgent Help.

I need the query for by the last transaction and access database with date.

thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

I'm still not understanding what you want.

The most recent query?

The most recent data change?

Something else?

Best bet to get any of that is to have a profiler trace running for any of that information.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 5

hi,

Thanks for reply.

The most recent query?

The most recent data change?

Something else?

I want the most recent query?

Very usefull for me,If you give me all three query.

thanks