I am utilizing sql server 2008 to create a linked server to another sql server 2008 instance.
I am using the following string to setup my linked server:
@server = N'Name of Linked Server',
When I go to set the login and username I get the following error 'ad hoc updates to system catalogs are not
I ran sp_configure and saw that allow_updates was set to '1' so I'm not sure what the problem is here.
Any help would be appreciated. Thanks!
This could be a bug in SSMS. Maybe try using sp_addlinkedsrvlogin e.g.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?