license

[sabety]

Couple of questions

Running through the monitor.log file, I saw a couple instances where max rows or max data is printed next to a table name, but not all tables. I assume I need to report this for an upgrade?

Second Q, I am trying to delete duplicate records after creating a unique index. Can't seem to do it from tsql. I'm doing this on a live database to avoid rebuilding it as there are only two records I need to drop. Strange behavior on the search front-end now as the records still seem to be there, but without titles. Should I worry? I reissue the "delete from mytable where id = 'id'" command over and over but it has no effect. I am logged in as system user too.


thanks

[John]

The messages in the monitor.log let you know which table has the most rows, and only indicates the need for an upgrade if that exceeds your license.

What will usually happen after creating an index on duplicate values is that you will delete the one that was indexed, but the duplicate will not be in the index, so you can't delete it directly by id. After doing that you would need to recreate the unique index.