I think, Full Text Indexes are created on default file group, if you don't specify any filegroup.

CREATE FULLTEXT INDEX ON Table(Column) KEY INDEX PK_Name on [Cat_Name]; -- creates...

Thanks for all your help. It works now.

I did the example at home on my home PC (didn't work at home). Tested the same copy at my office PC and...

Thanks for the URL... good one.

My example still doesn't work.

I declared user variable as GetName String

and contactName in the table is varchar and selecting only top 1 values which is...

Thanks... but doesn't work

I get the error--> The type of the value being assigned to variable "User::GetName" differs from the current variable type

I have declared user::GetName as string (under...

That might be a hobt_id. You find it through sys.partitions:

SELECT o.name, i.name

FROM sys.partitions p

JOIN sys.objects o ON p.object_id = o.object_id

JOIN sys.indexes i ON p.object_id = i.object_id...

Adam Haines (2/27/2008)

hi i have a question, i just got told by the senior DBA that to consider that query i have to put at least the page count >...

How can I tell what is Table page Count