I'm trying to either create a new table or alter an exiting one using Visual Studio 2017. I can connect to the database okay and create a table, but it won't let me set the primary key column as an identity column. The error I keep getting is "The reverse engineering operation cannot continue because you do not have View Any Definition permission on the server." How can I get around this?
Sounds like you need to update your SQL Database version locally on your computer to the latest version. What's the current version you're using for your SQL Server Management Studio?
It's been so long since I've done database development in Visual Studio that I don't remember what I did to fix this. But searching around the Internet, most posts seem to indicate it's a problem with the user not having db_owner permissions. Is this a secondary SQL user you created to log into the database? Because your primary user should already have db_owner rights. And Martin might be correct, it might be caused by a database version mismatch.
