Tag: object ownership

SQL Server insights from 25+ years in the field

Performance tips, security advisories, health check findings, and industry analysis. Practical, technically accurate, no fluff.

15 May 2018 · 5 min read

Script to change ALL Database Objects back to dbo

Wrong schema ownership breaks vendor upgrades and migrations. Use this script to reassign all SQL Server database objects back to dbo quickly and reliably.

Read article →
15 May 2018 · 6 min read

How to update all objects in a table to DBO

Fix broken SQL Server permission chains by transferring all object ownership to DBO. Covers sp_changeobjectowner, ALTER AUTHORIZATION and production gotchas.

Read article →

SQL Server insights, monthly.

Performance tips, security advisories, and industry analysis. No fluff, no spam.