New answers tagged logins
You could assign the current context to a cookie then revert to that cookie when you desire to.
As pointed above by Jeremy, permissions can almost always be found on the corresponding reference document within Books Online for SQL Server. On these reference documents, there is typically a section titled Permissions (typically towards the bottom of the document) which contains your desired data. CREATE LOGIN (copied directly from the reference) ...
For the record, the SQL Server 2012 hash format is: 0x200<4 byte salt><hash result> where the hash result is essentially: HASHBYTES('SHA2_512', CONVERT(VARBINARY,N'[password]') + CAST(0x[salt] AS BINARY(4))) SQL Server 2005 to 2008 R2 are identical except they use SHA-1 instead of SHA-512. Some reasons NOT to use the previously hashed ...
Top 50 recent answers are included