Professional Web Applications Themes

create data with "sa" owner - Microsoft SQL / MS SQL Server

Hi, Could anyone help me create database with "sa" owner. When I login as "Administrator" in win2000 environment, the newly created data has owner as "domain/Administrator" not "sa" Thanks in Advance, Lam...

  1. #1

    Default create data with "sa" owner

    Hi,
    Could anyone help me create database with "sa" owner. When
    I login as "Administrator" in win2000 environment, the
    newly created data has owner as "domain/Administrator"
    not "sa"

    Thanks in Advance,
    Lam

    LamP Guest

  2. #2

    Default create data with "sa" owner

    use sp_changedbowner to change the database owner to sa.
    When creating a database the database owner will reflect
    the login used when creating the database. If you want a
    database to have the sa as owner, you must login as the
    sa and create the database. This is different to using a
    login that is a system administrator for SQL Server.

    Mark Baekdal
    dbghost.com
     
    When 
    mark Guest

Similar Threads

  1. Replies: 1
    Last Post: April 24th, 01:27 PM
  2. CFINPUT type="radio" w/ "value" requires "label"
    By Iceborer in forum Macromedia ColdFusion
    Replies: 2
    Last Post: February 21st, 06:16 PM
  3. Replies: 1
    Last Post: July 20th, 08:30 AM
  4. "Start" "Program" "Menu" list is empty
    By Pete in forum Windows XP/2000/ME
    Replies: 2
    Last Post: July 10th, 10:42 PM
  5. "Owner" : Question rephrased: Help
    By Bruce Chambers in forum Windows Setup, Administration & Security
    Replies: 1
    Last Post: July 5th, 11:56 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139