November 19, 2003 at 3:51 pm
This is going to be a strange question. When you create a user account a SID is created in the sysxlogins table. If you delete that user, will that SID ever be used again?
Example. you add user "bob" (SQL Logon). you delete "bob". Will the SID that was associated with "bob" EVER be used again?
Thanks in advance,
November 19, 2003 at 6:25 pm
If you let the system generate the SID, it will be a GUID (as it is generated by NEWID()), so system-generated SIDs should never be the same. On the other hand, you can override this behavior by choosing the SID when you run sp_addlogin, which would permit the re-use of a SID (that's to allow you to move logins from one server to another).
--Jonathan
--Jonathan
November 20, 2003 at 7:14 am
Thanks for the help. You just gave me the answer I was needing.
Take care,
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply