Extra TTBL tables in Quality Center project
| ♥ 0 |
We are preparing for an upgrade and noticed one of our projects has thousands of tables that start with "TTBLCL". After doing some reading, I’ve found that this were temporary tables and should have been removed at some point. This is causing an issue when trying to verify the projects as the verify just keeps seeing the extra tables. I know I could create an exception file, but would rather not carry this unneeded data forward in our upgrade. Does anyone know of a way to delete this tables in mass rather than having to delete one by one?
Marked as spam
|
Posted by |
Private answer
We ran into the same issue during our upgrade. Our DBA ran the below SQL directly on the DB Server and it cleared all the TTBL tables. It took around 20 minutes to run for 50,000 tables, but once complete the tables were gone. DECLARE @SQL NVARCHAR(MAX) Marked as spam
 Posted by jafar (Questions: 3, Answers: 168) Answered on September 27, 2016 6:08 pm
|