Technical Article

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, […]

You rated this post out of 5. Change rating

2007-06-21 (first published: )

282 reads

Blogs

A Study in SQL Server Ad hoc Query Plans

By

A Study in SQL Server Ad hoc Query Plans ...

Friday Flyway Tips–Flyway Parameters

By

Flyway is a command line tool with lots of options and parameters. Working with...

Read the latest Blogs

Forums

table with varcahar(max)

By sqlguy80

Gurus, there is a table which is very slow to query , it has...

Query goes crazy.

By Robert-378556

Hi. I have a query that returns few rows (out of 7 table join,...

Migration from Sybase SAP SQL Anywhere to SQL Server 2022

By Stewart "Arturius" Campbell

We are working on a project to migrate a client from a version of...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers