Re: Managing SSCE v3.5 thru VS2008 and/or SSMS

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

Carlos,

You should be able to change the table schema of a SSCE 3.5 database using Visual Studio 2008. Open the Server Explorer and expand the Data Connections node. Select your SSCE 3.5 database file. Expand the node until you see Tables, then expand that node until you find the table you want to change. You should be able to right-click on the table name and select Edit Table Schema.

SSCE 3.5 databases are not support by SQL Server 2005 Management Studio as you found, but they are supported with SQL Server 2008 Management Studio.

--
Ginny Caughey
Device Application Development MVP

www.wasteworks.com
Scalehouse and Billing Software for Waste Management



"Carlos" <ch_sanin@xxxxxxxxx> wrote in message news:Oxmuq1AcIHA.4332@xxxxxxxxxxxxxxxxxxxxxxx

Hi all,

I just found out that if I want to edit the schema for a table within
VS 2008 I can't. (for instance change the 'Allow Nulls' property in a field
from 'No' to 'Yes').

I tried it using SSME but the tool apparently does choke when it finds
that the table has a different format. Even though I select the server type to
be 'SQL Server Compact Edition'.

I thought that at least the feature to edit the schema could be done from
within VS 2008..!

Does anyone know how to do these tricks?

Thanks,

Carlos.


.

Relevant Pages

  • Re: Managing SSCE v3.5 thru VS2008 and/or SSMS
    ... You should be able to change the table schema of a SSCE 3.5 database using ... Visual Studio 2008. ... Open the Server Explorer and expand the Data ...
    (microsoft.public.sqlserver.ce)
  • Re: Some Domains not delivering correctly
    ... As you said "I think it is something to with the SMTP", ... The POP3 Connector may download e-mail messages from the remote POP3 ... server, but those e-mail messages may not be delivered to the user. ... In the Server Management tool, expand Advanced Management, expand ...
    (microsoft.public.windows.server.sbs)
  • Re: adprep /forestprep failure
    ... I ran ntdsutil to seize the schema master role, ... # Jorge de Almeida Pinto # MVP Windows Server - Directory Services ... The win 2003 server is not yet a DC, since I can't run adprep. ... Schema FSMO holder shows spserver01.season.com. ...
    (microsoft.public.windows.server.active_directory)
  • Re: Upgrading from windows 2003 to windows 2008.
    ... 2008 R2 requires again a schema update on the 2008 schema master. ... Exchange upgrade requires also a schema update from the exchange 2007 installation disk, just follow the wizard when you insert the disk. ... As long as you not raise the functional levels to Windows server ... configure a fixed ip and set the preferred DNS server to the old ...
    (microsoft.public.win2000.active_directory)
  • Re: can any application isten to a particular port on WM 6.0 devic
    ... running on any other server can write data on that port at any point of time. ... EventsArchitecture GeneralArchitecture, Tools, and Process for ISVsASMX Web ... Studio Team SystemHD DVD Interactivity AuthoringHealthVaultHealthVault Data ... DevelopmentWindows Desktop Search HelpWindows Error Reporting for ISVsWindows ...
    (microsoft.public.pocketpc.developer)