Forum Replies Created

Viewing 15 posts - 16 through 30 (of 41 total)

  • RE: Full-text Search

    Mike, thanks for that. I feel like I've learnt something today 🙂

  • RE: Full-text Search

    - it seems to me that you would want to eliminate stop words first, then look at the actual words for example: case sensitivity - it will reduce the search,...

  • RE: Full-text Search

    I was thinking it was because the thesaurus may contain stopwords. Therefore, it would make sense to process that before applying stopword filter.

  • RE: .NET Runtime 2.0 Error When launching SSMS

    You're quite right. that is the SP1 version.

    I find repairing rarely helps. I guess I'd try an uninstall / reinstall of .Net framework next.

    I have a fair number...

  • RE: Mirroring

    The error message attached shows that TCP://10.1.4.10:5023 can't be contacted.

    Given it is a different IP address I assume it is a different server. In this case the default port it...

  • RE: Database mail not delievered

    I managed to fail to send an email and not get a log entry by using an invalid email address (same result with invalid user name and for invalid domain...

  • RE: .NET Runtime 2.0 Error When launching SSMS

    The version you mention is quite old. I'd say its a fair bet that upgrading .Net Framework 2.0 to SP1 and your SQL tools to SP2 will probably help.

  • RE: Database mail not delievered

    The problem may be further down the line than the SMTP relay server. If your server's IP is not in the authorised relay list on the SMTP server you would...

  • RE: Cleanup Task fails in SQl Server 64-bit

    mumu (10/15/2008)


    I have same problem for shrinking of database.

    It does not give me any error but it does not shrink.

    Try generating a script for your database shrink and running...

  • RE: Full-text Search

    Good Question.

    Once you understand what stopwords are there is only one logical processing order.

  • RE: Database Mirroring and Log Files

    If you backup a mirrored database log it should still truncate afterwards.

    I agree it sounds as though the mirror is not synchronized , and thus the log is storing...

  • RE: SUM of FLOAT inconsistency

    3 of the options seemed very unlikely, and the answer is easily verified by changing the order of @float* inserts. Cheating rules ok 😉

  • RE: Can you enable the mirror copy?

    You are welcome.

  • RE: Can you enable the mirror copy?

    Whilst mirroring is enabled only the Principal database is accessible.

    If you want to access the Mirror database without failing over you need to

    'Remove Mirroring' and, on the Mirror...

  • RE: Clusters Opinion

    High availability usually implies some form of redundancy, rather than a standalone server that rarely encounters problems of a hardware or software nature.

    My understanding is that you have 5...

Viewing 15 posts - 16 through 30 (of 41 total)