Personally I would simply have switched to simple mode, checkpoint, truncate the log (which should free considerable space).

Then back to full to have pit recovery. That way you don't...

sturner (7/20/2011)

---

set @URL = REPLACE(REPLACE(REPLACE(@URL,' ',' '+char(7)), char(7)+' ',''),char(7),'')

Here is a trick I use to turn all multiple spaces (2 or more..) into one space. Its handy for...

mtillman-921105 (7/20/2011)

---

Ninja's_RGR'us (7/20/2011)

---

This will replace all double spaces with a single...

I'll take a guess..

SELECT SUM(CASE WHEN Status = 'Sold' THEN QtySold + Qty ELSE 0 END) As Sold,

SUM(CASE WHEN Status = 'Available' THEN QtyAvailable + Qty ELSE 0 END) As...

allamiro (7/20/2011)

---

OK great thanks for the script it diffidently great

However when you said the default is a so does that mean I will have 2 traces running ...

The joys of html!

Don't...

This will replace all double spaces with a single space. ...

SELECT (ABS(CHECKSUM(NEWID())) % 100000 /* 0 to 99999 */) / 100000.0 FROM sys.tables

I don't have a solid fast solution, but this would get the job done, however un-performant like.

Select 'start'

while @@rowcount <> 0

begin

update table set column =...

sjimmo (7/20/2011)

---

I don't think I...

She stated...

halifaxdal (7/20/2011)

---

It is actually just one of the many DBs that went down. All the others, damaged perm or recovered already. I am just trying to work on this last...

halifaxdal (7/20/2011)

---

Ninja's_RGR'us (7/20/2011)

---

halifaxdal (7/20/2011)

---

not big at all AFAIK

I don;t know how much...

cfradenburg (7/20/2011)

---

I think I've found your master plan. Keep our points low by putting a tricky question up while increasing your own by replying...

halifaxdal (7/20/2011)

---

not big at all AFAIK

I don;t know how much data stored...