Hello. I'm having the error "UserProfile already exist in the database" in my website so I decided to drop the table by copying the connection string from the server to my visual studio then deleting it there. I got this error when I tried to delete the table : Update cannot proceed due to validation errors. Please correct the following errors and try again. SQL00000 :: The target database schema could not be retrieved. The reverse engineering operation cannot continue because you do not have View Any Definition permission on the server 'tcp:s08.Winhost.com'. How can I fix this? Thanks
Try restarting Visual Studio or use SQL Server Management Studio to delete the table. Instructions on how to connect to your database using SQL Server Management Studio can be found in this Knowledge Base article.
