I have my own database on my local system and same database on Remote system, which I can connect through Internet. Now I want to get a report of all records in a table (same table data from both databases mine and remote) on a asp page.
Please any one tell me how can I connect through Internet to retrieve data from remote system SQLServer 2005 database.

Urgent..Please any one reply me....

Ramesh Sambari