This looks like it's going to be a very good series of articles.  I'm always looking for ways to improve how we manage database change.  We are a small team, with...

Yup, exactly. FWIW, I have a database that I'm currently converting from using Identity columns to GUIDS, as it it going to become a replicated database. In order...

Dave,

To insert a new record, and 'capture' the new GUID, in a similar manner to using the @@Identity, try this:

DECLARE @newGUID as UniqueIdentifier

SELECT @newGUID = NEWID()

INSERT INTO....  VALUES

(

@newGUID,

...

)

SELECT @newGUID

END

This will...

Nicholas,

Thanks a bunch for your help.  Based on your input, I put together a proof of concept in our development enviornment, even to the point of dropping a table out...

That's a good idea, thanks.  Any idea if I kick it off when SQL starts (which won't be often, since this is in a 24/7 environment), will I have any...

We are building VB.NET and ASP.NET applications, using VisualStudio.NET, and I currently wear both DBA and lead developer hats in our current environment.  Therefore I have a full install of VS.NET...