Richard Douglas – SQL Server Professional

Earlier today I was asked to elevate the permissions of a user who already had read only access to a database so they would be able to see stored procedures and other programmable objects it’s something that comes up every so often so worth while writing a few lines as it will undoubtedly help somebody out. [...]