Linked Server question

• sqldba-294117

  Hall of Fame

  Points: 3486

  More actions

  February 1, 2008 at 3:21 pm

  #71075

  In SQL Server 2000, i created linked server connection for SYBASE. from SQL Server query analyzer, i want to execute store procedure "sp_xyz" with passing some parameters, which resides on Sybase server. my question, is there any limitation about executing store procedure as mentioned above or there is better way to excute store procedure. i tried using OPENQUERY & OPENROWSET but no luck.

  Any help will be highly appreciated. thanking in advance

• SQL ORACLE

  One Orange Chip

  Points: 27807

  More actions

  February 3, 2008 at 5:41 pm

  #774613

  There are some diferences in syntaxt. SQL Server uses T-Script, which is an extension of ISO92/99. But these syntax may not be accepted in Sybase.