Support Forum

Oh, well, I'm hosted.

Thats should not prevent us fixing you. Go grab my SQL Query plugin from http://www.plugins4labtech.com, It is under the free plugin section. Install and restart your LT console.


Afterwards launch SQL Query plugin from main view menu.

Put first query in as
This will return a list of tables names

next for each table name put in, replace TABLENAME with the actual table name

restart the DBagent after all tables are gone and it will re create them as current. then rerun the list tables command again to see tables back in database

OK, I was just missing the knowledge for the query. I have several results. Most are chocolateyii, but there's one that chocolatey1. I assume I drop all of them, yes? Will I need to reinstall the plugin?

just the ones marked "ii", after wards just restart the dbagent for tables to be recreated.

No reinstall

I'm confused. I ran the command you gave early on to delete the maintenance scripts and it gave me the error. I just went in to look at the maintenance scripts as I could not remember anything related to chocolatey1 that was a result from the table query. When I expanded the maintenance scripts, all the chocolatey II script were gone. Not sure about that.

I went ahead and deleted the tables as well.

now if you restart the dbagent it should recreate scripts and tables

All is well, thanks!