Even if I put a new GO before the CREATE USER, I can't use the same variables, right? I'll have to again create the variables, set their values again which...

I need the USE statement so that the user is created in the mentioned database. If I remove GO, will the USE statement work?

Regards.

/************************

** Create command to create Logins (Server Principal) and Users (Database Principal)

**********************************/

DECLARE @defaultDatabase VARCHAR(50)

SET @defaultDatabase = 'enginedb2'

DECLARE @engineDboLogin VARCHAR(50)

SET @engineDboLogin = 'Dengine_vj'

DECLARE @engineDboUser VARCHAR(50)

SET @engineDboUser = 'Dengine_vj'

DECLARE

Its not huge. It has around 100 tables but only around 9-10 have data.

Regards.