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
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
Viewing 2 posts - 1 through 2 (of 2 total)
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy