Get DBObjects with Specified Owner

A database can have objects with multiple owners. The script will give you the list of all the TABLES, VIEWS and PROCEDURES having the specified owner. Just input the owner name and it will give you the list of all the Objects with that owner. This scope of the script is limited to the TABLES, […]

2007-06-21 (first published: )

278 reads

Blogs

Reflection on Talking at SQLSaturday Charlotte About Mental Health

By

On December 7, I did a session on mental illness and mental health problems...

A guide to acronyms, abbreviations, and other technical terms

By

Here’s a list of some technical terms, acronyms, and abbreviations you may have heard,...

T-SQL Tuesday #121: Gifts received for this year

By

At the end of 2019, Mala (b|t) invites us to write about the gifts we’ve...

Read the latest Blogs

Forums

Read only node consistency

By tcroninlifepoint

I realize this is a reach, users stating that some of their data is...

Script Task - use DataTable for performance improvements?

By DinoRS

Hi SSC, I have this Script Task which will make quite a few reebars...

Probably Invalid Parameters Email Failure

By clarmatt73

We have a job which runs throughout the day which sends emails out if...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers