Link to home
Start Free TrialLog in
Avatar of nanderEire
nanderEire

asked on

How to access results window in Sql Server Management Studio

Hi,

I am working with a plugin for Sql Server Management Studio. After executing a query in SSMS the results are output in a results tab. How would I be able to hook in to get acess to this data programmatically?

Any pointers of either how to do it or where to find the info that might help me are appreciated.

Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

>> How would I be able to hook in to get acess to this data programmatically?

Why can't you write a simple application to open up a connection to your SQL Server and display the results in a dynamic datatable..

You can't dynamically access the data pro-grammatically like this..
Avatar of nanderEire
nanderEire

ASKER

I need to be able to compare the results from a query the user enters, to the results we expect them to achieve. Like a tutorial type thing.
Then you can fetch both the results into a data table and can compare it in your application right..
I guess so. I'm now thinking a more straightforward way would be to capture the SQL when the user hits execute and re-run the query myself, capturing the results in code.
ASKER CERTIFIED SOLUTION
Avatar of Raja Jegan R
Raja Jegan R
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial