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

  • July 25, 2009 at 7:10 am

    #1030144

    MANU (7/24/2009)

    exec sp_MSforeachdb "select '?' As DatabaseName,name from ?.dbo.sysobjects where name in ('Tablename')"

    MJ

    hey manu

    thanks for modifying the query........

    cheers.......

    Rajesh Kasturi