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

  • July 24, 2009 at 9:27 pm

    #1030106

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

    MJ