Problem with SP_addlinkedserver

hi
right now I search a way to set the link Server with a T-Sql SCRIPT.
but the problem is here that I need to set the Server Options also.
is the any way to do this via T-SQL?
thanks for any kind of help
KlausHow about sp_serveroption?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"news.microsoft.com" <Klaus.Bilger@.C-S-L.BIZ> wrote in message
news:%2326D54FXFHA.2692@.TK2MSFTNGP15.phx.gbl...
> hi
> right now I search a way to set the link Server with a T-Sql SCRIPT.
> but the problem is here that I need to set the Server Options also.
> is the any way to do this via T-SQL?
> thanks for any kind of help
> Klaus
>|||well good question,
but I think no way with the sp_dboption, that is only for the DB Option like
Read-Only, Offline..
anyway thanks for the idea
klaus
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
im Newsbeitrag news:uVrqtXGXFHA.2288@.TK2MSFTNGP14.phx.gbl...
> How about sp_serveroption?
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "news.microsoft.com" <Klaus.Bilger@.C-S-L.BIZ> wrote in message
> news:%2326D54FXFHA.2692@.TK2MSFTNGP15.phx.gbl...
>|||Please read my response again. I didn't say sp_dboption, I said sp_serveropt
ion. Below is from BOL:
Sets server options for remote servers and linked servers.
In this release, sp_serveroption has been enhanced with two new options, use
remote collation and
collation name, that support collations in linked servers.
Syntax
sp_serveroption [@.server =] 'server'
,[@.optname =] 'option_name'
,[@.optvalue =] 'option_value'
Arguments
[@.server =] 'server'
Is the name of the server for which to set the option. server is sysname, wi
th no default.
[@.optname =] 'option_name'
Is the option to set for the specified server. option_name is varchar(35), w
ith no default.
option_name can be any of the following values.
<snip>
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"news.microsoft.com" <Klaus.Bilger@.C-S-L.BIZ> wrote in message
news:%236haMoGXFHA.3856@.TK2MSFTNGP10.phx.gbl...
> well good question,
> but I think no way with the sp_dboption, that is only for the DB Option li
ke
> Read-Only, Offline..
> anyway thanks for the idea
> klaus
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> schrieb
> im Newsbeitrag news:uVrqtXGXFHA.2288@.TK2MSFTNGP14.phx.gbl...
>