Max Length of a SQL User ID

Does anyone know the maximum length allowed for a SQL User ID in SQL 2000?
ThanksHello,
SQL Server login's maximum size is 128 characters. You can determine it's
size by examine sysxlogins table in master database. Look for "name"
attribute in sysxlogins table and check it's "size" property.
Regards,
Tomislav Kralj
"Sarah Kingswell" <skingswell@.xonitek.co.uk> wrote in message
news:%23rvzXCUKFHA.2648@.TK2MSFTNGP14.phx.gbl...
> Does anyone know the maximum length allowed for a SQL User ID in SQL 2000?
> Thanks
>|||Sarah,
Are you talking about sysusers.uid? That is a smallint, so the max value
for that column would be 32767.
If you are talking about sysusers.name then the max length is 256, or
128 characters as its Unicode.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Sarah Kingswell wrote:
> Does anyone know the maximum length allowed for a SQL User ID in SQL 2000?
> Thanks
>