sp_depends

Use this script to find the Stored Procedures which are referencing the table passed as argument from all databases on the server.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2013-08-12 (first published: 2013-08-02)

1,129 reads

Blogs

“Don’t aim to have others like you; aim to have them respect you.” –...

Many years ago, before I joined Oracle, I was working on a major modernisation...

If you work with data pipelines, SQL, notebooks, or machine learning models, a Mac...

Comments posted to this topic are about the item SQL Art, Part 4: Happy...

WA:08218154393 Jl. Palmerah Barat No.38 A, RT.2/RW.3, Grogol Utara, Kec. Kebayoran Lama, Kota Jakarta...

WA:08218154393 Jl. RC. Veteran. 9, dan No.9A, RT.9/RW.3, Bintaro, Kec. Pesanggrahan, Kota Jakarta Selatan,...

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37

What is returned when I run this code:

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 3;