Re: MS SQL Server Perl DBI

[rdfield]

No, that's an SQL Server issue. A single SQL statement, correctly written, that accesses many databases is not a problem for any client software (including DBI). It is a server configuration issue - the definitions of, and the permissions granted to, the DB Links are what defines if a query can successfully joins tables over multiple databases.

[Grygonos]

First of all you need to make sure that the server is linked in Enterprise Manager. Then secondly the method for specifying data in linked servers is very tedious.

select linked.fields 
FROM servername.dbname.owner(usually dbo).table as linked
where linked.criteria

That's the syntax for querying a linked server in MSSQL. That should get it done. Be warned you cannot specify the with(no lock) criteria on a linked server. Also you must specify an alias to the linked server via the as xxx method to be able to resolve conflicting field names. using the fully quantified name produces an error.
hope this helps,