Accessing SQL 2K from SQL 7
From: Shamim (shamim.abdul_at_railamerica.com)
Date: 06/26/03
- Next message: Narayana Vyas Kondreddi: "Re: Multi server job - SQL 2K / 7"
- Previous message: Jules Bui: "viewing job status as a member of targetserverrole in msdb"
- Next in thread: Brian Moran: "Re: Accessing SQL 2K from SQL 7"
- Reply: Brian Moran: "Re: Accessing SQL 2K from SQL 7"
- Reply: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 26 Jun 2003 10:32:28 -0500
We added a new SQL instance of SQL 2K - name XXX\AB
>From SQL 7 server, I did sp_addlinkedserver 'XXX\AB'
when try to access from SQL 7
Select * from [XXX\AB].[dbname].[dbo].[tablename]
"Specified SQL Server not found"
Any thoughts ??
Sh
- Next message: Narayana Vyas Kondreddi: "Re: Multi server job - SQL 2K / 7"
- Previous message: Jules Bui: "viewing job status as a member of targetserverrole in msdb"
- Next in thread: Brian Moran: "Re: Accessing SQL 2K from SQL 7"
- Reply: Brian Moran: "Re: Accessing SQL 2K from SQL 7"
- Reply: Geoff N. Hiten: "Re: Accessing SQL 2K from SQL 7"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]