Forum Replies Created

Viewing 6 posts - 2,446 through 2,452 (of 2,452 total)

  • RE: Routine to get index details

    Google ....

    http://www.eps-publishing.com/Article.aspx?quickid=0301101

    is this what you are after?

    HTH

    gah

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: using 32-bit ODBC driver on 64-bit system

    Hi Steve

    we have successfully installed 32-bit SQL 2005 (Std) side by side with 64-bit SQL on Win2008 64-bit.

    We installed the 3rd pty ODBC driver using odbcad32.exe

    I am new to SQL...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: using 32-bit ODBC driver on 64-bit system

    ....update

    have installed SQL2005 32-bit alongside exg 64-bit version

    from SSMS i just want to run a simple data import using the 32-bit ODBC driver already installed.

    When I right click a db...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: using 32-bit ODBC driver on 64-bit system

    That certainly is bad news.....but thanks anyway

    to clarify...is that 32-bit SQL AND 32-bit OS ?

    gah

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Truncate or Drop and Recreate

    to clarify...

    bcp is quick, but I need a text file...yes?

    (ie a table dump to text from the legacy system)

    if this is the case, then I am stymied ....see above

    Thanks for...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

  • RE: Truncate or Drop and Recreate

    Terry, many thanks for your comments

    what I have done so far is to truncate the tables, drop indexes, DTS in and recreate indexes.

    this is marginally faster than loading with indexes...

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 6 posts - 2,446 through 2,452 (of 2,452 total)