Results 1 to 2 of 2

Thread: SQL ce 2005 Problem

  1. Sep 3rd, 2008, 03:44 AM #1
    wiadus
    wiadus is offline

    Thread Starter
    Hyperactive Member
    Join Date
    May 2005
    Location
    London United Kingdom
    Posts
    334

    Angry SQL ce 2005 Problem

    Hi, I was using VS 2005 and move to VS 2008. When I upgraded my app from VS 2005 to VS 2008 my DB was also upgraded to SQL ce 3.5 but can not do anything to it using the SQL Server Management Studio, it does not open even though I am able to quary it in the Visual Studio but it's limited. I am not able to use sql statement to create a table and if you I use the create table from the server exp I can't reference the table. So I would be glad if anyone know what I should do to be able to work on the db using the Sql Server management studio. Thanks
    Reply With Quote Reply With Quote
  2. Sep 3rd, 2008, 04:20 AM #2
    petevick
    petevick is offline
    Frenzied Member
    Join Date
    Oct 2005
    Posts
    1,286

    Re: SQL ce 2005 Problem

    I think you need SqlServer2008 to use managment studio on a 3.5 database.

    There is a 'how do I' video on upgrading and database consequences by Jim Wilson here
    Pete Vickers
    MVP - Device Application Development
    http://www.gui-innovations.com http://mobileworld.appamundi.com/blogs/
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width