Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Remote RECONFIGURE Expand / Collapse
Author
Message
Posted Monday, December 15, 2008 12:29 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, February 17, 2011 2:37 PM
Points: 3, Visits: 37
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

Post #619891
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse