D
David Thielen
Hi;
This is on Sql Server 2005
I am copying a database from work to home. Both computers are
workstations on seperated domains (at home I have a Small Business
Server).
So I do a backup at work where the owner of the database is
WORKDOMAIN\david and restore it on my work system where I am the user
HOMEDOMAIN\david.
I have to do the restore as Overwrite the existing database because
otherwise it fails telling me that the backup file does not match the
system I am restoring to.
So I do the restore and get all the tables, data, etc. But when I go
to the database, Security, Users and then properties on dbo - the
radio button for Login name is checked - but the edit box is empty.
How do I set the user for this user/login?
thanks - dave
david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
Cubicle Wars - http://www.windwardreports.com/film.htm
This is on Sql Server 2005
I am copying a database from work to home. Both computers are
workstations on seperated domains (at home I have a Small Business
Server).
So I do a backup at work where the owner of the database is
WORKDOMAIN\david and restore it on my work system where I am the user
HOMEDOMAIN\david.
I have to do the restore as Overwrite the existing database because
otherwise it fails telling me that the backup file does not match the
system I am restoring to.
So I do the restore and get all the tables, data, etc. But when I go
to the database, Security, Users and then properties on dbo - the
radio button for Login name is checked - but the edit box is empty.
How do I set the user for this user/login?
thanks - dave
david@[email protected]
Windward Reports -- http://www.WindwardReports.com
me -- http://dave.thielen.com
Cubicle Wars - http://www.windwardreports.com/film.htm