add server to sysservers

is there a way to add a remote server name to sysservers in the master DB.
i am not able to use linked server.Yes, use the sp_addserver stored procedure. Check books online for complete
syntax.
--Brian
(Please reply to the newsgroups only.)
"mcnewsxp" <mcourter@.mindspring.com> wrote in message
news:%238ZZOXsuFHA.2540@.TK2MSFTNGP09.phx.gbl...
> is there a way to add a remote server name to sysservers in the master DB.
> i am not able to use linked server.
>|||> Yes, use the sp_addserver stored procedure. Check books online for
> complete syntax.
it's the same thing as sp_addlinkedserver - and again, i can't do that.|||You'll need to provide more of a description of the problem. What exactly
are you trying to accomplish and what error message are you getting?
--Brian
(Please reply to the newsgroups only.)
"mcnewsxp" <mcourter@.mindspring.com> wrote in message
news:u4ZfeusuFHA.3764@.TK2MSFTNGP09.phx.gbl...
> it's the same thing as sp_addlinkedserver - and again, i can't do that.
>|||> it's the same thing as sp_addlinkedserver - and again, i can't do that.
Can you provide more information? What are you going to do with a server in
sysservers that you can't add by using sp_addlinkedserver?|||why not? permissions? then no, you won't be able to do this by inserting
directly into the sysservers table,either [which is what i think you're
asking]
mcnewsxp wrote:

>it's the same thing as sp_addlinkedserver - and again, i can't do that.
>
>|||why not? permissions? then no, you won't be able to do this by inserting dir
ectly into the sysservers table,either [which is what i think you're asking]
[mc] that is what i needed to know.
mcnewsxp wrote:
Yes, use the sp_addserver stored procedure. Check books online for
complete syntax.
it's the same thing as sp_addlinkedserver - and again, i can't do that.|||>
> Can you provide more information? What are you going to do with a server
> in sysservers that you can't add by using sp_addlinkedserver?
>
do a select * from server.database.owner.table.
our dba won't allow linked servers.
but it turns out we moved stuff to two dbs and he allowed us to create one
linked server this time.|||> do a select * from server.database.owner.table.
> our dba won't allow linked servers.
His policy sounds more like he doesn't allow new rows in sysservers, so
whether you get it in there using sp_addlinkedserver or any other means,
you're still not allowed to have a linked server.

> but it turns out we moved stuff to two dbs and he allowed us to create one
> linked server this time.
Well, that's good, because using OPENQUERY / OPENROWSET and dynamically
specifying the server is not the best approach.|||>> do a select * from server.database.owner.table.
> His policy sounds more like he doesn't allow new rows in sysservers, so
> whether you get it in there using sp_addlinkedserver or any other means,
> you're still not allowed to have a linked server.
>
> Well, that's good, because using OPENQUERY / OPENROWSET and dynamically
> specifying the server is not the best approach.
what is the best approach?
>