Showing posts with label empty. Show all posts
Showing posts with label empty. Show all posts

Monday, March 19, 2012

Controls missing in toolbox

All in sudden all the Controls (Table, Crosstab, textbox...) disappeared from my Toolbox. I clicked View -> Toolbox and still it is empty.

Anyone has any idea what is going on..

Thanks.

Got it. I reset and got all back.

thanks.

Friday, February 24, 2012

Contains

I have created a full-text catalog in pubs and also include the lname of
employee table in the index.
However, I got empty result set with the SQL when execute in the Query
Analyser :
SELECT *
FROM employee
WHERE contains(lname, 'Perente')I think the pubs database has 'Parente' not 'Perente' :-)
If lname was well written check that the service account used by Full-Text
Search has permissions on the SQL Server instance.
Ben Nevarez, MCDBA, OCP
Database Administrator
"Alan" wrote:

> I have created a full-text catalog in pubs and also include the lname of
> employee table in the index.
> However, I got empty result set with the SQL when execute in the Query
> Analyser :
> SELECT *
> FROM employee
> WHERE contains(lname, 'Perente')
>
>