Hi GilaMonster,

I have attached the explain plan.

I have tuned another query and successfully convert index scan to index seek. But when I have index seek, keyLookup also came ....

this is great Lowell. it was not in my consideration .

I will ask developer.

Andy thank you. this is really great 🙂

thank you opc and Jack.

I am using return code because I will not throw error to client.

My application will hit stored porc and proc will do some processing (will execute...

thank you Ten Centuries

but how ?any TSQl code reference you have ?

Hi ,

I have got it.

Declare @rc int;

Exec @rc=spName;

Print @rc;

If rc is 0, it means success else I will have error code e.g.-6

thank you Gail Shaw

Sean Lange (5/19/2011)

---

I figured that when I saw

at the very top.

If you really want some help...

Welsh Corgi (5/19/2011)

---

thbaig1 (5/19/2011)

---

Hi ,

@col_name= column name coming rom cursor

@ColValue= will store column value

select @ColValue=@col_name

from dbo.tblBlo

WHERE Customer_no = @CustomerNumber

...

thanks it worked 🙂

this is not thee way I am looking for

no other way?

as this column can be primary and reference exist on many places, so drop and recreate can create some problems.. 🙁

ColdCoffee (5/4/2011)

---

As Ninja put it, the solution might not be an efficient one. Can be done in 3 parts.

1. UNPIVOT your columns - this will be dynamic as u don't...

at last I have generated the explain plan file from profiler.

Now these are hundreds of files.

Is there any way to read and group all files at once and generate a...

my question is how can I extract execution plan in it.

I have created a table with some function , I have tried to open in several way but nothing like...