Aliases can sometimes come in handy. The most obvious example is when you want to…
I would like to share a little tip form Books Online, that I found the other day. Sometimes it is needed to find out what my permissions are. A good function to use in that case is HAS_PERMS_BY_NAME. If for example I would like to find out what tables I have SELECT permissions on, I could run the following query:
SELECT HAS_PERMS_BY_NAME (QUOTENAME(SCHEMA_NAME(schema_id)) + ‘.’ + QUOTENAME(name), ‘OBJECT’, ‘SELECT’) AS have_select, * FROM sys.tables
Read more about HAS_PERMS_BY_NAME at http://msdn.microsoft.com/en-us/library/ms189802.aspx