SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-08-2008, 02:52 PM
| ||||
| ||||
 Re: Accessing Remote Server Objects I think there is this limitation with 'SELECT'. I remember coming across the same problem with 'SELECT INTO' and the workaround is to use 'INSERT INTO... SELECT..' How about doing it: a) With CIS using proxy table. You create proxy table in GEO that points to HOLD1. Check out the manual. b) sp_remotesql "HOLD1", "select * from [tablename]" Originally posted by Naveen > Hi > I am using Sybase Adaptive Server. I have two database servers HOLD1 > (ver 11.9.2) and GEO (ver 12.0). I need to remotely access tables in > HOLD1 from procedures in GEO server. I have set up Remote Servers and > I can use HOLD1...sp_who when connected to GEO it give me result of > users in HOLD1. > > But when I use Select * from HOLD1...[tablename] it gives me an error > saying 'contains more than the maximum number of prefixes. The > maximum is 2' > > When I give Select * from HOLD1..[tablename] it says object not found. > > I cannot run other procedures creted in HOLD1 also > Please Help. > > regards and thanks Naveen -- Posted via http://dbforums.com      |
Linear Mode
