you can copy extractor.exe from any of the servers if you have it installed or you can download from Quest site. Just make sure you are copying 32 04...

doesn't capture everything.

Have you tried this http://www.mssqltips.com/tip.asp?tip=2086&home? I use this everyday, works like a charm. Create a cursor for the set of db's you are looking to monitor.

Thanks, but this only solves part of the problem, as i mentioned in the post if i ran the exact sql in attachment runs fine but when i run through...

sure. where can i find the details?

thanks..after doing enough testing...watever settings are there in client while deploying the code is what the code takes with irrespective of the settings on the server and database..client settings always...

thanks for replies. I am talking about statistics of the database, as far as i know statistics of each database are stored in local master database. I could be wrong...

thanks Bhuvesh,but will the indexes behave the same way as in primary since statistics are local to the server?

but indexes are used on queries based on statistics and statistics are stored inside master database of local server. Am i missing anything here?

did you try changing to a different port no? try 26

Got the solution !!. Create System DSN instead of User DSN, works like charm:)

Yes. It does show but it goes sequentially,if the script fails on anyone of the servers then it wont go to the other. You will need to specify begin catch....

You are right. The dev team made changes to the view. But if i would like to find out more about statistics, if the number of actual rows and estimated...

Can we do it without exec plan? it has some confidential data, i will try to modify and put it here. Thanks

Pavan, thanks for your help but i have clearly mentioned in my first post i can say it one more time. This is the actual query "SELECT * FROM myview...