Maximum FT Catalogs per server

Hello, I am trying to see what the limit is on creating FT catalogs per
server. I have found 2 Non MS links stating 256 catalogs per server, but I
really need to confirm this.
Thanks for your help
Hello henderson,
After 7 minutes I'm at 1700 catalogs, so I guess the 256 is not true. This
is on a Sql2005 server (my laptop)
If you want to see the limit try this
declare @.name varchar(100)
declare @.i int
set @.i = 0
while @.i < 10000
begin
set @.name = 'catalog' + cast(@.i as varchar(10))
exec ('create fulltext catalog ' + @.name )
set @.i = @.i + 1
end
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

> Hello, I am trying to see what the limit is on creating FT catalogs
> per server. I have found 2 Non MS links stating 256 catalogs per
> server, but I really need to confirm this.
> Thanks for your help
>
|||Simon,
The 256 FT Catalog limit is specifc to SQL Server 7.0 and SQL Server
2000 and not a limiting factor in SQL Server 2005. Note, many FTS
issues are SQL Server and OS-platform specific. I've long known about
this limit and while there are to the best of my knowledge no specific
KB article from Microsoft on this limit, I have found the following
quotes and links on Microsoft.com and Support.Microsoft.com:
There is a hard limit of 256 search catalogs per server;
http://www.microsoft.com/resources/d...mspx?mfr=true
However, I find the below quote in the offical Microsoft SQL Support
white paper on deploying FTS using SQL Server 2000:
"You can create a maximum of 256 full-text catalogs on each server."
SQL Server 2000 Full-Text Search Deployment white paper
http://support.microsoft.com/kb/323739
Thanks,
John
SQL Full Text Search Blog
http://jtkane.spaces.live.com/
Simon Sabin wrote:[vbcol=seagreen]
> Hello henderson,
> After 7 minutes I'm at 1700 catalogs, so I guess the 256 is not true. This
> is on a Sql2005 server (my laptop)
> If you want to see the limit try this
> declare @.name varchar(100)
> declare @.i int
> set @.i = 0
> while @.i < 10000
> begin
> set @.name = 'catalog' + cast(@.i as varchar(10))
> exec ('create fulltext catalog ' + @.name )
> set @.i = @.i + 1
> end
>
> Simon Sabin
> SQL Server MVP
> http://sqlblogcasts.com/blogs/simons
>
|||Thank you both for your help in this. I should have clarified that I am using
sql server 2000. Anyway. Thanks again. It is really appreaciated!!!!!
"jtkane@.gmail.com" wrote:

> Simon,
> The 256 FT Catalog limit is specifc to SQL Server 7.0 and SQL Server
> 2000 and not a limiting factor in SQL Server 2005. Note, many FTS
> issues are SQL Server and OS-platform specific. I've long known about
> this limit and while there are to the best of my knowledge no specific
> KB article from Microsoft on this limit, I have found the following
> quotes and links on Microsoft.com and Support.Microsoft.com:
> There is a hard limit of 256 search catalogs per server;
> http://www.microsoft.com/resources/d...mspx?mfr=true
> However, I find the below quote in the offical Microsoft SQL Support
> white paper on deploying FTS using SQL Server 2000:
> "You can create a maximum of 256 full-text catalogs on each server."
> SQL Server 2000 Full-Text Search Deployment white paper
> http://support.microsoft.com/kb/323739
> Thanks,
> John
> SQL Full Text Search Blog
> http://jtkane.spaces.live.com/
>
> Simon Sabin wrote:
>