Create View

Question

I have downloaded SQL server 2008 R2 but it says "create view" is not supported.

Eventhough I downloaded express edition at the bottom it says "SQL Server Compact Edition"  Here are the details of my DB. What can I do now to make "create View" work?

 

Microsoft SQL Server Management Studio      10.50.1617.0
Microsoft Data Access Components (MDAC)      6.1.7600.16385
Microsoft MSXML      3.0 4.0 6.0
Microsoft Internet Explorer      8.0.7600.16385
Microsoft .NET Framework      2.0.50727.4963
Operating System      6.1.7600

 

Answer 1

Hi,

In any kind of version of SQL Server is possible to create views. I don't ever work with the Compact Edition but is possible in that version you cannot create views.

Connect to your instance in Management Studio and try do run this command: SELECT @@Version

This command returns to you the version installed in your machine. If this version is Enterprise, Standard or even Express, you certantly could create views. But, if your SQL Server is a Compact Edition, I recommend you to install another version to work.

 

Regards

---

Erickson Ricci
Microsoft MCP, MCTS SQL Server 2005, 2008
Visite o meu blog: http://ericksonricci.wordpress.com
Me siga no twitter: @EricksonRicci
LinkedIN: http://br.linkedin.com/in/ericksonricci
e-mail: [e-mail]
**Ajude a melhorar o sistema de busca do fórum.Marque a(s) resposta(s) que foram úteis**
**Se esta resposta solucionou a questão, então, por favor, marque-a como resposta.**

Answer 2

My guess is that Jujjuri installed Express edition, but in SSMS instead of logging into that Express Edition created a Compact Edition database and now work against that instead of working against the installed Exoress Edition instance.

---

Tibor Karaszi, SQL Server MVP | web | blog

Answer 3

It is certainly true that Compact Edition does not support views.  Since you installed SQL Server R2 Express I believe that Tibor probably has the right answer.   (It is not that hard a mistake to make.)

RLF

Answer 4

Hi Jujjuri,

In addition, I add the download link of SQL Server 2008 R2 Express Version.

 

---

Best Regards,
Peja

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.