Thx for your response ...

For some reason some process was looping and keeping the thread at 100%. After a server reboot all is fine since and we even increased the...

Ok will do ...thanks for your help

Actually I don't want to write my own Proc 🙂

I just want to keep it simple and leave it up to the system during off-hour time periods.

So basically just create...

thanks for your answer...

We have the standard ED, and our DB is around 8 GB.

I ran this command to verify the tables and their frag level and it produced...

Thanks for that ... it's clear now because the setup wasn't done properly as the named instances on both nodes were named the same thing.

Pardon my ignorance, but If I have two nodes with 2 IP's of course, I only need t create the database on the primary node correct ?

One node named...

Thanks for your response ...

The developer or designer of this database may have to check the primary key as it is not there on the tables and therefore causign duplicates...

ok fair enough ...

Thanks a bunch for your help !

I had to put NULL for the old password parameter,

how can i force a change when the user logs in , the equivalent of MUST_CHANGE in sql2005

I am trying to only reset a user's password so i can't put the old

This worked !

sp_password NULL, 'new_password', 'user'

How can i force the password to be changed at...

I guess we have to be logged in as SA

I have admin rights and I execute

exec sp_password 'password', 'user'

and it tells me that MYuser doesn't exist?

So Sorry I just realized that that particular Db is on a sql2000 server.nder it doesn't work 🙁

What is the exact syntax for sql2000?

soemthing like sp_changepassword

pardon my ignorance...:)

Even in Master it gives me the same error, is it really a syntax issue ?

Msg 170, Level 15, State 1, Line 1

Line 1: Incorrect syntax near 'LOGIN'.

very...

I need to reset urgently but nothing works 🙁

how can i check those user credentials... what is BOL ?

GO

ALTER LOGIN [xxx] WITH PASSWORD = 'xxxx' MUST_CHANGE

GO

Doesn't work either...

tahnsk for response !

it's a sql user for one of the db's