title: Sql Server 2008 - How to query for status of fulltext catalogs on all user databases?
body: <p>I have several databases in a Sql Server 2008 R2 instance. Some of those databases have a full-text enabled table. The name of the full-text table is equal for all databases, but the databases have different names and they are created on demand (I never know what databases exists and what does not).</p>
  
  <p>The thing is: I need to query all catalogs in all databases to check if a population is done, but I have no idea how many databases I have (of course I know, but they are created on demand as I said). The script must query all databases and check if a population is done in a table (which the name I know because it never changes besides the name of the database that does change)</p>
  
  <p>I have seen many people using things like:</p>
  
  <pre><code>sys.fulltext_catalogs
  </code></pre>
  
  <p>But it does not work if i am using the master database for example.</p>
  
  <p>Any ideas?</p>