Click here to Skip to main content
14,700,158 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
when I execute SQL script from SQL Server 2019 version in SQL Server 2012
it make this error
OPTIMIZE_FOR_SEQUENTIAL_KEY is not a recognized CREATE TABLE option
and 
<pre>Cannot find the object "dbo.AspNetUserRoles" because it does not exist or you do not have permissions.

on all table any help to solve this problem ?

What I have tried:

What can I do for these problem i didn't try any solution
Posted
Updated 22-Apr-20 2:54am
Comments
ZurdoDev 22-Apr-20 7:50am
   
You'll have to remove that option.
Member 13058758 22-Apr-20 8:09am
   
OK Thanks it's complete successfully
Member 13058758 22-Apr-20 8:38am
   
please make this reply as solution
ZurdoDev 22-Apr-20 8:40am
   
I did. Thanks.

1 solution

That option was added in SQL 2019 so if you want to run that script against Sql 2012 you will need to remove the option.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900