Grant Permission to Specific objects(e.g. SP's)
Grant permissions to specific objects in Database using dynamic SQL.
2008-08-01 (first published: 2008-06-08)
2,634 reads
Scripts
2008-08-01
841 reads
Quick table finder
This little script will search for all matching tables on the SQL Server instance
2008-07-30 (first published: 2007-10-15)
749 reads
2008-07-29 (first published: 2008-06-08)
1,287 reads
Find the row with the most data
This script is a quick throw together that tells you which rows in a table have the most data
2008-07-28 (first published: 2008-06-10)
843 reads
2008-07-23
479 reads
2008-07-23 (first published: 2008-06-05)
1,226 reads
2008-07-20
2,007 reads
2008-07-20
1,618 reads
2008-07-17
349 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Cross-DB Ownership Chaining problem
We want to setup a gateway db to host stored procedures which use tables...
Lots of FKs
Comments posted to this topic are about the item Lots of FKs
Real-time On-prem SQL Server Data in Excel – Over the Internet
Comments posted to this topic are about the item Real-time On-prem SQL Server Data...
Question of the Day
Lots of FKs
In SQL Server 2025, what are the most outgoing and incoming FK references a table can have?
See possible answers