Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 489
  • Last Modified:

SHOWPLAN_ALL

Hello everyone...

I'm here to ask you if it is possible to store SHOWPLAN_ALL results in a table or view from a SQL Stored Procedure?

This because since from my application I'm connecting to SQL Server 2005 without DSN via ADO query, if I open the recordset that should return to me the data explained it goes getting Communication Link Failure error...maybe you could suggest me a solution to avoid that error from my application's code...

If it could be usable, the connection string I use is:
DRIVER={SQL Native Client};uid=usercreatedinsql;Network=DBMSSOCN;DATABASE=LOCALDBNAME;APP={Microsoft Data Access Component};Trusted_Connection=Yes;SERVER=SERVERNAME\SQLEXPRESS;

Thanks you in advance to all!
Ciao,
Luigi

0
npuleio
Asked:
npuleio
  • 3
  • 3
1 Solution
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi npuleio,


yoy need to store it manually...Copy the Plan text and insert it ito a table...
0
 
npuleioAuthor Commented:
Hi anee...

but I said before if I try to store the plan text manually from C++, when opening the query it returns an "Communication Link Failure" error...is there maybe another way to store it manually in a table so I can query that table and obtaining the plan on my C++ grid?

Thanks again in advance!
Ciao
Luigi
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Did u try the same in Query analyzer
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
npuleioAuthor Commented:
Yes it works on Query Analyzer and also in EMS SQL Manager 2005....
But I've solved it casually right now!...

I had just to install and change the provider of the connection string to make avoiding the "communication link failure" error using MDAC's provider instead of SQLNCLI (MSDASQL.1 instead of SQLNCLI.1's provider)

I guess I could retire the question but anyway thanks for the illumination :-)

Ciao!
Luigi
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
K. that's fine
0
 
npuleioAuthor Commented:
For a moderator: Because I figured the solution by myself, explained in my last comment, can I retire the question?

Thanks in advance!
Ciao,
Luigi
0
 
GranModCommented:
PAQed with points refunded (250)

GranMod
Community Support Moderator
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now