3

We are in the planning stages for an upgrade from SQL Server 2008 R2 to SQL Server 2014.

Our system executes stored procedures against different databases on different servers.

If we upgrade one server to SQL Server 2014, but leave the remaining servers on SQL Server 2008 R2, would we lose that ability?

2
  • 1
    How are you executing these stored procs? Linked servers?
    – Hannah Vernon
    Sep 29 '15 at 20:54
  • yes they are all linked
    – Anthony
    Sep 29 '15 at 20:59
5

As a test, I just ran the following from my SQL Server 2008 R2 instance through a linked server to my SQL Server 2012 instance:

SELECT LocalServerName = @@SERVERNAME
    , LocalServerVersion = SERVERPROPERTY('ProductVersion');

EXEC [REMOTESERVER].master.sys.sp_executesql 
    N'SELECT RemoteServerName = @@SERVERNAME
        , RemoteServerVersion = SERVERPROPERTY(''ProductVersion'');';

This will show two result-sets, one for the local server, with server name, and version, and one for the remote server with the same details.

Executing this will prove that you can run stored procedures from down-level servers to up-level servers.

4

Since linked servers are used to communicate with another server, in this case a newer version, it will all probably work for you.

However, you should check that you are not depending on an object (of any type) that has been modified and is no longer compatible. (E.g. in the msdb database sysdtspackages becomes sysssispackages.)

1
  • Thanks for the heads up. I am pretty sure we call that at some point
    – Anthony
    Sep 30 '15 at 13:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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