January 24, 2010 at 6:33 am
I'm very new to this, so sorry if this is a silly question. I have a technical query about SQL Server 2005. I was working through some basic orientation tutorials and arrived that his page:
http://msdn.microsoft.com/en-us/library/ms167154.aspx
1.Open Management Studio, and connect to a server with Object Explorer.
2.On the File menu, point to New, and then click Project. The New Project dialog box opens.
When I go to File menu, and point to New, the only options I have are:
-Query with current connection
-Database engine query
-SQL Server Compact Edition query
So I don't seem to have access to the 'Soluction Explorer' in Server 2005. Is there any reason you know of that would explain this?
I'm using SQL Server 2005 Express Edition with Advanced Services and have also installed SQL Server 2005 Express Edition Toolkit.
thanks all,
Mark
January 24, 2010 at 7:17 am
What you are basically doing is creating a query.
You do not have to go step-by-step with this. You can simply open a new query pane, and type in the query. You kind of have to learn to read between the line.
You can select from the view menu, "Solution Explorer" if you want to create and save Solution. A Solution is a collection of different projects.
Andrew SQLDBA
January 24, 2010 at 8:56 am
cranmer.mark
When I go to File menu, and point to New, the only options I have are:
That instruction pertains to SSMS for versions higher than the Express edition. You have to be careful following those tutorials, not all apply to the Express addition.
Since you have the Express addition go to Books On Line
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/sqlexprbol/html/30a07170-3d59-4813-ab81-f3963c84f3ae.htm
Scroll down until you reach:
SQL Server 2005 Features that Are Not Supported in SQL Server Express
If your learning SQL Server I would recommend purchasing the Developer Edition 2005 - priced on Amazon.com for less than $50 (USD) 2008 just a few dollars higher
January 24, 2010 at 9:53 am
Ah, thanks! That explains a lot.
At the moment I am focusing on learning SQL and Excel VBA but thought that familiarity with Server 2005 would be useful. It looks like upgrading would be a good idea.
thanks again,
Mark
January 24, 2010 at 10:01 am
Thank you Mark
If you have any further SQL questions come back and post them to the appropriate forum. Many people who are regulars on SSC go out of their way to assist others - it is truly a community
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply