From the course: SQL Server 2014: Developing Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Managing projects with SSMS

Managing projects with SSMS - SQL Server Tutorial

From the course: SQL Server 2014: Developing Databases

Start my 1-month free trial

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…

Contents