Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Sql CE installation

Author  Topic 

vsprajeesh
Starting Member

1 Post

Posted - 2011-04-09 : 08:26:22
I didn't get the all options in sql server2005 CE like in Database Restore, Back up so and so, and in Table show data.... like that all things are missing in my sql server 2005 CE. is in't my installation problem. If so tell how to install sqlserver CE.
My way of installation is
Compact SDK
Compact Tools
Compact SQL edition
and i am opened sql cE in sql management studio, i can create the database,table etc. but i cant view the table data.
When i right click on my table only edit-table,properties,delete,report,refresh only,
When i right click on my sqlCE database only have connect,disonnect,register,newquery,properties,delete,report,refresh only. The database contains onlytables,views,programability,Replication only.
I am a fresher in SQL server CE. I have a back up file in same server .Also please tell how to restore it in compact edition.
while using query i can select or insert data.
   

- Advertisement -