Question: Write a script that (1) creates a login ID named Fall2022 with the password 12345678; (2) sets the default database for the login to the

Write a script that (1) creates a login ID named "Fall2022" with the password "12345678"; (2) sets the default database for the login to the AP database; (3) creates a user named "James" for the login; and (4) assigns the user to the PaymentEntry role you created in question 1.

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!

Using the Management Studio (do not write a query), create a login ID named "DBMSFall2022" with the password "Fall2022" and set the default database to the AP database. Then, grant the login ID...

Olmo, Incorporated, manufactures and sells two products: Product KO and Product H9. The annual production and sales of Product of KO is 900 units and of Product H9 is 900 units. The company has an...

Write a script for user maintenance. Write a script that will perform the following tasks: Prompt the system administrator for all valid input parameters Generate a menu to ask which task is needed...

Taunton's is an all-equity firm that has 151,000 shares of stock outstanding. The CFO is considering borrowing $233,000 at 7 percent interest to repurchase 20,000 shares. Ignoring taxes, what is the...

On June 1, 2012, Bere Ltd. pays $6,000 to Marla Insurance Corp. for a one-year insurance policy. Both companies have fiscal years ending December 31 and adjust their accounts annually. (a) Record the...

The General Eclectic Company manufactures an electric toaster. Sales of the toaster have increased steadily during the previous five years, and, because of a recently completed expansion program,...

d. Is the program accredited?

Rollins Publishing needs to decide what textbooks from the table at the top of the next column to publish. For each book, the maximum demand, fixed cost of publishing, variable cost, and selling...

Entries for Stock Dividends Senior Life Co. is an HMO for businesses in the Portland area. The following account balances appear on the balance sheet of Senior Life Co.: Common stock (230,000 shares...

Two graduate students are engaged to one another, and both are working on their master's theses-Michael in music education and Kristen in political science. Because both have incomes that are tied to...

i need help with this project using 1040 tax forms 2022 and schedules a, b, c, d, e. not amt needed to be calculated. all milage assume 62.5% rate

Case Study When Jean-Pierre Remy became the CEO of Pages Jaunes in 2009, the company was in trouble. As the market leader in the fast-dying French Yellow Pages industry, the company saw its print...

The managing director of Hermes Telecommunications plc is interested in corporate strategy. Hermes has invested a great deal of money in established a network which competes with that of Telecom UK,...

You are a manager of an HIM department and you want to track how many charts each of your employees scanned and indexed. This is the data you found. On Monday, John did 10 charts, Sue did 25 charts,...

For the equation y=-7x+3 answer the following questions: What are the x-intercept(s) written as ordered pair(s)? Note: If there is more than one write them separated by a comma (i.e.: (1,2), (3,4))....

2. Christmas shoppers that had purchased a gift in the first week of December were surveyed; fifty-seven said they purchased the gift in a store. Twenty-five said they shopped both online and in...

Page 12 72 Peavey Enterprises purchased a depreciable asset for $22.000 on April 1. Year 1 The depreciated using the straight-line method over its four-year useful life Assuming the asset asse value...

Vince, Inc. has developed and patented a new laser disc reading device that will be marketed internationally. Which of the following factors should Vince consider in pricing the device? I. Quality of...

What are authorization rules?

Describe the purpose of the JOIN command in relational algebra.

How can splitting a table improve performance?

On January 1, 2020, Solomon Crafts issued 60,000 8-year bonds with $1,000 face value. External markets value the bonds at $630,000 more than face value. The stated rate of interest on Solomon's bonds...

On January 1, 2020, Garner Hot Rods issued $2,000,000 of 6%, 10-year bonds. Interest is payable semiannually on June 30 and December 31. Required: What is the issue price if the bonds are sold to...

Scott Corp. provides contracted home staging services to real estate agencies and their clients. Scott issued the following bonds in the current year: a. 1,500 bonds with $1,000 face value which the...