Search Result

Collapse
2 results in 0.0034 seconds.
Keywords
Members
Tags
linked server
  •  
  • QueenKirsty
    started a topic unable to run stored procedure using data from linked server via VBA
    in SQL Server

    unable to run stored procedure using data from linked server via VBA

    Setup:
    1. I have a SQL Server 2008 db (called VantageTrans) with a linked server (a Progress db called VANTAGE - the back end of our financial system).
    2. I have a stored procedure (spUpdateTblFor File) on VantageTrans (the SQL Server db) that pulls data out of the tables in VANTAGE (the linked server) and dumps the manipulated data into tables in VantageTrans.

    Issue:
    The stored procedure runs fine on when run...
    See more | Go to post
    • patrickpk
      started a topic SQL 2005 LINKED to ORACLE 10g SPEED ISSUE
      in SQL Server

      SQL 2005 LINKED to ORACLE 10g SPEED ISSUE

      All,
      I have reviewed a lot of posts but can't seem to find the answer to this one:

      I have a SQL 05 Enterprise server linked to an Oracle 10g Server to retrieve records from Oracle table (300K rows). The query is a simple select * from tbl openquery. (I know the implications of using * in a query, but bare with me through the explanation...)

      1. Initially utilized the MSDAORA provider to link SQL to ORACLE:
      Response...
      See more | Go to post
      Previous template Next
      Working...