I see discussions of this often enough that I think it would worth it for Microsoft to build some capability for this into the database engine.

It wouldn’t have to be...

You can't get it from the hashed password. A hash is one-way.

Has anyone started an "Are the posts on the 'Are the posted questions getting worse?' thread getting worse" thread yet?

Wouldn't 1,048,576 members be a MegaMember?

Use the @attachments parameter in xp_sendmail; you can lookup xp_sendmail in SQL Server 2000 Books Online.

You should post SQL Server 2000 questions in the SQL Server 2000 forumns.

select

[Date] = dateadd(year,(Ordinal_Date/1000)-1900,((Ordinal_Date%1000)-1)) ,

[Time_of_Day] = dateadd(ss,Second_of_Day,0)

from

( -- Test Data

select Ordinal_Date = 2008044, Second_of_Day = 55228

) a

Date ...

Just to complete the discussion, FULL OUTER JOIN was also supported in SQL 6.5

Just ran this in SQL 6.5:

select a.id,b.id

from

( select id...

Lynn Pettis (2/18/2009)

---

Michael Valentine Jones (2/18/2009)

---

Lynn Pettis (2/18/2009)

---

Adi Cohn (2/18/2009)

---

If I remember correctly, SQL Server did support left and right join using the old syntax (*= or =*), but it...

Lynn Pettis (2/18/2009)

---

Adi Cohn (2/18/2009)

---

If I remember correctly, SQL Server did support left and right join using the old syntax (*= or =*), but it didn’t support full outer join...

Steve Jones - Editor (2/18/2009)

---

Since this thread seems to be the most popular, a question:

What features would really help you "high posters" here at SSC? Changes to the forums? the...

Lynn Pettis (2/18/2009)

---

Adi Cohn (2/18/2009)

---

Michael Valentine Jones (2/18/2009)

---

I have to admit that I’m amazed that you...

jgrubb (2/18/2009)

I wouldn't say "clever" code. IIRC SQL 7 introduced the Ansi join. before that, *= was all you had. Myself, I still think where...

Sometimes there's just no good substitute for one-on-one, boot-to-butt communication.

I had an exchange like this with a developer recently.

Dev: I need a login created.

Me: Send me an email with Server...

*= is a syntax that is obsolete and should not be used. It is not allowed in SQL Server 2005. *= and =* should be replaced with left...

Derek Dongray (2/16/2009)

---

David Webb (2/13/2009)

---

Most of the DBA folk I have worked with came from non-computer science educational backgrounds. Our current DBA at my place of employment is a...