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,581 reads
Charles Hawkins
Random Number Generator
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)
582 reads
Stored Proc to List Columns for a Primary Key
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)
654 reads
Deduping Data in SQL Server 2005
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
12,997 reads
Better Script to Get SQL Server Port Number
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,023 reads
Blogs
Spark .NET - Spark ML TF-IDF
By Ed Elliott
Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...
Daily Coping 7 Jul 2020
By Steve Jones
I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...
Publish ADF from code to further environments
By Kamil
Struggling with #ADF deployment? adf_publish branch doesn’t suit your purposes? Don’t have skills with PowerShell? I have good...
Forums
Help needed in checking dates spans and status
Hello All, I have a requirement where we need to merge spans if the...
List of all OWNERS, not db_owner
How can I get a list of all database owners in an instance (not...
Document recovery procedure
Trying to document a process in an event of disaster and different reasons. In...
Ask SSC