0

I configured a linked server in SQL Server 2008 R2; mirroring what currently exists in SQL Server 2000.

When viewing the properties of an existing linked you, you cannot see (or edit) any information in 2008R2 - where you can in 2000

Note: This is different from the unresolved bug where you cannot edit any details of a linked server in SQL Server 2008 R2 without it throwing an error.

So, how do i fix SSMS?


  • SQL Server: Microsoft SQL Server 2008 R2 (SP1) - 10.50.2550.0 (X64)
  • SQL Server Management Studio: 10.50.2550.0
1
  • I'm pretty sure these fields have been non-editable since 2005 came out. Scripting out the link and making the changes you want to the link is the way to go. If you suspect it's a bug then you should put an entry on connect.microsoft.com. Feb 15, 2013 at 15:18

1 Answer 1

2

What I have done for this issue is script out the linked server where I can then see the properties defined within the script that is produced. This is a less then ideal solution but at the very least a work around so to what appears to be a problem in SSMS.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .