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...

I have used profiler. with all performance option checked also deadlock and some other options

thanks Lowell, but it is not giving required results.

where can i find execution plan of queries?

but it is showing like binary, how can I extract execution plan group with queries etc?