AARRRGGGG!!!

When will people learn to read???

exec sp_password @new = 'password', @loginname = 'username'

Krasavita (6/29/2009)

---

It means that you aren't properly managing the size of your database files more or less. Your database files are set to autogrow to prevent the database from running...

How about a single XML...

No,...

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