I'd be curious to see if it's really a lack of ALTER SCHEMA that's the
culprit. Are you sure that the only thing you are varying to make it
work is ALTER SCHEMA?
This looks like a lack of access to the 'Sources' table, which can
happen if the user that creates the table is missing certain
I think what desmaj said makes a good point. Actually the Source table/
mapper indeed was created by someone else, and I just used Attach
database to attach the mdf file and log file to the server.
But how am I going to deal with this though? should I go ahead and use
SA's account and create a