Question: can you write me a script to identify what object, database or job a user owns in a server?? i want one script everything in

can you write me a script to identify what object, database or job a user owns in a server?? i want one script everything in one script .
#sqlserver #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:

can you write me a script to identify what object , database and jobs each user owns in a sql server . #sql server #database #script

Q:

can you write me a script to identify what object each user owns in a database? what object, job and database ?? #sqlserver #database

Q:

TABLES FOR THE ASSIGNMENT CREATE TABLE CustomerService.Reps ( RepID int IDENTITY(1,1), CONSTRAINT PK_RepID PRIMARY KEY CLUSTERED (RepID), BusinessEntityID int not null, CONSTRAINT FK_BusinessEntityID...

Q:

PROJECT SCOPE [Instructions for what to include in this section: Define the scope of work that will be undertaken to provide the deliverable(s) mentioned in the Project Charter (PC). Craft this...

Q:

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...

Q:

Chapter 10 Business Process and Information Systems Development \"Jeff, we clean the clubhouse restrooms twice a day . . . in the morning before 7 and again just before lunch. We've been doing that...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

IT-111 Database Design and SQL 1 FINAL PROJECT Instructions: You are to create a database, primary keys, foreign keys, indexes, inserts, updates, views, and other SQL Select statements based on the...

Q:

Individual Assignment 3 Once again, we will be adding to our resume page. Please reuse the basic HTML 5 template and existing CSS to minimize the workload for you. For this assignment we are going to...

Q:

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

Q:

Property taxation is the main source of revenue for local authorities worldwide. Discuss in the form of a mini research essay using a topic relevant to Computer Applications to Real Estate and...

Q:

A firm produces according to the following production function: Q = K .25 L .75 . The price of K is $4 per unit, and the price of L is $6 per unit. a. What is the optimal capital/labor ratio? b....

Q:

Which of the following budgets is the comprehensive planning document for the entire organization? Answer Operating budget Master budget Financial budget Rolling budget

Q:

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

Q:

Write a buffer for a text message to your client who has rejected your media campaign due to the high costs involved and intends to explore other agencies.

Q:

The airline cant refund your money. The Conditions section on the back of your ticket states that there are no refunds for missed flights. Sometimes the airline makes exceptions, but only when life...

Q:

Write a buffer for a letter declining an invitation to speak at an industry associations annual fund-raising event. Show your appreciation for being asked.