ASp and MSSQl timeout error

Posted on 2009-02-12
Last Modified: 2012-06-22
I recently Migrated a Job Board website from an online server to a local server within the company as it was really slow. Once i migrated the website i set everything right .

THere is a login screen, I log in and the LOGIN works fine , which means that the databse is configured right.

Once i login when i try to View Candidates(Lots of records) I get the follwoing error.

"Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Error while processing your query, please retry your search !"

I changed the coonection string timeout property and all but nothing worked.

What im unable to understand that when the site was online it used to TIMEOUT ocassionally But when I migrated it to a local server It Timesout all the time.

On some suggestions i checked the SQL LOG and found this error:

A fatal error occurred during a full-text population and caused the population to be cancelled. Population type is: FULL; database name is IFTS (id: 8); catalog name is MessageCatalog (id: 5); table name Messages (id: 2105058535). Fix the errors that are logged in the full-text crawl log. Then, resume the population. The basic Transact-SQL syntax for this is: ALTER FULLTEXT INDEX ON table_name RESUME POPULATION.

I have enabled FDLHost etc....

I just dont seem to figure out whats happening
Question by:isaackhazi
    LVL 20

    Accepted Solution

    Have u created any identity column? Is the maximum size of the identity column reached?
    LVL 8

    Author Comment

    What do you mean by ID column. Do you mean PK. Well, i didntr design the database . It was designed by another developer. But the whole problem is that it works OK when its online but in local host i get the errors i mentioned above.
    LVL 20

    Assisted Solution

    LVL 8

    Author Comment

    Yes i did have a look at that but didnt help.

    Featured Post

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now