Hi, in this lesson we will learn Create Local Database Sql Server Management Studio 2014.
Today we’re, going to be talking about Microsoft SQL Server management studio 2014. We’re going to start off by setting up a database instance and working with local DB. So to do this we’re going to do two things we’re going to start off by loading up the SQL Server 2014 management studio and we’re also we’re also going to run a command prompt and I like to run that as an administrator.
In this case you don’t really have to but it’s probably just a good idea just to make sure we have everything ready to go ok so at this point if we’re loading this up we’re going to see a screen that looks like this it’s asking for a server name and we have our windows authentication methods set up here.
Typically you don’t necessarily know,what your server name is there’s several local DB names so in order to just . I’m going to I’m going to work off the premise that we just can’t find it so we’re going to start off at the beginning and we’re going to get started just by creating a new database instance.
How do I create a local database inside of Microsoft SQL Server 2014?
I’m going to call that local DB so to do this we type at the command prompt we type SQL local DB ok and when we do this we’re just by itself it comes up with a bunch of help instructions ok so at this point I can create a database instance I can delete that can start stop share unshare list all of the local DB instances andthat I can print information about an instance get the versions of local be DBS and tracing on and off so let’s start off by just asking for some information here let’s get let’s ask for info and we’ll just do it like that info.
So currently we have a few different versions of local DB already on the system here we have a couple that I’ve created for a class that each we have mssql local DB projects b12 projects B. 13 + V 11 and b12 know the projects typically ships with Visual Studio the V 11 mostly comes with SQL Studio Express and then 12 comes with our 2014 version of SQL Server management studio to the best of my knowledge that may not all be perfect but it’s close enough that’s the general rendition of it okay so if I start off here.
I am going to again let’s assume that none of these things work here and we’re going to get started off fresh because we want to use a local DB name that we can use and we can remember really easily let’s just call it we’re going to call it local DB demo okay. Oh and what I’m also going to do here let’s just do one more thing we’re going to check the versions okay oops I spelled it wrong I use the versions there we go okay there are three versions installed on my system right now .
I have a 2012 2014 2016 2016 is usually the one that that is used in Visual Studio 2016 as well as 2015 what I’m going to do because I’m using SQL management studio 2014 I’m going to use this version right here while I do this so SQL local DB create I could have used the short form C as well if I wanted to I call that local DB demo close quote and I’m going to put in this version number twelve dot 0.25 69.0 that and it just takes a minute to propagate that server done okay now if we go over here into SQL Server management studio.
I can type that dead node E demo DB or local. DB demo and just load it up connect. So here we have it we have no. Databases setup yet we’re going to do. That in our next session so guys don’t forget to like and share and we’ll catch. You on the next tutorial.