yes saby i m gettin blocking in the tempdb.

Grant there are procedure with begin and tran

E.g

proc ssa

(

Begin tran

exec procedure1

-----create some temp table and do some...

waiting for the reply...Jeff can u help in this process

no not using global temp tables ...

yes but wat i m staying here is

there is a procedure in which there are around 30 more procedure which are getting called

Eg create procedure abcdef

(

begin

exec ab ---doing some...

Hi Lynn i have started a new thread for this but there is no reply

Waiting for the Reply

Not found as there is no trigger in any database

This Experts gets up in the morning and says let see wat new in the sqlserver

and we get up in the morning wats new thing we can learn from them.

Sqlwars try to become as good as gail ,lynn ,jeff and other experts my aim is to become like one of them.....

Hi Gail and other experts

How does "ROWLOCK" work? I have this situation:

User1 - Query Analyzer

begin transaction

update t1 with (rowlock) set c1 = 10 where c1 = 5

User 2 - Query...

Hi Grant Fritchey,

I have read little from ur book.

with respect

I think if u give more information about the profiler how to use it in your book will be more appreciated.

By...

Go to run type perfmon there u will get all this counters

Hi if i add IID order by column there wil be an index seek but i dnt want to do that.

Dave the proc cant be muched changed due to some activities and the procs has been written by some other dev and i have to tune as no one knows...

Dave this cursor is taking time can i use fast forword only option in this cursor...