Thanks for second query but it also won't show the open transaction as I explained in my previous post.

Thanks for respons Gail but this query won't retun the open transation statement. e.g.

Suppose I runthis query:

begin tran

update employee set is_active=1

Nowit is an open transaction since it i not...

Hi All

I finally was able to do it this way:

declare @sortOrder int

SET @sortOrder=2

;With MyCte as

(SELECT CASE WHEN @sortOrder=1 THEN Row_Number() Over(Order By Capid)

WHEN @sortOrder=2 THEN Row_Number()...

I checke but couldn't find all options described at once place. Will be great if you have some link for that.

This should be no problem. I have both on my laptop and they work fine.

All u need is required resources so that your system dont die in want of resources....

Thanks for reply. I actually meant transaction only.I knew that only transaction can be open. I was just querious why didn't microsoft add a sql _handle in sys.dm_tran_active_transactions . this...

Hi Bhuvenesh

the inputBuffer gives just the last transaction for that spid. As i metioned, If I ran another statement in same sesin, where I opened transaction, then it will give...

This is really good Jonathan...thanks so much....

yeah, I was expecting tha it wont be direct. Can yo pls explain:

"XQuery against the queries in cache to see which have accessed a given index"

If try sys.sycacheObjects or...

You may want to check this out:

http://technet.microsoft.com/en-us/library/ms175905.aspx

Aybody know of any free utility to decrypt in sq server 2005..

Thanks Steve for clarifiction on using 'the same'. I otenused it 🙂

will try to avoid it now

Abhisek

What I meant was, if you run te code from the link shared by Steve on SQL 2005, i doesn'twork there.

It just deleted the proc. And then if you run...

As itold , it deetes the proc. So if u run sp_hlptext, this is wt u will get:

Msg 15009, Level 16, State 1, Procedure sp_helptext, Line 54

The object 'EProc' does...

Yup, this code is not working for atleast SQL Server 2005. instead it delets the proc which you try to decrypt...

So be careful while using it...

Thanks, this was a new learning for me...