I logged in to my W2K system with a login name and a
password. I launched SQL Server 7 EM and created a
Database. SQL Server EM displays the
domain_name\my_user_name for the database OWNER on the
I created a New Database User in my New Database and
checked both public and db_owner Role memebership
In the Security folder I clicked on the Logins and
Selected my New User. I made sure the dafault database
for this login is my New Database and i have the Server
Administrators Server Role checkbox checked.
I launched our custom application and entered my New SQL
Server 7 User login and Password and created our tables.
Tables were created and the OWNER listed for the OWNER
column is 'dbo' and not the New User name i entered in our
Can some one tell me why i don't see the New User name i
entered for the login being listed under the OWNER column.