Azure SQL Database "Could not find stored procedure 'sp_linkedservers'" through SSMS

4
votes

I've had this error for months now. On some databases on my Azure SQL Server, when I go to Edit Rows or enter Designer view in SQL Server Management Studio. I get an error

Could not find stored procedure 'sp_linkedservers'.

I don't know where it's looking or what stored procedure to add.

1
sql-serverazurestored-proceduresssmsazure-sql-database
The easy solution is to stop using the visual row editor. Just write the update statements you need instead. The visual row editor has some strange bugs that pop up occasionally. You should do the same with editing tables. - Sean Lange
That's a good point but when I'm just hopping in to change something from true to false or some other minor change, it's a lot faster to just open and edit that single cell than to find the ID and write the statement. Bulk updates, sure but there's a lot of convenience in this feature. - Tom V
I find it faster to do it with t-sql than the gui. I have SSMS open already most of the time so a simple update is way faster than digging through the list of tables and such to edit the top x rows (and worse if the row you want isn't in there). Once you are more comfortable writing t-sql you will find it is much faster. - Sean Lange
What version of SSMS is this? I don't have this issue on SSMS 2014 - Loren Paulsen
Thanks for the input everyone but the "stop using the visual editor" is not an answer to the question. I know how to write my SQL statements, I simply have a preference and an error I need to clear. - Tom V

1 Answers

3
votes

While this isn't a solution for SSMS 2014, working through SSMS 2016 CTP3 seems to be working and the problem has been solved. Thanks to @Cpt. Monac for the suggestion!