Home Dashboard Directory Help
Search

modify linked server data source sql server 2005 by EugeneZ1


Status: 

Closed
 as Won't Fix Help for as Won't Fix


1
0
Sign in
to vote
Type: Suggestion
ID: 321982
Opened: 1/11/2008 10:05:11 AM
Access Restriction: Public
0
Workaround(s)
view

Description

there was linked server created with some name and Data source-> real sql server name.
1 day the real sql server was retiered and new named sql server has been used instead
All code is using 'some name' of linked server pointed to old Data source- old sql server name:
and there is no way to just change the old sql server name to new - in the Data source.
Just drop and recreate linked server
Details
Sign in to post a comment.
Posted by Microsoft on 5/11/2011 at 8:06 PM
Hi:

We took a look at this bug along with several others recently. Unfortunately, triaging it against other critical bugs, I do not think we would get to investigating this in the near future. However, we have taken note of this internally, and when we revisit this functionality in the future, we will try and get this resolved.

Thanks for writing in to Microsoft.

Cheers,

Chandramouli | Program Manager | SQL Server Manageability
Posted by Microsoft on 1/14/2008 at 7:35 AM
Hi Eugene Zhitomirsky,

Thank you for reporting this problem to us. We will try to address the issue post Katmai release.
The current workaround would be to drop and recreate the datasource.

Regards,
Karthik

SQL Server Team
Sign in to post a workaround.