Post reply

bcp / how to check database option

  • April 4, 2002 at 7:04 pm

    #78194

    Hi, according the book, Microsoft SQL Server

    2000 DBA Survival Guide, in order to achieve fast mode bcp, I need to check if the database

    option SELECT INTO/BULKCOPY must equal TRUE. (p.403).

    How and where I can check if it is set to true?

    Thanks in advance.

  • April 4, 2002 at 8:19 pm

    #426677

    Run

    sp_dboption 'dbname', 'select into/bulkcopy', 'TRUE'

    Or in EM right click the database and do properties. You will find it on the Options tab (? don't have an EM in front of me so may be some other name).

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 4, 2002 at 8:36 pm

    #426682

    Hi, Thanks for the prompt reply. I just tried

    the sp_dboption way.

    I executed it in query analyzer, and I got this

    message:

    The command completed successfully.

    Does this mean the option is set to be 'TRUE'

    by running this command, OR, it checks the db

    and find out the db was already set to be true?

    If it is the first case, should I run the

    sp_dboption ... command each time before I run a bcp command to make sure a fast mode?

    Thanks.

  • April 4, 2002 at 8:45 pm

    #426688

    No it is now permanently set to TRUE until you turn it off by doing

    sp_dboption 'dbname', 'select into/bulkcopy', 'FALSE'

    instead.

    You can do

    sp_dboption 'dbname', 'select into/bulkcopy'

    which will return the current setting.

    See SQL BOL for much more detail look under sp_dboption.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • April 5, 2002 at 11:33 am

    #426725

    Thanks, it works for me.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply