From BOL:

sp_password [ [ @old = ] 'old_password' , ]

{ [ @new =] 'new_password' }

[ , [ @loginame = ]...

I'll keep that in mind as we move more reports to RS. It is info that will probably come in handy.

Well, I don't do much with RS at the moment, but what I...

GSquared (6/29/2009)

---

Lynn Pettis (6/29/2009)

---

If I remember the Modeling class at the TDWI conference a couple of years ago, 6NF is used to eliminate nulls being stored in a database. ...

GSquared (6/29/2009)

---

I guess it says something about our geekiness that our "water cooler" conversation has to be policed periodically for overly technical matter. This bit about normal forms says...

If I remember the Modeling class at the TDWI conference a couple of years ago, 6NF is used to eliminate nulls being stored in a database. Also results in...

Have you tried changing the password using the GUI tools?

Have you set the max memory for the SQL instances? If not, each instance will try to use all available memory, starving your OS.

Here is another solution:

select

t1.id,

t1.date,

datediff(dd,t2.date, t1.date)

from

@tbl t1

left outer join @tbl t2

...

mandirkumar (6/29/2009)

---

Hi All

I need a successive date difference for consecutive rows. Means second row will get (2nd rowdate-1st row date)

and third row wil get (3rd row date- 2nd row date)....

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)