change Login Name

I just create a new DB under SQL 2000 and the Login Name is my network id
How can i change this to be SA like it should beCan you just disconnect the server in Enterprise Manager, then re-register
the server selecting SQL Server Authentication, and using the username 'sa'
"Mike" <csharpcoder@.sbcglobal.net> wrote in message
news:eqMH7O05DHA.1672@.TK2MSFTNGP12.phx.gbl...

quote:

---

> I just create a new DB under SQL 2000 and the Login Name is my network id
> How can i change this to be SA like it should be
>
>

---

|||no, that don't work, it is still my name under the Login Name, i need it to
be sa
"Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
news:uRIL2R05DHA.2416@.TK2MSFTNGP10.phx.gbl...

quote:

---

> Can you just disconnect the server in Enterprise Manager, then re-register
> the server selecting SQL Server Authentication, and using the username

---

'sa'

quote:

---

> "Mike" <csharpcoder@.sbcglobal.net> wrote in message
> news:eqMH7O05DHA.1672@.TK2MSFTNGP12.phx.gbl...
id[QUOTE]
>

---

|||So if you look at the Users list, the Name says sa, and the Login Name is
your user name? That sounds a bit strange. I know that if you try and log
in as 'sa', and get the password wrong, then SQL Server will try and log you
on using integrated login without you knowing. I always thought that sa
couldn't be an integrated login.
"Mike" <csharpcoder@.sbcglobal.net> wrote in message
news:eKiSpY05DHA.2580@.TK2MSFTNGP11.phx.gbl...

quote:

---

> no, that don't work, it is still my name under the Login Name, i need it

---

to

quote:

---

> be sa
> "Ryan Breakspear" <r.breakspear@.removespamfdsltd.co.uk> wrote in message
> news:uRIL2R05DHA.2416@.TK2MSFTNGP10.phx.gbl...
re-register[QUOTE]
> 'sa'
> id
>

---

|||Use the sp_changedbowner stored procedure. It is documented in Books on
Line.
Rand
This posting is provided "as is" with no warranties and confers no rights.