SQL Server ALTER View

Question

We had in issue with our SQL Server 2016 and the company did an upgrade to SQL Server 2019.  I have several hundred views in our SQL Server.  The views are working and retrieving data but If I try to ALTER a view I get this error.

Invalid version: 15.  (Microsoft.SQLServer.Smo)  How can I correct this?

Answer 1

What version of SSMS are you using? An upgrade to the current version of SSMS is probably a good idea generally. 

Answer 2

Version I'm using is 17.  was going to upgrade to 18.6 but that particular PC still has Windows 7 installed and from what I read that is not acceptable to 18.6.  But that does give me an Idea  I'll post back if I'm Right

Answer 3

Hi

have you check the alter permission on view to the user  ?

Thanks and regards

Answer 4

If you can't upgrade to an SSMS version that supports SQL 2019, you should still be able to alter views from a query window instead of using the designer.

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com

Answer 5

No If I right click on the view and click on Alter That's the error Message I get.  

Answer 6

That user has SA Rights on that server.  

Answer 7

I see, you're getting the error when SSMS scripts the view, not when it's altered.

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com

Answer 8

Yes I have over 300 Views in that Database some were created up to 5 years ago.   I get the error if I attempt to script the Alter for the view or attempt to open the design of the view from SSMS

Answer 9

I just installed SSMS 18.6 in an old Win 7 box and was able to script the view as ALTER. Not suggesting this is a supported configuration since Windows 7 is no longer a supported OS.

Personally, I keep db objects under source control and use that as the authoritative source.

---

Dan Guzman, Data Platform MVP, http://www.dbdelta.com