Re: SQL Server Management Studio Support

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Wesley,

Are you using the version of SSMS that comes with SQL Express? Currently SQL
Mobile isn't supported. You can edit queries in Visual Studio 2005 but you
can't "add querires to the database file" since SQL Mobile doesn't support
stored procedures.

--
Ginny Caughey
Device Application Development MVP


"Wesley Peace" <WesleyPeace@xxxxxxxxxxx> wrote in message
news:uKCiWTUIHHA.3780@xxxxxxxxxxxxxxxxxxxxxxx
I'm trying to build a SQL Mobile application and creation of the .sdf file
is becoming a challenge. The Microsoft documentation shows creation of the
database file in SMSS. The picture shows an option for a database file of
type "SQL Server Mobile."

The version of SMSS I have has the Server Type grayed out. I have to build
the database in Visual Studio with limited ability to manage it.

Did I miss something? Is there additional support that needs to be
installed to enable the build of ".sdf" files? How can I even edit or add
queries to database file?

I was at least expecting the same type of functionality and support from
SQL mobile as I do with SQL 2005.

--
_______________________________
Wesley Peace





.

Relevant Pages

  • RE: Database File Locations
    ... we cannot detach a database file from the service. ... Is it the SQL Express? ... a database file and copy it to a production server, ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • Re: SQL Server Management Studio Support
    ... install SQL server on my laptop with SQL Express already installed. ... I guess my next step is to see if I can only install the SSMS component from ... but you can't "add querires to the database file" since SQL Mobile ... Is there additional support that needs to be ...
    (microsoft.public.sqlserver.ce)
  • SQL Server Management Studio Support
    ... I'm trying to build a SQL Mobile application and creation of the .sdf file ... database file in SMSS. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server Management Studio Support
    ... Are you using the version of SSMS that comes with SQL Express? ... SQL Mobile isn't supported. ... you can't "add querires to the database file" since SQL Mobile doesn't ... Is there additional support that needs to be ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Server Management Studio Support
    ... SSMS gets installed along with SQL 2005, so I never used it as a separate ... but you can't "add querires to the database file" since SQL Mobile ... Is there additional support that needs to be ...
    (microsoft.public.sqlserver.ce)