Great question Ron, thanks!
Another thing that might lead to the create index statement to fail:
it's not sure the base table has been created with ANSI_NULLS set to ON.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP