Viewing 15 posts - 1 through 15 (of 35 total)
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...
August 4, 2010 at 8:24 am
Ok will do ...thanks for your help
July 13, 2010 at 12:42 pm
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...
July 13, 2010 at 11:10 am
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...
July 13, 2010 at 9:21 am
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.
July 9, 2009 at 11:16 am
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...
July 3, 2009 at 10:01 am
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...
June 30, 2009 at 11:46 am
ok fair enough ...
Thanks a bunch for your help !
June 29, 2009 at 11:33 am
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
June 29, 2009 at 11:21 am
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...
June 29, 2009 at 11:14 am
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?
June 29, 2009 at 10:49 am
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
June 29, 2009 at 10:16 am
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'.
June 29, 2009 at 9:37 am
I need to reset urgently but nothing works 🙁
how can i check those user credentials... what is BOL ?
ALTER LOGIN [xxx] WITH PASSWORD = 'xxxx' MUST_CHANGE
Doesn't work either...
June 29, 2009 at 9:21 am
tahnsk for response !
it's a sql user for one of the db's
June 29, 2009 at 9:10 am