Post reply

trace Flag 610

  • July 4, 2014 at 3:47 am

    #309746

    1. Does trace flag also give benefit when we delete or insert data into #temp tables ?

    2. Does it help in simple recovery mode?

    3. Do the below help ?

    ---Code

    dbcc traceon 610

    insert into employee (with tablock)

    select ..........

    dbcc traceoff 610

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • July 6, 2014 at 7:31 am

    #1727225

    The following article should en-clear about

    http://msdn.microsoft.com/en-us/library/dd425070(v=sql.100).aspx

    Igor Micev,My blog: www.igormicev.com

Viewing 2 posts - 1 through 1 (of 1 total)

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