question

BenjaminShaw-2231 avatar image
0 Votes"
BenjaminShaw-2231 asked Cathyji-msft commented

Deprecated features still working

Hi,

When a feature is deprecated in SQL Server does it mean that an error will occur if it is used.

For example. I was under the impression that the IMAGE data type was deprecated in 2019. However, it appears like I can still use it. select cast(null as image).

The Microsoft documentation also says there are no breaking changes in 2019. Dose this mean that anything which works in 2016 will still work in 2019.

Many thanks :)

sql-server-generalsql-server-transact-sqlsql-server-migration
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @BenjaminShaw-2231,

We have not received a response from you. Did the reply(s) could help you? If the response helped, do "Accept Answer". If it is not, please let us know. By doing so, it will benefit all community members who are having this similar issue. Your contribution is highly appreciated.

0 Votes 0 ·
LeonLaude avatar image
1 Vote"
LeonLaude answered LeonLaude edited

Hi @BenjaminShaw-2231,

From the documentation:
Deprecated database engine features in SQL Server 2019 (15.x)

Deprecation guidelines

When a feature is marked deprecated, it means:

The feature is in maintenance mode only. No new changes will be done, including those related to addressing inter-operability with new features.
- We strive not to remove a deprecated feature from future releases to make upgrades easier. However, under rare situations, we may choose to permanently discontinue (remove) the feature from SQL Server if it limits future innovations.
- For new development work, do not use deprecated features. For existing aplications, plan to modify applications that currently use these features as soon as possible.

You can monitor the use of deprecated features by using the SQL Server Deprecated Features Object performance counter, or the deprecation_announcement and deprecation_final_support extended events. For more information, see Use SQL Server Objects.


(If the reply was helpful please don't forget to upvote and/or accept as answer, thank you)


Best regards,
Leon


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
1 Vote"
OlafHelper-2800 answered

When a feature is deprecated in SQL Server does it mean that an error will occur if it is used.

No, that won't error out. If you run a trace / Profiler , you get Deprecation Announcement Event, that's all.
Deprecated means, the feature will be removed in a future version of SQL Server and you should avoid it using in new development, but until the feature is finally removed, it will still work. Only some less deprecated system views may return an unexpected result.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DanGuzman avatar image
1 Vote"
DanGuzman answered

The Microsoft documentation also says there are no breaking changes in 2019. Dose this mean that anything which works in 2016 will still work in 2019.

Not quite. The list of breaking changes is not cumulative so you need to review the changes between your current and target version too. See SQL Server 2017 breaking changes.



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered

Hi @BenjaminShaw-2231,

When a feature is deprecated in SQL Server does it mean that an error will occur if it is used.

No, if a feature is marked deprecated, it means the feature is in maintenance mode only. No new changes will be done. It can be still used. But we suggest you do not use deprecated feature in new development works.

Dose this mean that anything which works in 2016 will still work in 2019.

No, as Dan mentioned, you need to check the SQL server 2017 breaking changes.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.