Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,635 reads
Scripts
2008-08-01
843 reads
Quick table finder
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
751 reads
2008-07-29 (first published: 2008-06-08)
1,292 reads
Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-28 (first published: 2008-06-10)
845 reads
2008-07-23
484 reads
2008-07-23 (first published: 2008-06-05)
1,233 reads
2008-07-20
2,009 reads
2008-07-20
1,634 reads
2008-07-17
359 reads
Blogs
Learn about Modern Microsoft Apps in San Diego
By Steve Jones
I wrote about learning today for the editorial: I Can’t Make You Learn. I...
How To Deploy Fabric SQL and Azure SQL Databases with Azure DevOps
By ReviewMyDB
Fabric has CI/CD built in, but if you've tried to use it for database...
A New Word: Attriage
By Steve Jones
attriage – n. the state of having lost all control over how you feel...
Forums
ALAMAT BCA KCU TEBING TINGGI TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Jend. Sudirman No. 225-227-229-231, Badak Bejuang, Kec. Tebing Tinggi Kota,...
ALAMAT KANTOR BCA KCU KISARAN TLP/WA 08217555651
Hub Cs: 08217555651 Jl. Cokro Aminoto No.28, Kisaran Kota, Kec. Kota Kisaran Barat, Kabupaten...
ALAMAT BCA KCU PEMATANG SIANTAR TLP/WA 08217555651
TLP/CS 08217555651 Jl. Merdeka No.39, Proklamasi, Kec. Siantar Bar., Kota Pematang Siantar, Sumatera Utara...
Question of the Day
BIT_COUNT II
In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:
UserID UserPermissions 15 23 37 4 NULLWhat is returned when I run this code:
select bit_count(UserPermissions) as PermissionCount from dbo.UserPermission where UserID = 4;See possible answers