Hi Robert,

I get the next error in the windows event log after execute 'Copy Database Wizard':

"Event Name: OnError

Message: ERROR : errorCode=-1073548784 description=Executing the query "sys.sp_addrolemember @rolename = N'MyRole', @m..." failed with the following error: "The role 'MyRole' does not exist in the current database.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

..."

The role script is:

CREATE ROLE [MyRole] AUTHORIZATION [dbo]

GO

And the user script is:

CREATE USER [MyUser] FOR LOGIN [MyUser] WITH DEFAULT_SCHEMA=[dbo]

GO

EXEC dbo.sp_addrolemember @rolename=N'MyRole', @membername=N'MyUser'

GO