The stored procedure that I'm using is found on the following web site.
http://www.sql-server-performance.co...on_sp_code.asp
I would like to use excel to compare two databases or two tables from
different databases. The excel sheet has a two drop down boxes that you
can choose the databases and two drop boxes where you can choose the
corresponding tables to compare.
The drop boxes work. The database and table names are retrieved from
the SQL Server 2000 database.
I don't know how to get the stored procedure to return the result and
put it in the textbox that's on the excel sheet.
----
mkarja