Just curious as I've never used the RAISERROR to do routing, does this cause the package to report failure? If so, that might not be the desired result. ...

Probably just if exists (select * from vw_Customer) would be the best way to see if there's something there. Also may want to look at the code behind vw_Customer...

Something else to consider would be whether you want the triggers to fire regardless of what originates the query. For example, if you just update a table in QA,...

Totally off-topic, but....

Shouldn't you have written some sort of stored procedure or function in SQL to handle the number of dice, number of sides, and possible extra rolls for high...

Doesn't our saying that the leader in power is amazing depend on the country you're living in? Almost sounds like something...

Actually, what I was shooting for in my response to the whole GWB == more evil than terrorists post was that there are countries that are a whole lot worse...

I dunno, how about "life"? (yes, I realize that isn't a Constitutional freedom, but it's hard to enjoy the others when you don't have that)

So, do you want to explain how those terrorists didn't take away any freedoms when the World Trade Center was attacked? Seems to me that they did a pretty...

Have we turned into Slashdot? That's the sort of post I'd expect to see there. You may not agree with everything/anything he's done, but I'd not go so...

CDOSys is an option, but I had issues with the sp_OA procs when trying to use them for running DTS on demand. They stopped working - no warning, no...

I'd have to put in a quick note about other non-Islamic countries who have the goal, desire, and means to squash your freedom to type what you wish - at...

Excellent point. I think one author wrote something like, "Truth is that which, even when you stop believing it, still exists."

Hard to find people who believe in an absolute...

Don't want to turn this into a religious battle, but can we have some context here? I know quite a few Bible verses that could be taken by themselves...

Technically, this would count as installing something, but it's more of an "extract this DLL to this folder and register it as an extended proc in SQL" process. After...

Thought this was interesting because people often think that "freedom of speech" implies "freedom from consequences". I have every right to walk into a large non-caucasion group spouting white...