Create User from a different DB in SQL Server

Question

Is there any way I can create a user on a database from the master DB(or any other DB)

IF EXISTS (SELECT 1 FROM   j_test.sys.database_principals WHERE  name = N'test_user') 
  DROP USER j_test.[test_user]; --doesnt't work.

Answer 1

You either need to change the context to that database or dynamically go there:

EXEC j_test..sp_executesql N'DROP USER test_user;';