Just send a mail to santa...

old backup of the Vm machine (assuming virtual env.)?

Any chance you have another system db corrupt that could cause this error?... just a hunch and maybe this could lead somewhere.

Hmm, I guess I chose the wrong person to quote. I merely intended to further explain "our" point of view :w00t:.

bulbanos (2/9/2011)

---

doodlingdba (2/9/2011)

---

thanks for the response. i'm using two different tables because visually that's what the user wants.

I managed to get this working in the end though! Basically the same...

franck.maton (2/9/2011)

---

Hello,

We're planning to implement a brand new SQL server 2008 R2 architecture. But I'm not sure of myself about SQL features (SSAS, SSRS, SSIS).

I work in a big society...

OR assuming that you don't have 1 000 000 sales man.

Use 2 table objects on the report. 1 filters top 5 asc, then other one desc.

Then in your sp...

Grant Fritchey (2/9/2011)

---

I suppose on pretty slow systems or off hours that makes sense to try. But on a reasonably heavily used system... you better be very quick with the...

GilaMonster (2/9/2011)

---

If it's run soon enough,...

I guess what apex means is that as long as you start to recover from the log before doing any other transactions of any types then you have a good...

Add this code to you report in the code section (report properties)

PUBLIC FUNCTION NDZ(Numerator, Denominator, DZResult) AS Double

IF Denominator = 0 THEN

RETURN...

I've got...

I've always kept the FKs, tho I've seen systems work well without 'em (microsoft application).

When you use the diagrams of SMSS, the FK will allow you to see the relations...

Svs2010 (2/8/2011)

---

@ninja's- Yes we are thinking of getting the latest version only and have to make sure all other SQL servers can be upgraded and the applications supports them as...

Yes you're right on the script part.

Like I said I NEVER leave the keys out of the dev phase.

And then I'm good enough at tuning that I don't need to...