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
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)
599 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)
676 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
13,127 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,034 reads
Blogs
Migrating from EverNote to Joplin
By Steve Jones
Recently I got a message that my Evernote subscription was going up. It’s been...
Using Data Masker on Chinese Surnames
By Steve Jones
A customer had a question recently on masking Chinese characters. I thought that was...
A New Word: Looseleft
By Steve Jones
looseleft – the feeling of loss upon finishing a good book, sensing the weight...
Forums
Database copy issue through - COPY DB WIZARD
I have a production server with SQL server 2016 version (13.0.5026.0) and a database...
Help with a SQL Unpivot
I am trying to use unpivot to extract some data, however, the results are...
how to de escalte a isolation level, and are there any implications.
hi, I have one nested transaction and want to deescalate to outer transaction's isolation/...
Ask SSC