I can remote into another server okay and have full admin privileges.
I would like RECONFIGURE the remote server without having to RDP to it or reboot it.
What I have working is:
EXEC perfwareLS.master.dbo.sp_configure;
where perfwareLS is the name of the linked-server.
EXEC perfwareLS.master.dbo.RECONFIGURE;
does not work
select * from openquery(perfwareLS, 'RECONFIGURE')
does not work.
If there is a way to run RECONFIGURE from a system sproc that may work if any body knows how.
thanks JS