Consider there is one MS SQL server 2005 instance with 3 databases on it ... Dev, RC and Production. All of them have (more or less) the same schema. All of them have a "same" table with full text index on it.
- What happens if the name of full text index catalog is the same on all 3 databases?
- Do they share the same physical catalog?
- Is it any better (performance) to have unique catalog name on each DB?
It seams MSDN Create fulltext catalog does not give a good answer to that.