A user on one of the client machines is trying to open a file using SQL Management studio but he gets access denied error message.
He can connect to any of the servers with his credentials and execute queries or do any DDL
or DML operations, though.
An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs).
Being someone who is always looking for alternatives to "work your data", I came across this …