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...
> 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...
> Can 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...
> > 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
> >
> >
> >
>|||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...
> 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...
> > Can 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...
> > > 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
> > >
> > >
> > >
> >
> >
>|||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.