Search table name in Server


  • Hi All,

    I am new to SQL Server.

    I have a table name but I don't know where this particular table exists.

    Could you please help me by giving the query to search entire server.

    Note:- As I have to search 4 servers, each server have so many databases.

    I can't search database level.

    Kindly let me know the query which search entire server (all databases in server).

    Thanks in advance,


    Tuesday, June 25, 2013 6:42 AM