Tag Info

New answers tagged

2

You could assign the current context to a cookie then revert to that cookie when you desire to.


2

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) ...


2

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