This SP will give a listing of users blocking and being blocked in a tree formation (similar to explorer tree list). It uses a User defined function that recurses through the locking information gathered from sysprocesses. The listing only shows the Hostname (username) and the SPID.First create the User Defined Function (Part One) then create […]
2002-08-19
2,069 reads
What is Docker? Docker is a famous platform for building, shipping, and running container...
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Hello all, I am attempting to install the SSIS package into VS2019 CE. I've...
Hello experts, One of our developers tried to alter a view and reported to...
Hi, Kindly some one share the script or query to get the login information...
Ask SSC