I'm probably being cynical, but.... You realise that he's 2nd on the 'most active posters in the last 30 days' scoreboard?

Sean Lange (10/7/2014)

---

Oh no. I assumed he must be working backwards....

I must re-read the Elric novels some time.

SkyBox (10/8/2014)

---

What about running a trace on setting up a new user with enforce password policy enabled? Wonder if it would pick up the logic for meeting the password...

SQL stores passwords hashed, so you can't reverse that and get the password back.

You can check the 'enforce policy' for logins and new passwords will have to match the domain...

Chapter 4: http://www.red-gate.com/community/books/accidental-dba

You're using the built in maintenance plan?

What tasks in what order?

What, exactly, does your index maintenance job do?

SSMS debugger, a product which contains more bugs than it will ever help to find.

I doubt most people use it because of the problems with it.

How are you seeing that it's a split update rather than an in-place?

cris651 (10/8/2014)

---

The db is in 'simple' recovery mode and I'm taking full daily backups. I see that I'm able to restore db at any point in the past (that I...

Snapshots can't...

http://www.acronymfinder.com/Information-Technology/LPAR.html

Rank Abbr.Meaning

LPAR Logical Partition (mainframes)

LPAR Logic for Programming Artificial Intelligence and Reasoning (Conference)

LPAR ...

r.morgan (10/7/2014)

---

thanks everyone for your replies. I certainly understand the risk if anything goes wrong with it as it currently stands, but really it's my management that bears the...

Jeff Moden (10/7/2014)

---

GilaMonster (10/7/2014)

---

The problem is that SQL 2000 has been out of support for years and there's a fair number of database consultants who won't work on SQL 2000...