Hi,
Am using Copy database wizard to copy a database from one server to another
server (Both are SQL server 2000). After I specify the sysadmin user name an
d password for both source as well as destination server, i get the error sa
ying
"The name 'DatabaseName' was not found in the databases collection".
I checked the same database name in sysdatabases and it looks fine.
Now because of this error, am not able to copy any database.
What could be the problem?
Thanks
YogishOne of the solution I found was to change the database ownership by using SP
_CHANGEDBOWNER. I tried this, but it is still the same.
Has anybody faced this kind of situation?
Thanks
GYKsqlsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment