Managing projects with SSMS

- Let's take a look at using…SQL Management Studios…project managements capabilities.…So, we'll connect into SQL Server 2,…which is the one I was connected into before.…So now I have the Object Explorer up and running…and if I come down here and look at the File and go New.…Now I'm going to select Projects.…So we're going to just click in here…and the project pops open.…There are two templates currently installed,…the one you're going to use normally, which is SQL Server.…

And then there's also if we're creating…a multi-dimensional database,…then we use Analysis Services.…But we're going to go in with this…and the name down here, I'm going to…just leave the default name, it just names these in orders…and I'm using the default location,…doesn't matter for this little demo.…So we'll go through and we'll say OK.…So now it'll create a new project, and to see that project,…we're going to go View down here and…we'll find Solution Explorer.…

So now you see the project we have…and the project in SQL…is a collection of…connections, different connections we have…