User Profile

Collapse

Profile Sidebar

Collapse
muddler
muddler
Last Activity: Aug 20 '10, 02:58 PM
Joined: Nov 5 '09
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • muddler
    replied to Open SQL connection using T-SQL
    in SQL Server
    Ahhh!!!!!

    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
    See more | Go to post

      Leave a comment:

    • muddler
      started a topic Open SQL connection using T-SQL
      in SQL Server

      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!
      See more | Go to post
      No activity results to display
      Show More
      Working...