blogs.conchango.com

Browse by Tags

• Common Table Expression
• List of dates
• Microsoft
• SQL

• SQL Server 2005: View all permissions (2) - Explode the roles!

  Two days ago I posted a blog entry here that showed how the following SQL statement: select dp.NAME AS principal_name, dp.type_desc AS principal_type_desc, o.NAME AS object_name , p.permission_name, p.state_desc AS permission_state_desc from sys.database_permissions Read More... Posted 09 February 2007 23:54 by jamie.thomson | 29 Comments Filed under: SQL Server 2005, SQL Server, Microsoft, T-SQL

• SQL Server 2005: View all permissions

  Today I was asked how one can query the server to list out all permissions that a principal has on all the securables in a SQL Server database. After 10 mins of searching through BOL I came up with the following that seems to work quite well: 1 select Read More... Posted 09 February 2007 00:38 by jamie.thomson | 9 Comments Filed under: SQL Server 2005, SQL Server, Microsoft, T-SQL

• T-SQL: Generate a list of dates

  Sometimes we can be working and we write or find a ridiculously simple bit of code that we know will be useful in the future, then we just go ahead and plain forget all about it. When I find such stuff I like to stick it on my blog so that I know where Read More... Posted 11 January 2007 22:44 by jamie.thomson | 18 Comments Filed under: SQL Server 2005, SQL Server, SQL, Common Table Expression, T-SQL, List of dates