• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 237
  • Last Modified:

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.
0
chima
Asked:
chima
3 Solutions
 
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
 
vivekkumarSharmaCommented:
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
 
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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 ToddSenior 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
 
Jason Yousef, MSSr. 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
 
chimaAuthor Commented:
Thanks
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now