title: select all databases in sysobjects that have a table named 'mytable' regardless of schema?
body: <p>For a given sql 2000 - 2008 server I want to find any table named dbo.[MyTable] on that server.  In addition, how do I find all databases that have a table named [dbo].[MyTable] and [AnySchemaName].[MyTable].  Is there a simple sp_ command like spTables MyTable?  Or  'sp_AllDatabaseTable [MyTable]'?</p>
  
  <p>I want to print it out like:</p>
  
  <pre><code>ServerName  Database  SchemaName  MyTable   Date Created
  ----------- --------- ----------- --------- -------------
  </code></pre>
  
  <p>Thx</p>