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