Home Forums SQL Server 2005 Administering to which DB these tables belong RE: to which DB these tables belong

  • July 22, 2009 at 4:58 am

    #1028194

    luckysql.kinda (7/22/2009)

    I have three tables and I need to find to which DB these tables belong. I am not sure how to do this. There are 29 DBs and to do task manually is a really bad idea.

    I used sp_help 'tablename' -- No use

    select * from sysobjects where name = 'tablename' --No use

    -LK

    Hey This works for you

    exec sp_MSforeachdb " print '?' select name from sys.sysobjects where name in ('Table1','Table2','Table3')"

    Rajesh Kasturi