using a stored procedure to connect to a different database on the same server

Apr 18 2005 3:17 PM
Hello all, here is what i am trying to do. I am developing a side program to work along side a main program which i have no control over. I can not edit or create stored procedures on the database i am trying to query. It would cause the program that uses that database to not function :P. Anyway i have created my own database that will contain its own data but it also requires the data from this other database. I need to create a stored procedure to access a separate database. The code to do so would be the best for me. Also would i just be better off using a perameterized query with ado.net? thnx

Answers (2)