From: Gene Wirchenko on 29 Jul 2010 22:50 Dear All: I am using SQL Express 2008 and working through the tutorials. So far, I have been able to do everything although occasionally, the system and the tutorial do not quite match. I am stumped now though. "Using Script Projects and Solutions To create a script project and solution 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." I have tried many times. File -- New gives choices of Query with Current Connection Database Engine Query SQL Server Compact Query Policy There is no choice "Project". What am I missing, please? I did find a doc note that a solution must be open for the Project choice to be available, but I can not see how to open a solution either, and the tutorial mentions nothing about solutions. (I also do not know what is meant by a solution in this context.) Sincerely, Gene Wirchenko
From: Erland Sommarskog on 30 Jul 2010 05:04 Gene Wirchenko (genew(a)ocis.net) writes: > I am using SQL Express 2008 and working through the tutorials. So > far, I have been able to do everything although occasionally, the > system and the tutorial do not quite match. I am stumped now though. > > "Using Script Projects and Solutions > > To create a script project and solution > > 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." > > I have tried many times. File -- New gives choices of > Query with Current Connection > Database Engine Query > SQL Server Compact Query > Policy > There is no choice "Project". > > What am I missing, please? > > I did find a doc note that a solution must be open for the > Project choice to be available, but I can not see how to open a > solution either, and the tutorial mentions nothing about solutions. (I > also do not know what is meant by a solution in this context.) In Visual Studio they have solutions, but I have never understood what problem they solve. It seems that "solution" might be a utterly strange word for "workspace", but if there is anything in this world that makes me confused it's Visual Studio, at least versions after VS6. And SQL Server Management Studio is built on the same shell as VS, which may explain some of these funny things. Now for the good news: you don't have to use projects or "solutions" to use SSMS. I have never used them myself, and understand about as little as you do of them. I should add that when I look in the New menu on my instance of SSMS, I do see "Project". I guess that you are using SSMS Express, and this particular feature may be missing from SSMS Express. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Gene Wirchenko on 30 Jul 2010 14:56 On Fri, 30 Jul 2010 11:04:18 +0200, Erland Sommarskog <esquel(a)sommarskog.se> wrote: [snip] >Now for the good news: you don't have to use projects or "solutions" to use >SSMS. I have never used them myself, and understand about as little as you >do of them. So what do I do? Just create scripts and save them as <mumble>.sql? >I should add that when I look in the New menu on my instance of SSMS, I do >see "Project". I guess that you are using SSMS Express, and this particular >feature may be missing from SSMS Express. It identifies itself on the splash form as "Microsoft SQL Server 2008 Management Studio". Sincerely, Gene Wirchenko
From: Erland Sommarskog on 30 Jul 2010 16:26 Gene Wirchenko (genew(a)ocis.net) writes: > So what do I do? Just create scripts and save them as ><mumble>.sql? Yup. Anything that works for you. > It identifies itself on the splash form as "Microsoft SQL Server > 2008 Management Studio". Well, how did you get hold of it? I don't seem to have SSMS Express 2008 installed anywhere, so I can say how it presents itself, but SSMS Express is essentially a stripped down version of SSMS, so it may not actually say Express when you start it. Help->About may reveal something. -- Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se Links for SQL Server Books Online: SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
From: Gene Wirchenko on 31 Jul 2010 01:59 On Fri, 30 Jul 2010 22:26:32 +0200, Erland Sommarskog <esquel(a)sommarskog.se> wrote: >Gene Wirchenko (genew(a)ocis.net) writes: >> So what do I do? Just create scripts and save them as >><mumble>.sql? > >Yup. Anything that works for you. > >> It identifies itself on the splash form as "Microsoft SQL Server >> 2008 Management Studio". > >Well, how did you get hold of it? I downloaded and installed SQL Express 2008. According to my download records: SQLEXPRADV_x86_ENU.exe SQL Server 2008 Express with Advanced Services 2008-12-29 [download date] downloaded starting from http://www.microsoft.com/downloads/details.aspx ?FamilyId=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en >I don't seem to have SSMS Express 2008 installed anywhere, so I can say how >it presents itself, but SSMS Express is essentially a stripped down version >of SSMS, so it may not actually say Express when you start it. Help->About >may reveal something. Nope. It says it is SQL Server etc. not SQL Express. No, I did not try to steal a copy. Sincerely, Gene Wirchenko
|
Next
|
Last
Pages: 1 2 Prev: export from Sql Server table to delimited text ";" Next: Simple (?) SQL problem |