Hi,
I currently have two databases (DEV & TEST) with the same users but
different owners. The TEST database is on a remote machine with 2
database users - USR1 & DBO. The DEV database is exactly the same.
However, when I create procedures etc the DEV database recognises the
owner as DBO and the TEST database USR1.
I have made USR1 an owner on DEV and I login using the correct
credentials. However it still is not recognising this when creating
procedures.
This is very frustrating when doing a SQL Compare as it thinks the
stored procs are different!
I have done a sp_changedbowner and this didn't work. There must be
another config value that need changing?
Any ideas?
Thanks.