Solved

sid data type

Posted on 2010-08-26
6
1,074 Views
Last Modified: 2012-05-10
what is the benefit for SQL Server to name SID in varbinary instead of varchar?

thanks
0
Comment
Question by:anushahanna
  • 4
  • 2
6 Comments
 
LVL 8

Accepted Solution

by:
Mohit Vijay earned 500 total points
ID: 33534722
It helps to manage uniqueness id when you have unlimited number of user. Its something bigger then GUID.
0
 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33534748
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33535011
>>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
Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 
LVL 8

Expert Comment

by:Mohit Vijay
ID: 33535028
You are correct, but SID is more secure.
0
 
LVL 8

Assisted Solution

by:Mohit Vijay
Mohit Vijay earned 500 total points
ID: 33535041
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
 
LVL 6

Author Comment

by:anushahanna
ID: 33535075
OK. Thanks for that VjSoft. That makes sense, in terms of more bigger IDs.

Thanks again.
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how the fundamental information of how to create a table.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now