SQLJocky (9/24/2014)
Does anyone know definitely what the maximum usable character length is for AD objects (users and security groups) to be added as Logins for SQL Server? We want to create longer and more descriptive AD security groups (SQL_ServerName_DBName_Function) but are concerned with running into issues with group names being too long and SQL allowing them to be added but truncating them so any queries run against them for auditing wouldn't pull out the full name.
SAM account name length is 20 characters so you'll be limited to this.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉