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.


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

| improve this answer | |
  • 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 '15 at 9:32
  • I would try this one using profiler, havent tried it myself so far: mssqltips.com/sqlservertip/1370/… – RayofCommand Aug 20 '15 at 9:34

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.