Thanks for sharing that experience and resolution with us Perry.

Your assumptions are correct.

Scenario 1 You would restore full backup and then the Thursday differential (7am). Since you only do tran logs twice a day - you would lose...

Jack Corbett (4/16/2010)

---

Did 6.0 come out before or after the...

I don't think so. I think 6.0 is too...

Ouch. I think that is the sort of thing that I was seeing. Machine dependency with all of those solutions.

Well, I am trying to document...

Express Edition has always been labelled as Server 200x Express since inception in 2005 (SQL Server 2005 Express Edition).

Prior to that it was MSDE.

I believe whoever told you that there...

WayneS (4/16/2010)

---

Thanks. I was thinking about using this one (about 1/2 way down the page), but I figured that Steve would ask me...

Aha, got it to work (Server 2000).

Here is the SQL 6.5 version

if exists (select * from sysobjects where id = object_id('dbo.sp_who2') and sysstat & 0xf = 4)

drop procedure dbo.sp_who2

GO

CREATE PROCEDURE...

Those are one and the same.

SQL 2008 Express is SQL Server 2008 Express edition.

Steve Jones - Editor (4/16/2010)

---

I think you'll need NT 4 for this. It installed in W2K, but there were warnings, might be issues.

Where's the reference for it? I don't think...

Haha - funny...

It was undocumented in 6.5...

Ditto as the other two, just adding that the final Primary in your definition refers to the filegroup on which the clustered index was created.

Ok - this one is a stretch. Anybody have sp_who2 from sql 6.5?