I am trying to copy a database within the same SQL Server instance, and I keep getting the message "Specified owner name 'donationstreet' either does not exist or you do not have permission to use it". The owner name does exist, and I am logged in as the sytem administrator. Any clues?

Have you tried using BACKUP/RESTORE ?

This is by far the simplest way to move a DB

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"alCorwin" <anonymous (AT) discussions (DOT) microsoft.com> wrote

not exist or you do not have permission to use it". The owner name does
exist, and I am logged in as the sytem administrator. Any clues?

A BAckup takes a copy of the database as a whole. If it's in the DB its in
the backup

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"alCorwin" <anonymous (AT) discussions (DOT) microsoft.com> wrote