Open SQL connection using T-SQL

I would like to connect to a remote sql server using a stored procedure. I had planned on using OPENQUERY( linked_server ,'query' ) to pull data from the remote server but this command does not accept variables for its arguments. Is there another way to open a connection using Transact-SQL?

Thanks for your help!

re: Open SQL connection using T-SQL

Will this work:

That's just a pseudo-code...

Happy Coding!!!


--- CK

re: Open SQL connection using T-SQL

I guess I just needed to treat it like any other query but include the linked server name in the string.

I'm still pretty wet behind the ears. Thanks so much for your help ck9663. This was my first visit to this sight. I appreciate you taking the time to reply.

- Muddler