Found this in BOL:

A known issue in Windows Server 2003 might prevent the bad password count from resetting after the Account Lockout threshold has been reached. This could cause an...

You don't need to be in the master database to execute the ALTER LOGIN statement, I just tested that on one of my SQL test logins.

jrmtl (6/29/2009)

---

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

Jeff Moden (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

And that will work until the SQL Server 2000 system table "views", like sys.syscolumns, go away in a future version od SQL Server. They have...

Try taking the double quotes off of Month, ie datediff(MONTH,Fields!PrevExpDate.Value, Now)

Hey, Gail. With Gus it is now up to 5 individuals you now know that know "The Key, the Whole Key, and NOTHING but The Key!"

Jeff Moden (6/29/2009)

---

Paul White (6/29/2009)

---

Peso (6/29/2009)

---

I only have 92 column in my master.sys.columns.

This is because I have an edited very slim version of MASTER database.

This is not something common, but...

It should only access the partition where the data resides. Yo should be able to verify this by having SSMS show you the actual execution plan when running the...

I believe that you have to have Visual Studion 2005 Professional or better to debug stored procedures in SQL Server 2005. And yes, I have heard that they have...

Jeff Moden (6/28/2009)

---

Nah... not the word "correct"......

Michael Valentine Jones (6/28/2009)

---

I have a hard time understanding how agile development would work within the biggest trend in software development, outsourcing development to offshore teams that have little direct...

Grant Fritchey (6/28/2009)

---

RBarryYoung (6/28/2009)

---

Jack Corbett (6/28/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was...

RBarryYoung (6/28/2009)

---

Jack Corbett (6/28/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when...

GilaMonster (6/27/2009)

---

Didn't realise anyone else knew that mnemonic. I learnt it at university as an easy way...

GilaMonster (6/27/2009)

---

Lynn Pettis (6/27/2009)

---

Sounds like a plan to me. I couldn't, it's been so long I just barely remember...