Improve company productivity with a Business Account.Sign Up

x
?
Solved

SQL Express for Win8

Posted on 2013-06-01
5
Medium Priority
?
515 Views
Last Modified: 2013-06-03
Hello Experts,

Is there a SQL EXpress version for Win8?

I use SQL EXpress R2 2008 on Win7 with SQL Management Studio to serve a small office, but when I tried to run the 2008 installer it gave me compatability warning, which I did not want to risk.

I also tried SQL 2012, but there are so many versions available and did not know which to choose.

As well, if 2012 is it, does it have the same restrictions like 2 GB DB? Any other restrictions like number of simultaneous connections, etc?

Thank you,
0
Comment
Question by:APD Toronto
  • 4
5 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213156
Download from below location which has given Path for download and description of each component

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/express.aspx
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213160
database size limit is 10 gb

reset limitation you can check it out below

http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx
0
 

Author Comment

by:APD Toronto
ID: 39213172
any other limits, rather than 10GB.?

By the way, how do i check how big is my db towards thid 10gb?
0
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39213177
http://msdn.microsoft.com/en-us/library/cc645993%28v=SQL.110%29.aspx

if you look at this link which has given all comparison betn express and full edition
0
 
LVL 22

Accepted Solution

by:
Haresh Nikumbh earned 2000 total points
ID: 39213181
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The goal of this Micro Tutorial is to help navigate beginning users with the app store on Windows 8. It will explain exciting features how to maximize your PC through these apps. This will be demonstrated using Windows 8 operating system.
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

606 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question