Something I had lieing around, you might need to tweak it some if you're doing cross server/cross schema compares or if you have a composit key but you should get...

Is this in a script component in an old DTS package?

But that's a VB Script error it looks like on this line,

oLocation = CInt(DTSGlobalVariables("Location").Value)

Which is converting whatever is in DTSGlobalVariables("Location").Value...

Is there a problem with switching to full recovery mode and keeping track of the log file sizes for awhile? You can leave your current recovery plan in place...

Jeff Moden (1/8/2015)

---

I'll add that if the shop will primarily be a .NET shop, I'd go with SQL Server.

On a personal note, I've found Oracle to be pretty restrictive in...

You can go back and forth all day on the little technical, well SQL Server does this, well Oracle does this details. There's massive SQL Server implementations and massive...

Well for one thing if you're are primarily a windows based company then SQL server just plain integrates with MS products better.

syquil (1/7/2015)

---

Grant Fritchey (1/7/2015)

---

syquil (1/7/2015)

The main issue is that the top 200 list can be pretty horrific performance wise. If I remember correctly, it doesn't actually issue a TOP, it...

Jeez, you'd be better off working for a company with no standards at all. At least then you'd have a chance to get things right, these pretty much guarantee...

batgirl (1/6/2015)

---

ZZartin (1/6/2015)

---

Uwe Ricken (1/6/2015)

---

Hallo ZZartin,

sorry but I don't understand your "recommendation". What modification do you want to do to...

The...

Wouldn't the best answer just be to modify the function?

Check maximum number of concurrent connections?

Don't tell anyone you knew about this for 3 days and didn't do anything about it earlier?

Just hope windows doesn't decide to reboot without prompting you.

Shouldn't that be a >= 0 in the EvalExpression?