population

Full text catalog population always in progress, never actually populated

Hi, I have created a full text index on my dev server on a view that returns few rows. The population schedule is currently set to run once a day. However the full text index is returning no results as though it is not populated. If I run SELECT FULLTEXTCATALOGPROPERTY('My Catalog', 'PopulateStatus'), the result is always 1, indicatin...

Excel VBA ComboBox2 doesn't get the right content

Hi, I'm having a problem with the content of a combobox. On my userform, there are 3 comboboxes. Depending on the chosen item from combobox1, combobox2 should display either set 1 or set 2. The same will be happening with the content of combobox 3, which depends upon the combination of chosen items from combobox 1 and 2. However, I'...

How can I know when SQL Full Text Index Population is finished?

We are writing unit tests for our ASP.NET application that run against a test SQL Server database. That is, the ClassInitialize method creates a new database with test data, and the ClassCleanup deletes the database. We do this by running .bat scripts from code. The classes under test are given a connection string that connects to the ...

JQGrid Dynamic Select Data

Hi, I have utilised the example code at Example Code at this link and I have got my grid to show a dynamically constructed select dropdown on add and edit. However when it is just showing the data in the grid it shows the dropdown index instead of its associated data. Is there a way to get the grid to show the data associated with t...

Retrieving population density data

I need to figure out whether not a given location is considered urban or rural. I take it that the best way to do this is by looking at the population density of the city/state or province/country combination. The kicker is that we're using this for data mining. Generally, mapping APIs that could do this have a requirement that each req...

Regarding sharepoint and SQL data store

Hi, I am using a dropdown box in sharepoint designer, I want the data to be populated from the database. What control in sharepoint designer should I use. I cannot use sql data source as it says it is not supported in sharepoint enviroment. Please let me know your thoughts thanking you all ...