var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Get Data from another Server
I need to connect to a database on another server, I have permission to do that. What do I need to do to be able to accomplish it. I am using ASP as the scripting language.
What about linked server?
Yep...you may want to do a sp_addlinkedserver on one of the servers pointing to the other server, then you use a fully qualified name for the table. Example:
SELECT lt.Field1, lt.Field2...
FROM LinkedServerName.DbName.DBOwner.TableName AS lt
You can join tables in the local database to this fully qualified table name just as if it existed in that database.