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,271 reads
Blogs
Extended Events Misperceptions: Profiler is Easier, Part 2
I wrote a short blog post about the misperception that Profiler was easier than...
CREATE TABLE MyTable (Col1 CHARACTER VARYING (50))
If you read the title to this post and your first thought was That’s...
sys.xp_delete_files and ‘allow filesystem enumeration’: two new undocumented items in SQL Server 2019
sys.xp_delete_files and 'allow filesystem enumeration': two new undocumented items in SQL Server 2019… Continue...
Forums
DBCC showcontig help
Hello Team, I am using DMV dm_db_index_physical_status to replace the DBCC is sql server...
Difference between connection, session and instance
I am having trouble finding some clear definitions of these things. Are the following...
Creating a Node Table
Comments posted to this topic are about the item Creating a Node Table
Ask SSC