• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1295
  • Last Modified:

sid data type

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

thanks
0
anushahanna
Asked:
anushahanna
  • 4
  • 2
2 Solutions
 
Mohit VijayCommented:
It helps to manage uniqueness id when you have unlimited number of user. Its something bigger then GUID.
0
 
Mohit VijayCommented:
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
0
 
anushahannaAuthor Commented:
>>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!)
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
Mohit VijayCommented:
You are correct, but SID is more secure.
0
 
Mohit VijayCommented:
If you remember, initially table use int as key, after that bigint (autonumber), after that it increase the limit and become GUID etc.. similarly now for biggest database SID is secured and manageable. Isnt it?
0
 
anushahannaAuthor Commented:
OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.

Thanks again.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now