NEW T-SQL technique! (or new to me).  The @@IDENTITY function has historically been flaky and susceptible to outside interference.  You must use it immediately after you do an insert if you want it to have the correct value, but even then, it can be clobbered by triggers that may have run in the meantime.  The T-SQL SCOPE_IDENTITY function and the IDENT_CURRENT have

Returns the last IDENTITY value inserted into an IDENTITY column in the same scope. A scope is a module — a stored procedure, trigger, function, or batch. Thus, two statements are in the same scope if they are in the same stored procedure, function, or batch.

Returns the last identity value generated for a specified table in any session and any scope.

Special thanks to Rick Dilling for using this technique in a stored procedure I was reading.  I haven't been able to confirm that this was added with SQL 2000, but it probably was.

Open Source Adventure

As I continue on my open source adventure, I’ve been trying to configure a Linux server as a mail server for multiple domains.  I haven’t spent a ton of time on it, and I’m definitely a Linux server configuration newbie.  But I get by with a little help from my friends and a little good research.

Here’s a helpful page with tips on using the postfix application for those who care.  I’m attempting to use the Linux server to handle my mail for all of the domain names that I have registered.  Should be interesting…

In my “other spare time,” I hope to actually get to install my surround speakers from the home theater system I bought last Christmas. :-)

SJ Mercury: Tools coming for connecting information. Dan Gillmor. But we need more sophisticated methods for gathering, massaging and making connections among all the pieces of information that enter our lives each day — everything from e-mail to Web pages to phone numbers and more. So when I see useful tools, I pay attention. [ Tomalak’s Realm]

Hmmm…Tools to help me organize my information?  I’m listening.

James Duncan Davidson: I’m sitting in Dave Thomas’ talk on Pragmatic Programming and he’s making the point that a developer’s career and their growth is up to them. I entirely agree. And I think it’s true in life in general.

Unfortunately, there was no further explanation about the speakers thoughts.  I would have liked some nugget to help me figure out what kind of control I supposedly have.