Question: Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table and (1) create a login ID

Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table and

(1) create a login ID for each row in that consists of the administrators first and last name with no space between; (2) set a temporary password of temp for each login; (3) set the default database for the login to the MyGuitarShop database; (4) create a user for the login with the same name as the login; and (5) assign the user to the OrderEntry role.

This is what the Administrators table looks like:

Write a script that uses dynamic SQL and a cursor to loop

Results & Messages Admin|D EmailAddress Password FirstName LastName 2 2-aam@rmurayguitarshop.com admin@myguitarshop .com 6a718fbd768e2378b511f8249b5489940e9022 Admin User wie joel @murach .com 971e95957d3b74d70d79c20c94e9cd91b85f7aae Joel Murach mike @murach .com 5f2975c819cefc686282456aeae3a137bf896ee8 Mike Murach 123

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

2. Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table and (1) create a login ID for each row that consists of the administrators first and last...

Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table. For each administrator: Create a login ID that consists of the administrator s first and last...

Use Microsoft SQL Server Management Studio 17 to: Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table and ... (1) create a login ID for each row...

1. Write a script that uses dynamic SQL and a cursor to loop through each row of the Administrators table and (1) create a login ID for each row that consists of the administrators first and last...

write an sql query for the following questions 4. Write a script that uses two variables to store (1) the count of all of the instructors in the Instructors table and (2) the average annual salary...

Each of the scripts that you create in the following exercises should use the same general structure as the script presented in figure 1 3 - 1 in the book ( given as Appendix at end of this document,...

1. Write a script that: Creates a user-defined database role named OrderEntry in the MyGuitarShop database Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table Give...

Chapter 1 7 How to manage database security Exercises 1 . Write a script that creates a user - defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission...

1. Write a script that creates a user-defined database role named OrderEntry in the MyGuitarShop database. Give INSERT and UPDATE permission to the new role for the Orders and OrderItems table. Give...

Database Administration CHAPTER OBJECTIVES I Understand the need for and importance of database I ttno'illI the meaning of ACID transaction administralin - Learn the tour 1992 ANSI standard isolation...

1, Managers create ______ throughcommunication. meaning profits jobs organizational structure products and services Listening, Reading, and Writing LEARNING OUTCOME:5 2, In an organization, office...

You are required to select any TWO 2 print advertisements from either tourism industry or telco industry based in Malaysia from the local newspaper or magazine NO online ads cut them out and stick...

4 5 Highly diversified firms experience a diversification discount in the stock market because they Mulsple Croice 6 4 . 3 8 . 3 0 cannot intluence costa . cannot leverage financial economies. are...

Seved Help 14 Wisconsin Snowmobile Corp. is considering a switch to level production Cost efficiencies would occur under level production, and aftertax costs would decline by $31,500, but inventory...

3. Realize that trust will be measured almost exclusively in terms of reliability.

Compare the current team to the ideal team.

a. Do team members trust each other?