Post reply

i have object with name "utils..deletelist" in my database .where can i find the same in the object explorer ? what kind of object it is ? is it a table or proc etc ...?

  • April 2, 2015 at 3:42 am

    #299248

    i have object with name "utils..deletelist" in my database .where can i find the same in the object explorer ? what kind of object it is ? is it a table or proc etc ...?

  • April 2, 2015 at 3:47 am

    #1788221

    The name implies that there's a database named utils and within that database, in the dbo schema is an object called 'deletelist'. Check your server. As for what it is, only you can answer that, it's something custom within your system.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • April 2, 2015 at 3:49 am

    #1788222

    MVIT (4/2/2015)

    i have object with name "utils..deletelist" in my database .where can i find the same in the object explorer ? what kind of object it is ? is it a table or proc etc ...?

    Quick suggestion, run this code and check what it brings back

    😎

    USE utils;

    /* The object is in the utils database (utils..deletelist)

    and will only show up there in the object explorer

    */

    GO

    SELECT

    *

    FROM sys.all_sql_modules ASM

    WHERE ASM.definition LIKE N'%deletelist%';

  • April 2, 2015 at 3:51 am

    #1788223

    Thank you ...

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply