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

Which configuration changes in SQL Server require a restart?

By

SQL Server is a complex beast, with many configuration options that can range from...

Daily Coping 3 Mar 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Disabling Non-Clustered Indexes For Fun and Profit

By

One of the frequently quoted ETL best practices is to disable your non-clustered indexes...

Read the latest Blogs

Forums

How to update table partwithcompany column name company id by companyid for max

By ahmed_elbarbary.2010

How to update table partwithcompany column name company id by companyid for max partid...

Appttime add with duration how to get endtime please

By DBA.k

  Hoe to get appt_time+duration = end_time can you please help on this

SQL Sever becoming Non Responsive

By IT researcher

SQL  server 2008 R2 - express edition becomes non-responsive, whenever connection count crosses 12000....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers