Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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

enter image description here

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
share|improve this question
    
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. –  Jason Cumberland Feb 15 '13 at 15:18
add comment

1 Answer

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.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.