Wednesday, March 21, 2012

How many full-text catalogs does SQL Server 2005 support

SQL Server 2000 is pretty well documented with the limit of 256 (see http://msdn2.microsoft.com/en-us/library/aa214780(SQL.80).aspx) but I can find no documentation anywhere that discusses the limit on SQL Server 2005.

Is there one ?

Please help !

Thanks

A maximum of 256 full-text catalogs can be created on each server.

|||Does this hold true for SQL 2005 SP2 64-bit ? Does anyone have a reference for that information?|||No, this is even not true for 32bit. SQL Server 2005 removed this restriction.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

No comments:

Post a Comment