Interesting question but why doesn’t SQL Server tell us what it’s done? For example “(1 row(s) rolled back, batch terminated)”.

Question was "what type of index (if any) will SQL Server make to support the FOREIGN KEY constraint?". Answer is "none" and it's not possible to specify one in...