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
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