From the course: Microsoft SQL Server 2016 Essential Training
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
More about SQL Server Management Studio - SQL Server Tutorial
From the course: Microsoft SQL Server 2016 Essential Training
More about SQL Server Management Studio
- [Instructor] In this section, we're going to dive deeper into Microsoft SQL Server Management Studio. First thing I would like to show is in object explorer, if we expand this out as wide as we can, we see that connection provides additional information. So it shows me, not only the name of the SQL server I'm connected to, but also what version it's running and that I'm connected as the user Martin Guidry. I can connect to multiple SQL instances at the same time. If I go to connect, I'll have the option for database engine and this will provide the same interface as when I first started management studio. I can connect to a different SQL server, or I can connect to the same one using a different account. And now we see I'm connected to the same name, same version, but using a different account. I use this technique often, when I'm trouble shooting permissions. I'll run a command as one user, then run the exact same command as a different user. And if you get different results, that…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.