Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Can't create index on table - MS Sql Server 2014

smirandac1978's profile image smirandac1978 posted 1 month ago in General Permalink

Hello how are you? I really like this HeidiSQL program, but I have noticed that I cannot create indexes on MS Sql Server 2014 tables. When I create one following the correct procedure, I get an error " SQL error (1750): Failed to create the constraint or index. See the previous errors. "Attached screenshots.

And I see in the command history, it tries to do an ALTER TABLE instead of a CREATE NONCLUSTERED INDEX

Is it a mistake on my part? Or is there something that can be done to fix it?

Thank you very much.

2 attachment(s):
  • h1
  • h2

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.