Forum Replies Created

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

  • RE: Incomplete full text index on SQL 2005 only

    Ah yes, sorry about it.

    SQL 2000 OUTPUT

    --------------------------------------------------------------------------------------------------------------------------------

    us_english

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Microsoft SQL Server 2000 - 8.00.2040 (Intel X86)

    May 13 2005 18:33:17

    Copyright (c) 1988-2003 Microsoft Corporation

    Enterprise Edition on Windows NT 5.2 (Build...

  • RE: Incomplete full text index on SQL 2005 only

    Part 2 of the reply

    On

    SQL 2005

    --------------------------------------------------------------------------------------------------------------------------------

    us_english

     

     

    ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    Microsoft SQL

    Server 2005 - 9.00.2153.00

  • RE: Incomplete full text index on SQL 2005 only

    Thanks a lot John

    for your support on this. I have added few more information as well

  • RE: Incomplete full text index on SQL 2005 only

    Both Server and database collation are same and set to Latin1_General_CI_AS. Even the Indexed Column collation is same.

    One more thing about my SQL 2005 test databases is that they all restored...

  • RE: RT error 70 Permission Denied

    I think you get some more info if you run the profiler against the sql server and catch

    1. Event Class = Security Audit, Event = Audit Login, Login Failed, Audit...

  • RE: Need to find rows with more than one space

    This should also work asuming you don't care about the trailing blanks.

    select

    CompanyName

    from MyCustomers

    where len(CompanyName

  • RE: How to prevent timestamp field from been automatically updated for an update

    Another option is to change the data type to Binary and manage the timestamp column on your own. you can get the next timestamp value for your db using this...

  • RE: Introduction to SQL Server 2005

    Got very frustrated when the examples were not working. MERGE INTO is no longer supported by SQL 2005. Other than that not a bad article.

  • RE: Problem in Login

    if the results are in grid mode then you can right click on the top left corner of the results (left most empty box on the column header) and select...

  • RE: Finding duplcate data in one table column

    This will only list the records with duplicate stud_ids

    select stud_id, last_name, first_name

    from stutable1

    where stud_id in

     (

      select stud_id

      from stutable1

      group by stud_id

      having count (stud_id) >1

    &nbsp

    order by...

  • RE: Execute SQL Task seting follow failure path.

    Raise an error in the SQL Query Task like below..

    RAISERROR ('Error Occured',16, 1)

    and it'll follow the failure path.

  • RE: Question of the Day for 25 Aug 2005

    not that hard, but you get 21 points

  • RE: Scripting out all database table index

    Go to GEnerate SQL script wizard in the EM

    Seelct relevant tables

    click on the formatting tab and uncheck all

    go to options tab and check Indexes

    You will have a nice script to create...

  • RE: sysdepends table doesn''''t populate

    Hi Brian,

    thanks for your input. I found another reason , which probably is the reason why it's not getting populated in my case.

    when you have a join to a temparary...

  • RE: Question of the Day for 15 Jul 2005

    Even the answer C is wrong. This doesn't change anything in the options database but another database called "2test"

    C)Run the following commands in Query Analyzer: sp_dboption '2test','trunc. log on chkpt.','false' go...

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