|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
add server to sysserversis 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. -- Show quote--Brian (Please reply to the newsgroups only.) "mcnewsxp" <mcour***@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 it's the same thing as sp_addlinkedserver - and again, i can't do that.> complete syntax. 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? -- Show quote--Brian (Please reply to the newsgroups only.) "mcnewsxp" <mcour***@mindspring.com> wrote in message news:u4ZfeusuFHA.3764@TK2MSFTNGP09.phx.gbl... >> 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. > > 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.> 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? > > 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. His policy sounds more like he doesn't allow new rows in sysservers, so > > our dba won't allow linked servers. 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 Well, that's good, because using OPENQUERY / OPENROWSET and dynamically > linked server this time. specifying the server is not the best approach. >> do a select * from server.database.owner.table. what is the best approach?>> >> 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. Show quote > > what is the best approach? Using a linked server and four-part naming. What could possibly be your dba's reasoning for not allowing a linked server and forcing you to use some other approach? Did your dba make any suggestions? That's his job, isn't it? >> what is the best approach? he finally conceded, as i said> > Using a linked server and four-part naming. What could possibly be your > dba's reasoning for not allowing a linked server and forcing you to use > some other approach? Did your dba make any suggestions? That's his job, > isn't it? he never gave a reason for not allowing linked server. all i know is that every thing we do has to pass the highest security checks. 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: Show quote >>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. > > > > 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]
[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.  |
|||||||||||||||||||||||
Other interesting topics