Getting username

Hello there

For short time I've been added to sysadmin group

>From now on when i create new database it get DB owner

And when use SELECT User i still get my name and not dbo.

That is fine. The question is how can i do that?


.

Relevant Pages

  • Re: Getting username
    ... > For short time I've been added to sysadmin group ... database will be owned by your login when you create the database. ... change the database owner after creation using sp_changedbowner. ... Sysadmin role members are mapped to the 'dbo' user in all databases so this ...
    (microsoft.public.sqlserver.security)
  • Show owner of database
    ... owner of a specific database for MSSQL2000? ... I want to make a script to ... Prev by Date: ...
    (comp.databases.ms-sqlserver)
  • Re: SQL 2005 Express-Database does not have a valid owner?
    ... That means that the database's owner is MYDOMAIN\MyUserName ... My design machine is running Windows XP Pro. ... database diagram. ... Database diagram support objects cannot be installed because this ...
    (microsoft.public.sqlserver.security)
  • Re: conflicting object names in sql server 2000
    ... The owner of the object will depend on the user ... On the local database server when it does the select * from ... she must specify the owner: ...
    (microsoft.public.sqlserver.server)
  • Re: unknown database owner
    ... cleared for the 'Admin' user. ... the "owner is unknown" (you described ... An old database, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.security)