I am trying to work with an Azure database as a linked server connecting through SQL Management Studio. When executing stored procedures I am getting the message:
Msg 2812, Level 16, State 62, Line 1
Could not find stored procedure 'sp_reset_connection'.
The client is:
Microsoft SQL Server 2012 - 11.0.2218.0 (X64)
Jun 12 2012 13:05:25
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )
This is not stopping the stored procedures from executing but I have an inherent dislike of unresolved warning messages. I understand that failing to reset the connection correctly can have an impact on client statistics etc.
I would appreciate any insight as to why this may be happening.
BTW: I have checked using a non-Azure linked server and do not get this message so I believe it is rspecific to Azure.