• I used

    select name, id from sysobjects where name = 'get_emp_list_FY06'

    to get my objid. then I run this

    select bucketid, cacheobjtype, objtype, objid, dbid     

     from master.dbo.SYSCACHEOBJECTS

     where  objid = 1718297181

    it return

    bucketid    cacheobjtype      objtype  objid       dbid  

    ----------- ----------------- -------- ----------- ------

    (0 row(s) affected)

     

    Why ? Thanks.