Timeline for A query that lists all mapped users for a given login
Current License: CC BY-SA 4.0
6 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 26, 2021 at 22:26 | history | edited | Aaron Bertrand | CC BY-SA 4.0 |
Address collation issues and added a method without FOR XML PATH
|
| Feb 24, 2016 at 20:35 | history | edited | Aaron Bertrand | CC BY-SA 3.0 |
added 50 characters in body
|
| Oct 31, 2014 at 18:19 | comment | added | Aaron Bertrand | @MichaelJSwart Ah yes, I've come across this before when databases have different collations (some metadata columns use the server collation but others inherit the database collation). I hope the only people that really ever burns are those that insist on using wacky characters in entity names that are only supported in some obscure collation... | |
| Oct 31, 2014 at 16:45 | comment | added | Michael J Swart | interesting note, I had to add explicit collations to p.name and p.default_schema_name columns for the union all to work properly | |
| Oct 31, 2014 at 16:39 | vote | accept | Michael J Swart | ||
| Oct 31, 2014 at 16:18 | history | answered | Aaron Bertrand | CC BY-SA 3.0 |