Description
Before you begin this assignment you should right click on the database engine and choose properties. Click on the security tab and make sure "SQL Server Authentication" is selected. Click OK and then right click the datbase engine and select "Stop". After the engine has stopped, right click the engine again and select start.
Show the SQL for each of the steps below and answer any questions
1. Create a new login with the default database AptManager (remember you must be in Master)
2.Create a schema called Maint. (it is for contractors and others to view maintanence requests
3. Switch to the database AptManager and create a new user mapped to the login you just created with Maint as their default schema.
4.Create a view in the maint schema that shows a join of all the Maintanence Requests and Request Details where they have yet to be resolved--(where resolution date is null)
5. Right click on the Server and disconnect. Now reconnect and use SQL Server Login and log in with your new server login. Open the Databases in the object manager and open tables. Can you see any of the tables?
6. Open Views and in a query window select all from the view you created. Do you get results
To turn in
Turn in the code