Advice requested : Storing SID String in SQL table

I would like to store a Windows NT Account SID in an SQL server table as a
SID String.

What is the maximum length of a SID String?
What is the maximum length of a SID byte[] array?

Is this information published anywhere?

Thanks
Russell Mangel
Las Vegas, NV

PS
I am just trying to avoid using overly large
column lengths in SQL 2005. I realize that
I could use VARBINARY(MAX) for
bytes, or VARCHAR(MAX) for SID
string.


.

Relevant Pages

  • RE: NT4 Migration
    ... My understanding is you want to restructure the NT4 domain into a AD ... I know your major concern is move SQL server 2000 to new domain. ... Basically if you enabled SID history feature in AD, ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • Re: NT > 2003 domain name changes
    ... Can't use the DTS option as it doesn't retain the SID, ... -restore database to SQL2K ... - cut out logins that do not apply to the database at hand ... >> windows authentication over to a new sql server on a new ...
    (microsoft.public.sqlserver.security)
  • RE: SQL server migration
    ... which authentication method did you use? ... Basically if you enabled SID history feature in AD, ... Migrated SQL Server to new domain. ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • RE: SQL server migration
    ... which authentication method did you use? ... Basically if you enabled SID history feature in AD, ... Migrated SQL Server to new domain. ... Detached all the user Database. ...
    (microsoft.public.windows.server.migration)
  • Domain Collapse. Sql permission question.
    ... Internally sql server uses SID of NT users to link them ... with sql logins. ... change users display name. ...
    (microsoft.public.sqlserver.server)