I had already reviewed the SQL Server licensing info on the MS web site. However, what it doesn't answer is if a Windows 2000 Server CAL is also required (thus...

-- PRIMARY KEY - don't CREATE TABLE without it. Doesn't matter how temp it is. Even in-memory table variables.

-- IDENTITY - a wonderful alternative to 200+ byte PKs that aren't...

Good article! I was "forced" to start doing this when I needed to modify the parameters (interface) on procs for a new version of a UI. Without a staging server...