Viewing 2 posts - 1 through 2 (of 2 total)
I have to copy tables from SQL2K not owned by (default) dbo role to SQL2K5 using Transfer Object Task in SSIS. But (may be) as tables were not owned by...
June 6, 2007 at 6:01 am
#711067
To change the physical name, detach the database and rename. Then attach the database.
As far as I know you cannot change the logical name of a database.
Wilson
December 13, 2005 at 5:53 am
#609177