It might be wiser to use scope_identity() rather than @@identity especially for a shopping cart. Consider the case where two customers are online and create an order at the same time. @@identity just returns the id of the latest row created in a table. The two customers could both get the same id as a result. scope_identity() makes sure that this doesn't happen.
So use SELECT SCOPE_IDENTITY() as 'Identity' instead.
There's more on this here http://discuss.fogcreek.com/dotnetqu...ow&ixPost=6315
but just googling for scope_identity and @@identity will return lots of pages about this issue.
I'll post again about the Tools question in a minute
Read the feed at http://feeds.feedburner.com/dansarchive