Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Owner not DBO when Importing in SQL 2000 EM
1 view
Skip to first unread message
tga...@gmail.com
Dec 19, 2007, 3:50:28 PM12/19/07
to
In SQL Server 2000 Enterprise Manager, when I import tables to a
database in which I have db_owner rights, the imported table's owner
defaults to my user_name rather than DBO. When I do the same import
to a server to which I have SA rights, the owner does default to
DBO.
database in which I have db_owner rights, the imported table's owner
defaults to my user_name rather than DBO. When I do the same import
to a server to which I have SA rights, the owner does default to
DBO.
I assume this is the expected behavior but in my case I would rather
have the owner default to DBO. Is there any way to change my
security, aside from getting SA rights, to do this?
0 new messages