sp_helpdb

How to output datafiles location using sp_helpdb?

This is a quick way of outputting the location of your database files/dbsize/date created on your instance.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(4)

You rated this post out of 5. Change rating

2010-07-02 (first published: 2010-06-06)

1,375 reads

A cryptic message, a book cipher hidden in art provenance records, and a trail...

A customer was trying to compare two tables and capture a state as a...

When I'm looking at a query, I bet it's bad if I see... a...

WA:0821-4447-7715 Jl. Jenderal Ahmad Yani No.40, Cikalong, Sidareja, Kec. Sidareja, Kabupaten Cilacap, Jawa Tengah...

WA:0821-4447-7715 Jl. Yos Sudarso No.27, Lemahwungkuk, Kec. Lemahwungkuk, Kota Cirebon, Jawa Barat 45111

Comments posted to this topic are about the item BIT_COUNT II

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

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

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