I admit this answer doesn't directly answer your question - how to add a sequence number directly into a SELECT statement, but it does provide that result.

This may not be...

Take a look at sp_repladdcolumn in Books Online.

* Warning: Books Online gives the wrong parameters for this sp - it misses one in the middle.

You can...

Also note that you're going to cough up half your physical RAM to the OS. If your SQL box has 4GB of RAM on Win2000 Server, then applications can...