Menu
Is there any way to change the properties (Product name, data source, provider string, etc...) of an existing linked server? When I go to the properties screen, all the options are grayed out.
710
Open SQL Server Management Studio; go to Server Objects -> Linked Server. Under Linked Server node we have Providers node that already having installed provides and that mapped to SQL Server. Now right click on Linked Server node and click on New Linked Server which will open a new window for setup as below.
Using SQL Server Management StudioIn Object Explorer, connect to an instance of Database Engine and then expand that instance. Expand Databases, expand the database in which the procedure belongs, and then expand Programmability. Expand Stored Procedures, right-click the procedure and then click View Dependencies.
1 Open SQL Server Management Studio, navigate to the Object Explorer pane, and select Server Objects > Linked servers > Providers. 2 Right-click mrOledb. Provider and select Properties. 3 Select allow in process, and then click OK.
We can change other properties (as well as the data source and alias) by using the DROP and CREATE TO script provided through the Object Explorer with our existing linked server. Scripting a linked server using the Object Explorer (F8) or by clicking Object Explorer under View in the ribbon.
Two of the easiest ways to modify linked server properties in SQL Server are to use provided templates from the Template Browser and use the DROP/CREATE TO scripting function from an existing linked server. We can use these scripts to change the linked server alias, data source, and a wide range of other options.
Is there a SQL command that would allow you to view properties of a linked server? Yes, you can view the properties of the linked servers, and you may make changes on tabs #2 and #3. The first tab can not be changed, IE: server type and name.
In the details pane, right-click SQL Server (<instancename>), and then click Properties. In the SQL Server (<instancename>) Properties dialog box, change the server properties on the Service tab or the Advanced tab, and then click OK. Restart after changes. For some properties, you may need to restart the server before the change can take effect.
Here's the command.
EXEC master.dbo.sp_serveroption @server=N'<SERVERNAME>', @optname=N'name', @optvalue=N'<NEWNAME>'
Replace 'SERVERNAME' with the current name of the linked server. Replace 'NEWNAME' with the new name you want to give the linked server.
144
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With