Question: can you please write me a sql script that identify which user owns object , database or job in a database. i want one script

can you please write me a sql script that identify which user owns object , database or job in a database. i want one script not separate.
#sql server #database

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!

Q:

here is what my assignment 1 looks like with dummy data Purpose: To demonstrate the ability to identify functional dependencies and anomalies, and to apply normalization priniciples to nonrelational...

Q:

here is my dummy data from my assignment 1 Purpose: To demonstrate the ability to identify functional dependencies and anomalies, and to apply normalization priniciples to nonrelational tables...

Q:

Airline Company Case Study This document describes the data requirements for a fictional airline company, Anchor Air. In this case study, the company's key information requirements are identified....

Q:

Please Answer All The Questions Including the Bonus! USE [master] GO /****** Object: Database [AutoDealer3] Script Date: 2/21/2014 8:58:21 AM ******/ CREATE DATABASE [AutoDealer3] GO USE...

Q:

SECTION A: Answer ALL (30 marks) QUESTION 1 (a) Briefly describe three functions of Database Management Systems (DBMS). [6 marks] (b) Given the following attributes in the form of first...

Q:

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

Q:

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

Q:

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

Q:

Can you please help me with this case problem? AICPA Case Development Program. Case No. 2000-02: Recreation, Inc Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC....

Q:

Individual Final Project Create A Database System Purpose: To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and...

Q:

Let Y be the production possibility set for a single-output technology and V(y) denote the corresponding input requirements sets V(y) = {x n+: (y, - x) Y} Then Y is convex if and only if V(y) is a...

Q:

Blossom Company had the following transactions during the first week of May. Record the following transactions in general journal form. Identify each transaction by number. You may omit explanations...

Q:

Which of the following is true about U of A Global opportunities Eller students can apply to take their first semester of upper division courses abroad Eller students can use UA scholarships and...

Q:

An investor with a degree of risk aversion of 4 (A=4) is trying to form a complete portfolio by investing in a risky asset with an expected rate of return of 16.6% and a standard deviation of 25%,...

Q:

As customer service manager for Mama Mias frozen foods, respond to a letter from Jane Gogh, a student at Seaside College. Jane wrote expressing dissatisfaction with your Veggie Lasagne. She didnt ask...

Q:

The Board of Directors of City Library has added activities for the summer. These additional activities include an 8 a.m. story hour and a 6 p.m. childrens theater production.The childrens theater...

Q:

Roscoes Personalized Printing specializes in customized printing of items used for business advertisements. Jennifer Fairbanks designed an unusual calendar to be given to her customers during the...