Unanswered: calling another server connection through a stored procedure
anybody have an idea how to call a server through a stored procedure....
from my asp, i connect to sql server then call a stored procedure....in the stored procedure i want to connect to a remote database (jdedwards) and bring back tables to use in that procedure that eventually is used for output.
You can do it through either linked server or remote server. Either way, you need to register the 2nd server on the first server. Provided permision is granted, you then run query in the 'select * from serverName.dbName.owner.tableName' format.
but now HOW DO I register my sql server to connect to a non Sql Server.....the only way I can connect to the other Database is through ODBC? In other words, I need my sql server's stored procedure to ODBC to a non SQL server; i.e., AS/400.