IIRC, as long as permissions are set up correctly (i.e. the two servers belong to the same domain, have a trust relationship of some sort, etc) you can just do
select * from server.db.schema.tableorview where ... without explicitly setting up a linked server. (As long as both servers are SQL Server, of course.) Linked servers add functionality like using different logins than your current one, connecting to non-SQL Server databases, etc. On 7/2/07, Mike Andrews <[EMAIL PROTECTED]> wrote:
Guys, Perhaps I'm being crazy here, but is it possible to execute a cross-sql server query without having to set up a linked server in sql server? My problem is that I want to execute a sql statement against two different databases located on two different servers but I don't really want a linked server (or I'd rather not if at all possible). Any suggestions? Thanks, Mike =================================== This list is hosted by DevelopMentor(r) http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
-- Eric Means [EMAIL PROTECTED] http://www.randomtree.org/eric/ =================================== This list is hosted by DevelopMentor® http://www.develop.com View archives and manage your subscription(s) at http://discuss.develop.com
