DWUTKA at marlow.com
DWUTKA at marlow.com
Tue Jun 27 09:14:07 CDT 2006
If there aren't a million tables, you could put in a simple SELECT trigger, so you know what's being used.... Drew -----Original Message----- From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] Sent: Tuesday, June 27, 2006 4:49 AM To: accessd; dba-sqlserver; dba-vb Subject: [dba-VB] SQL Tables No Longer Used Importance: High To all, I have cross posted this just in case anyone else knows of anything, I don't know if this sort of software will be available...I have a SQL Database with a VB6 front-end that the company has decided it's time we totally re-design, now this database has been passed down twice so there are tables in it etc that are no longer used. Is there a piece of software that can run through a SQL database and/or VB6 code that will tell me which tables/queries/views/store procedures are no longer used. If not does anyone have a good strategy plan if they have done this before, this is a big database and I can't see a simple solution to totally re-designing it to also incorporate the existing data. Thanks in advance for any help on this . Paul Hartland _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com