not supported query in sql server 2016

%3CLINGO-SUB%20id%3D%22lingo-sub-1119076%22%20slang%3D%22en-US%22%3Enot%20supported%20query%20in%20sql%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1119076%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EI%20want%20to%20upgrade%20SQL%20Server%20from%202008%20R2%20to%202016%2C%20is%20there%20a%20query%20on%20SQL%20Server%202008%20R2%20that%20is%20no%20longer%20supported%20on%20SQL%20Server%202016%3F%20..%3CBR%20%2F%3EFor%20example%2C%20I%20found%20that%20the%20RAISERROR%20function%20in%20the%20RAISERROR%2050001%20'xxx'%20format%20cannot%20be%20used%20anymore%20and%20must%20use%20the%20format%3CBR%20%2F%3ERAISERROR%20('xxx'%2C%2016.1)%3C%2FP%3E%3CP%3Ethanks%20for%20the%20answer..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1119076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBusiness%20Intelligence%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Warehouse%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1136986%22%20slang%3D%22en-US%22%3ERe%3A%20not%20supported%20query%20in%20sql%20server%202016%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1136986%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F526365%22%20target%3D%22_blank%22%3E%40doni_ramdani%3C%2FA%3E%26nbsp%3Bhave%20you%20completed%20a%20compatibility%20assessment%20of%20the%20database%20using%20the%20Data%20Migration%20Assistant%20tool%20-%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-overview%3Fview%3Dsql-server-ver15%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsql%2Fdma%2Fdma-overview%3Fview%3Dsql-server-ver15%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Visitor

Hi,

I want to upgrade SQL Server from 2008 R2 to 2016, is there a query on SQL Server 2008 R2 that is no longer supported on SQL Server 2016? ..
For example, I found that the RAISERROR function in the RAISERROR 50001 'xxx' format cannot be used anymore and must use the format
RAISERROR ('xxx', 16.1)

thanks for the answer..

1 Reply

@doni_ramdani have you completed a compatibility assessment of the database using the Data Migration Assistant tool - https://docs.microsoft.com/en-us/sql/dma/dma-overview?view=sql-server-ver15