Hi Folks,
I am a newbie when it comes to SQL Server 2000 and have a Sybase
background. How can I reset my sa password in MSSQL like we do it in
the runserver file(-p) in sybase??? Also, can I configure replication
using the standard edition of MSSQL server????

Thanks

Regards

dba_sybase2003

"Subhas" <dba_sybase2003@yahoo.com> wrote in message
news:d7ca327.0310211356.5aefe10b@posting.google.co m...
> Hi Folks,
> I am a newbie when it comes to SQL Server 2000 and have a Sybase
> background. How can I reset my sa password in MSSQL like we do it in
> the runserver file(-p) in sybase???


sp_password


> Also, can I configure replication
> using the standard edition of MSSQL server????
>

Yes.


> Thanks
>
> Regards
>
> dba_sybase2003

Thank you for your replies. I was told earlier that standard license
of MSSQL does not come with replication enabled and had also told me
to get enterprise license if we wanted to implement replication. I
hope I am making sense. We just moved from Sybase to MSSQL and am
totally somewhat with the product. Also, can we spread the data in
tables or multiple tables across drives with filegoups just like we do
with segments in sybase???? Thanks for replying.

Regards

dba_sybase

"Greg D. Moore \(Strider\)" <mooregr@greenms.com> wrote in message news:<k%ilb.41301$Sc7.21708@twister.nyroc.rr.com>. ..
> "Subhas" <dba_sybase2003@yahoo.com> wrote in message
> news:d7ca327.0310211356.5aefe10b@posting.google.co m...
> > Hi Folks,
> > I am a newbie when it comes to SQL Server 2000 and have a Sybase
> > background. How can I reset my sa password in MSSQL like we do it in
> > the runserver file(-p) in sybase???
>
>
> sp_password
>
>
> > Also, can I configure replication
> > using the standard edition of MSSQL server????
> >
>
> Yes.
>
>
> > Thanks
> >
> > Regards
> >
> > dba_sybase2003

"Subhas" <dba_sybase2003@yahoo.com> wrote in message
news:d7ca327.0310220530.4acf7635@posting.google.co m...
> Thank you for your replies. I was told earlier that standard license
> of MSSQL does not come with replication enabled and had also told me
> to get enterprise license if we wanted to implement replication. I
> hope I am making sense. We just moved from Sybase to MSSQL and am
> totally somewhat with the product. Also, can we spread the data in
> tables or multiple tables across drives with filegoups just like we do
> with segments in sybase???? Thanks for replying.
>

You do NOT need Enterprise for replication. That I can speak from
experience on.

And yes, you can use filegroups with MS SQL.

First "best" thing to do from a performance POV is move your log file to a
separate physical drive. After that you can start playing around with
filegroups, etc. They can be useful and handy if you know what you're doing
and use them for their proper purposes.


> Regards
>
> dba_sybase
>
> "Greg D. Moore \(Strider\)" <mooregr@greenms.com> wrote in message
news:<k%ilb.41301$Sc7.21708@twister.nyroc.rr.com>. ..
> > "Subhas" <dba_sybase2003@yahoo.com> wrote in message
> > news:d7ca327.0310211356.5aefe10b@posting.google.co m...
> > > Hi Folks,
> > > I am a newbie when it comes to SQL Server 2000 and have a Sybase
> > > background. How can I reset my sa password in MSSQL like we do it in
> > > the runserver file(-p) in sybase???
> >
> >
> > sp_password
> >
> >
> > > Also, can I configure replication
> > > using the standard edition of MSSQL server????
> > >
> >
> > Yes.
> >
> >
> > > Thanks
> > >
> > > Regards
> > >
> > > dba_sybase2003

Subhas wrote:

>How can I reset my sa password in MSSQL like we do it in
>the runserver file(-p) in sybase???
>

I'm not sure, but try starting the "Services" application,
right click on your MSSQL service, choose "Properties",
and try adding the "-p" to the "Path to executable" value.

>