Apr 6, 2004 #1 grmman MIS Sep 9, 2003 81 US It there a way to search a database and identify all queries which are not used by any database object? Thank you
It there a way to search a database and identify all queries which are not used by any database object? Thank you
Apr 6, 2004 2 #2 jbpelletier Programmer Sep 8, 2001 232 CA Im not *totaly sure* but actualy i use that and it looks ok. In option check the option "show system file" then Look in the table Msysobjects where TYPE = 5 and FLAGS = 0 "TYPE = 5" means querry FLAGS = 0 seems to be when no object refer to that query otherwise it will be an integer (ie. 5,8, etc) hope this helps... jb Upvote 0 Downvote
Im not *totaly sure* but actualy i use that and it looks ok. In option check the option "show system file" then Look in the table Msysobjects where TYPE = 5 and FLAGS = 0 "TYPE = 5" means querry FLAGS = 0 seems to be when no object refer to that query otherwise it will be an integer (ie. 5,8, etc) hope this helps... jb