SQL New Solution

Hello,
I'm at; http://msdn.microsoft.com/en-us/library/ms173769(v=sql.105).aspx
And in my Studio I do not see the menu selection for a "New Project";
To create a new solution and project
On the File menu, point to New, and then click Project.


Why do I not see it/have it?

You will notice that the link above is for the 2008 R2 version.
chimaAsked:
Who is Participating?
 
Jason Yousef, MSConnect With a Mentor Sr. BI  DeveloperCommented:
SSMSE doesn't support database projects, it's not like the full product SSMS.

http://msdn.microsoft.com/en-us/library/ms365247%28v=sql.90%29.aspx

in SSMSE you would create a separate files instead for your project.
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Are you actually using BIDS?  
http://www.jasonyousef.com/2012/03/what-is-bids-business-intelligence.html

or just launching Visual Studio the full product?

BIDS
0
 
vivekkumarSharmaConnect With a Mentor Commented:
In any version of SQL Server,

BIDS provide the same way to create new projects as Screen attached by  huslayer.

If there is any issue, Attach a screen for your studio.

Alternatively

you can use Shortcut keys as listed below.

CTRL+Shift+N for new project.
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
chimaAuthor Commented:
huslayer and Kumar, I'm using the 2008 R2 SQL Server Management Studio and following this link; http://msdn.microsoft.com/en-us/library/ms173769(v=sql.105).aspx
0
 
Jason Yousef, MSSr. BI  DeveloperCommented:
Ohh!! you're in SSMS..
check the following on how to find it, can you attach a screen shot of what you have !!!

what edition you're using?  express??
SSMS.png
0
 
chimaAuthor Commented:
huslayer, yes EXPRESS.  This is all I get;
Express File New but no Project
0
 
David ToddConnect With a Mentor Senior DBACommented:
Hi,

What are you trying to do?

A SQL Query against SQL Express - then either of the top two options.

A Integration package?

SQL queries tend to be stand-alone files; none of the solution/project stuff from visual studio, although you can do some of that for larger projects

HTH
  David
0
 
chimaAuthor Commented:
Thanks
0
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.

All Courses

From novice to tech pro — start learning today.