link sql servers using enterprise manage

From: Jason (jasonlewis_at_hotrmail.com)
Date: 03/25/05 

Date: Fri, 25 Mar 2005 11:30:18 +0100

Hi

Can anyone explain me the options for linked servers in the enterprise
manager.

I've tried to link another sql server but i'm gettng errors.

Relevant Pages

  • Re: Copying from one record set to another
    ... I had a version using linked servers in SQL Server, ... I have another thread in the SQL server newsgroup looking for an answer ... read about linked tables in Access online help - a linked table can be ...
    (microsoft.public.data.ado)
  • Re: Permissions on master..sysservers
    ... application uses linked servers to link to other SQL Servers. ... I've noticed the constraint is across all of our SQL2K SP3 installations, ... > Jasper Smith (SQL Server MVP) ... > constraint on the providerstring column causing the select statement to ...
    (microsoft.public.sqlserver.security)
  • Re: How to use ODBC datasources in SQL Server 2005 x64
    ... I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard x64. ... Now i try to get the linked Servers working, ... The MSDASQL (ole db provider for ODBC data sources) is missing. ... SQL Server 2005 x64 does not support ODBC Data sources as linked servers!! ...
    (microsoft.public.sqlserver.connect)
  • Re: temp db indexing in SQL2k
    ... SQL Server has something called deferred name resolution. ... But if all tables in a query exists, then all other objects in the ... Maybe your scenario with linked servers changes the scene here, ... Books Online for SQL Server SP3 at ...
    (microsoft.public.sqlserver.programming)
  • How to use ODBC datasources in SQL Server 2005 x64
    ... I migrated from SQL Server 2000 Standard to SQL Server 2005 Standard x64. ... Now i try to get the linked Servers working, ... The MSDASQL (ole db provider for ODBC data sources) is missing. ...
    (microsoft.public.sqlserver.connect)