Script to Change Stored Procedure Owner to DBO
This script will change the owner of the stored procedure to dbo. It must be run in the same database as the stored procedures.
2001-10-28
1,278 reads
Blogs
T-SQL Tuesday #125 – Unit testing databases – we need to do this!!
By HamishWatson
Welcome to the first April edition of T-SQL Tuesday. I’m honoured to be hosting...
T-SQL Tuesday Live–7 Apr 2020
By Steve Jones
Last week went a little crazy, and I learned something: don’t post a Zoom...
Getting Your dbatools Version–#SQLNewBlogger
By Steve Jones
Another post for me that is simple and hopefully serves as an example for...
Forums
MAXDOP and cost threshold for parallelism settings
Hi All, On one of our newly migrated sup-prod azure vm which is running...
Dial sbcglobal helpline for Customer Service
SBCGlobal Email Settings: If you are going to use Sbcglobal for your email applications...
How not to have sql to restart on the same node but failover on 1st failure in a
Hi, By default sql tries to restart on the same node in case of...
Ask SSC