Just a quick post I should've done yesterday but I was recovering from SQL Saturday #48 in Columbia, SC, where I went to some really excellent sessions by some very smart experts. If you have not yet attended a SQL Saturday, or its been more than 1 month since you last did, SIGN UP NOW!
While searching the OBJECT_DEFINITION() of SQL Server system procedures I stumbled across the DEFAULT_DOMAIN() function in xp_grantlogin and xp_revokelogin. I couldn't find any information on it in Books Online, and it's a very simple, self-explanatory function, but it could be useful if you work in a multi-domain environment. It's also the kind of neat thing you can find by using this query:
SELECT OBJECT_SCHEMA_NAME([object_id]) object_schema, name
WHERE OBJECT_DEFINITION([object_id]) LIKE '%()%'
ORDER BY 1,2
I'll post some elaborations and enhancements to this query in a later post, but it will get you started exploring the functional SQL Server sea.
UPDATE: I goofed earlier and said SQL Saturday #46 was in Columbia. It's actually SQL Saturday #48, and SQL Saturday #46 was in Raleigh, NC.