Post reply

Saving a view in SqlServer Express 2005

  • January 17, 2006 at 5:15 am

    #170562

    I have installed Express 2005 and attached a d/b I used in SQL Server 2000. When I try to modify a view in a d/b on my local server, when I go to save it, it tries to save the view as an external .sql file and refuses to simply update the original view.

    Can anyone tell me what I am doing wrong?

    Thank you

  • January 17, 2006 at 5:33 am

    #615103

    Have you upgraded the SQL 2K database to SQL 2K5?  I think you may need to do that prior to being able to use it...  (I think I read something here on upgrading from 2K > 2K5)



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • January 17, 2006 at 5:55 am

    #615109

    I didn't upgrade. Until now everything seemed to work perfectly so I wasn't aware of any need to upgrade. I'll go search at MS. Thanks for the idea

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply