The requested list could not be retrieved

The error message 'The requested list could not be retrieved ...' appears
when creating reports with Report Builder is due to missing SSRS Roles at the
SSRS Home (root) folder.

It is necessary to add the Active Directory security groups with the
'Browser' Role to the Home folder in order for users to use the Report Model
properly to retrieve lists when creating report filters or
sub-groups.

Drop All Tables

-- caution: rollout only

EXEC sp_MSforeachtable @command1 = 'DROP TABLE ?'

SUSER_SNAME (Transact-SQL)

Returns the login name associated with a security identification number (SID).

SUSER_SNAME ( [ server_user_sid ] )

Arguments ------- server_user_sid

Is the login security identification number. server_user_sid, which is optional, is varbinary(85). server_user_sid can be the security identification number of any SQL Server login or Microsoft Windows user or group. If server_user_sid is not specified, information about the current user is returned. If contains the word NULL, will return NULL.

Winword Replace Wildcard Characters

Metacharacter	Description	Example
?	Any single character	s?t finds "sat" and "set".
*	Any string of characters	s*d finds "sad" and "started".
@	One or more occurrences of the previous character or expression.	lo@t finds "lot" and "loot".
<	The beginning of a word	<(inter) finds "interesting" and "intercept", but not "splintered".
>	The end of a word	(in)> finds "in" and "within", but not "interesting".
[a]	One of the specified characters	w[io]n finds "win" and "won".
[A-Za-z]	Any single character in this range	[r-t]ight finds "right" and "sight". Ranges must be in ascending order.
[!A-Z]	Any single character except the characters in	t[!a-m]ck finds "tock" and "tuck", but not the range inside the brackets "tack" or "tick".
{1}	Exactly n occurrences of the previous character or expression.	fe{2}d finds "feed" but not "fed".
{2,}	At least n occurrences of the previous character or expression.	fe{1,}d finds "fed" and "feed"
{1,3}	From n to m occurrences of the previous character or expression	10{1,3} finds "10", "100", and "1000".
^13	Carriage Return
()	Pattern group ([A-Z])
\1	First Pattern group	\1 - finds first pattern group and appends a hyphen