I'll second what James said about SQLite. It's been around for a long time, and it only takes between 150-250 Kb (depending on the features you need). I have...

I think a mistake Bob Muglia (or maybe Steve) is making is saying Java=J2EE. J2EE is a web application server based on Java. It may be true that J2EE...

Other's have said it, but I want to reiterate that the standards immensely help people writing software that they hope to sell. If you are living in a secluded,...

"The problem is that Microsoft makes the OS, so they have to 'integrate' the software."

I can't fault Microsoft for wanting to own software in every market (although I do disagree...

"The issue is often that most user's want something integrated, for better or worse."

And is Microsoft the only company in the world that knows how to make 'integrated' software? ...

<rant>The points made in this editorial reflect the ignorance I see a lot in the Microsoft fan crowd. There are a lot of people out there that are completely...

We have a guy on our team that's really chomping at the bit to upgrade, but there are two things that keep holding us back. DTS and Analysis Services....

Here's one I accidentally made up the other day:

"I've got good news! I just saved a ton of money by switching my software from Microsoft!"

I think Sergiy was just giving a word of caution, to make sure to include the join. I looked at the original code I posted, and I also have...

Part of my page? I'm not doing anything with pages here.

I now see the hole in my logic though. I was under the assumption that the...

Actually, I am only inserting one line. The trigger is from an update statement, and I am inserting from 'Deleted', that magical temporary table that contains the 'outgoing' record...

Thanks for your persistence Perry.

I have solved the problem, and it was a dumb mistake. The tests I was running had data with nulls in it (the production data...

Perry,

The problem with that trigger is that it does insert a history record when it shouldn't. In my tests, if I update the position record, but don't change any...

I should mention that I've tried a bunch of variations trying to get this to work, and one was using inserted/deleted instead of original/deleted. Anyway, I tried your code...

I am using MSSQL because last year I got a job where it's in use. I am not enthusiastic about it, but I try my best to learn as...