SQL Server 2000. There is a linked server and I want to replicate, in
TSQL only, the code that I could execute on another server to re-gen
it. It doesn't seem to be created if I "script all SQL objects" from
Enterprise Manager or SQL Workbench.

Thanks.

Hello Lucius,

There is no script out function available for Linked Server. The only way
to add the Linked Server is using the following TSQL script:

EXEC sp_addlinkedserver @server='S1_instance1', @srvproduct='',
@provider='SQLOLEDB',
@datasrc='S1\instance1'

All the linked server information is stored in the system table sysservers.

You could retrieve all the remote server information from here:

select * from master.dbo.sysservers where isremote = 1

For more detailed information, you could refer the following articles:

sp_addlinkedserver
http://msdn2.microsoft.com/en-us/library/ms190479.aspx

If you have any question, please feel free to let me know.

Sincerely,

Wei Lu

Microsoft Online Community Support

==================================================

Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.

==================================================
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

I still need assistance. The answer "there is no way" is not
sufficient. With the command you gave me, SQL Server is storing the
information *somwehere*. SQL Server knows how to call up the linked
server and use it. As far as I know, SQL Server stores everything in
tables. So what tables do I query to build a new string so I can
recreate the linked server?

Thanks.



On Wed, 14 Feb 2007 09:00:16 GMT, weilu@online.microsoft.com (Wei Lu
[MSFT]) wrote:

>Hi ,
>
>How is everything going? Please feel free to let me know if you need any
>assistance.
>
>Sincerely,
>
>Wei Lu
>Microsoft Online Community Support
>
>================================================= =
>
>When responding to posts, please "Reply to Group" via your newsreader so
>that others may learn and benefit from your issue.
>
>================================================= =
>This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Lucius,
Wei is on Chinese New Year vacation now. I would like to work with you on
this issue.

Yes, you are right. You can run the following statement to retrieve the
linked servers:
select * from sys.servers where is_linked=1

Hope this s. Please feel free to let me know if you have any other
questions or concerns.

Charles Wang
Microsoft Online Community Support
================================================== ===
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications

If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.


Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.

Charles Wang
Microsoft Online Community Support

================================================== ====
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
================================================== ====
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====

Hello Lucius,

I would like to know how is everything going.

My team member Charles provided the script to get the linked server
information. Did you use this script to get the information? Anything we
could do, please do not hesitate to let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.