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.

nanderEireAsked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Yes, that should be the efficient way to do it..
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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..
0
 
nanderEireAuthor Commented:
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.
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
Then you can fetch both the results into a data table and can compare it in your application right..
0
 
nanderEireAuthor Commented:
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.
0
All Courses

From novice to tech pro — start learning today.