Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Leo Peysakhovich Identifying Unused Objects in a Database RE: Identifying Unused Objects in a Database
Majbou-204206
Grasshopper
Points: 19
More actions
September 11, 2006 at 10:07 am
#659695
"select name, id from sysobjects where name = 'get_emp_list_FY06'"
calls the sysobjects table, so your query puts in cache the SYSOBJECTS table not your sp/fn.