Determine Users with Permission on an Object
This script will walk the hierarchical chain of users and roles to find users with permissions on an object.
2009-03-24 (first published: 2009-02-18)
1,589 reads
This script will walk the hierarchical chain of users and roles to find users with permissions on an object.
2009-03-24 (first published: 2009-02-18)
1,589 reads
Often the RAND() function is predictable based on the seed. This stored procedure generates a pretty good random integer because the seed itself is quite unpredictable. You can’t put this in a UDF since it is indeterminate due to the RAND and GETDATE() functions used.
2006-09-15 (first published: 2006-09-06)
600 reads
Stored procedure to return the list of columns of the primary key for a table. The name of the column for the result set is the name of the primary key for the table.
2006-09-14 (first published: 2006-09-07)
681 reads
One of the neatest T-SQL enhancements in SQL Server 2005 is the ROW_NUMBER() function. New author Charles Hawkins brings us an explanation of how you can use this function along with a Common Table Expression to remove duplicate data.
2006-02-07
13,150 reads
You don't have to try and decipher what instance you are running. The extended stored procedure xp_instance_regread does all the functionality of xp_regread and automatically knows which instance in the registry it should look at.
2003-06-06
1,038 reads
By Steve Jones
At the PASS Data Community Summit in 2024, Redgate launched Test Data Manager (TDM),...
By Rayis Imayev
(2024-Mar-16) I have been a big fan of using the Excel application for various tasks...
You might know the feeling: you’re writing code in a Notebook in Microsoft Fabric...
Hi All, We are seeing MSDTC transactions are blocking other sessions within sql server....
Hi All, Today, I came across a blocking issue from the application. A very...
Hi All, I have couple questions related to Ola Hallengren's maintenance script. If anyone...
How can I run SQL Agent with SQL Server Express 2022?
See possible answers