Post reply

exec ('select * from property') at rm_linked error

  • March 15, 2012 at 11:08 am

    #252633

    i am using sql 2000 and i am trying to use the following

    select * from openquery(rm_linked,'select * from property') ---- this works

    but when i try to use the AT syntax

    exec ('select * from property') at rm_linked

    i get a syntax error on at

    does sql 2000 support this syntax or do i have to have 2005 or greater

    i am connecting to a sysbase db ase driver 15.0

  • March 15, 2012 at 8:47 pm

    #1460294

    EXECUTE .. AT .. does not exist in SQL 2000

    _____________________________________________________
    Microsoft Certified Master: SQL Server 2008
    XDetails Addin - for SQL Developers
    blog.sqlxdetails.com - Transaction log myths

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply