Is the file you want to delete in the Primary filegroup?

You can restore a backup of a SQL 2000 database to a SQL 2008 server.

The application is using server side cursors. There is probably no good reason for this, so you should talk to the software vendor about it.

YOu might want to read this:

http://msdn.microsoft.com/en-us/library/aa905893(SQL.80).aspx

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