<div>
Biggest benefit is:<br />
<br />
When you are moving SQL Server logins from one server to another and you want the logins to have the same SID between servers
</div>


Biggest benefit is:

When you are moving SQL Server logins from one server to another and you want the logins to have the same SID between servers

<div>
&gt;&gt;It helps to manage uniqueness id when you have unlimited number of user<br />
<br />
varchar can take care of this, too, right? especially with 85 characters. (credit card is only 16 digits, and we trust it!)
</div>


>>It helps to manage uniqueness id when you have unlimited number of user

varchar can take care of this, too, right? especially with 85 characters. (credit card is only 16 digits, and we trust it!)

<div>
You are correct, but SID is more secure.
</div>


<div>
OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.<br />
<br />
Thanks again.
</div>


OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.

Thanks again.

<div>
<div class="content wysiwyg-content">
what is the benefit for SQL Server to name SID in varbinary instead of varchar?<br />
<br />
thanks
</div>
</div>


what is the benefit for SQL Server to name SID in varbinary instead of varchar?

thanks

sid data type

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.