Real SQL programmers never use IDENTITY at all. It is the count of the physical insertion attempts. That is physical meta data and is not RDBMS.
This warning message will not stop wxwcution. But there is more to than just this! Imagine a CURSOR with an aggregate that dropped a NULL in a...
IDENTITY is the count of the physical insertion attempts to a table. Why would you think that it can ever be a key in a properly designed RDBMS?...
Separate names with a comma.