No, if you change mine to partition by GroupName, it doesn't get the desired end result. It needs to be the way I wrote it to comply with the...

Nah. The only reason I was asking about edition is because Workgroup doesn't natively support SSIS, and won't run jobs for it. Was just checking for that possibility.

I would guess that companies where disaster recovery and business continuity are more critical probably have more formal procedures. For example, I would certainly hope that a hospital has...

Jeffrey Williams (6/17/2009)

---

GSquared (6/17/2009)

---

I used Cache about 5 years ago, for one project. My main issue with it was the nearly complete lack of tools for building and managing...

Randy has the commands right, but you'll have to drop the existing primary key first.

Jeffrey Williams (6/17/2009)

---

GSquared (6/17/2009)

---

Actually, some of the uses I've seen for Cache (http://www.intersystems.com/cache/) are quite functional. It's a pain to work with, at least what little I've done and...

You're welcome. Glad we could help.

You don't need to reboot. Just restart the SQL service. You can do that from Management Studio, and it's a lot faster...

OLE Automation of Office is usually (almost always) messy. Has a tendency to do things like leave multiple copies of Excel running in the background (you can find them...

Trace ID 3 is the problem, as you found. It's set to not "roll over files", so it's going to just keep adding them forever.

You can stop the trace,...

I don't really have a template or written policy. Recovery is generally going to be dependent on what makes it necessary in the first place.

Some of my databases can...

You could simplify the system tremendously by having tables named "CurrentMonth", "Prior1Month", "Prior2Month", ..., "ReallyOld", or something like that.

Dynamically building tables and rebuilding the view is going to be more...

So far as I know, if you have a license for SQL 2008, you can use it for a license for the same or a lesser edition license for 2005....

You're welcome. Let me know if it does what you need.

Here's how I'd write the update. You'd have to test on a volume of data to see whether it's enough better to be worth it.

;with CTE as

(select SpecCode,

row_number()...

Why does it need Office installed? Is it using OLE Automation on Excel or something?

I generally wouldn't be inclined to install Office on a server, but only because of...