SQL Server questions???

[Subhas]

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

[Greg D. Moore \(Strider\)]

"Subhas" <db************@yahoo.com> wrote in message
news:d7*************************@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]

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\)" <mo*****@greenms.com> wrote in message news:<k%*******************@twister.nyroc.rr.com>. ..

"Subhas" <db************@yahoo.com> wrote in message
news:d7*************************@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

[Greg D. Moore \(Strider\)]

"Subhas" <db************@yahoo.com> wrote in message
news:d7*************************@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\)" <mo*****@greenms.com> wrote in message

news:<k%*******************@twister.nyroc.rr.com>. ..

"Subhas" <db************@yahoo.com> wrote in message
news:d7*************************@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

[L. Bertolini]

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.

[L. Bertolini]

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.