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 and password for both source as well as destination server, i get the error saying
"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
Thank
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
Thank
GYKsqlsql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment