fn_getfiledetails - a replacement for xp_getfiledetails

As the undocumented SQL Server 2000 function xp_getfiledetails is not existent any more in 2005 or later i needed a replacement...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2010-06-14 (first published: 2010-05-07)

3,627 reads

Blogs

I wrote about learning today for the editorial: I Can’t Make You Learn. I...

Fabric has CI/CD built in, but if you've tried to use it for database...

attriage – n. the state of having lost all control over how you feel...

Comments posted to this topic are about the item SSRS Reminded Me of the...

I have a need to execute a stored procedure and return the results to...

Title pretty much says it all - can this be done? I've tried several...

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;