You can't use a variable as the source of a table name in SQL: you would have to create a string containing the full SQL satement and then execute it:
SET @ScndDB ='[Theorem_Analytics_database].dbo.User_Master';
DECLARE @Command VARCHAR(MAX)
SET @Command='SELECT * FROM ' +@ScndDB
EXEC @Command