locked
SQL Server ALTER View RRS feed

  • 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?

    Saturday, August 15, 2020 12:05 AM

All replies

  • What version of SSMS are you using? An upgrade to the current version of SSMS is probably a good idea generally. 
    Saturday, August 15, 2020 3:02 AM
  • 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
    Saturday, August 15, 2020 4:34 AM
  • Hi

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

    Thanks and regards

    Saturday, August 15, 2020 10:10 AM
  • 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

    Saturday, August 15, 2020 11:15 AM
  • No If I right click on the view and click on Alter That's the error Message I get.  
    Saturday, August 15, 2020 1:00 PM
  • That user has SA Rights on that server.  
    Saturday, August 15, 2020 1:09 PM
  • 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

    Saturday, August 15, 2020 1:37 PM
  • 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
    Saturday, August 15, 2020 1:47 PM
  • 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

    Saturday, August 15, 2020 2:39 PM