set up a linked server in enterprise manager then reference the table as
select * from servername.databasename.username.tablename ---------- Original Message ---------------------------------- from: "Mario Martinez R." <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] date: Wed, 24 Apr 2002 12:26:41 -0500 (CDT) >How could I access inside one stored procedure written >in transac-SQL one table holded in another SQL >server??. >Thanks in advance friends >regards >Mario > >> Structure your ColdFusion code with Fusebox. Get the >> official book at >> http://www.fusionauthority.com/bkinfo.cfm >> FAQ: http://www.thenetprofits.co.uk/coldfusion/faq >> Archives: >> >http://www.mail-archive.com/[email protected]/ >> Unsubscribe: >http://www.houseoffusion.com/index.cfm?sidebar=lists > >_________________________________________________________ >Do You Yahoo!? >Informaci�n de Estados Unidos y Am�rica Latina, en Yahoo! Noticias. >Vis�tanos en http://noticias.espanol.yahoo.com > ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
