I'm using SQL Server in various versions. In case of this I'm using functions which got deprecated.

My question is, how a deprecated function affects the usage of SQL Server?

The functions are still working but could it be, that any settings blocking the execution?

Thanks for your help.

1 Answer 1


Deprecated functions / features work fine in your current SQL Server Version. It is just a hint for you that in future versions of the SQL Server these functions will be dissmissed or replaced by others. It doesn't mean that these functions are removed in the very next version, but it is planned in long term to remove them.

A list of deprecated features is available here: Microsoft SQL Server 2016 Deprecated features

  • Okay, thank you :) Is there any way how the Server returns a warning or something like this? I'm receving nothing but from the Microsoft Page i'm knowing, that this function is deprecated.
    – Niklas B.
    Aug 20, 2015 at 9:32
  • I would try this one using profiler, havent tried it myself so far: mssqltips.com/sqlservertip/1370/… Aug 20, 2015 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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