Post reply

Sometimes getting issues in sp [SQLServer]Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

  • September 30, 2008 at 4:30 am

    #73047

    I am using a stored procedure with dynamic query for accessing data. Some time i am getting the below error while running that stored procedure. This sp is calling from cold fusion page

    [SQLServer JDBC Driver][SQLServer]Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation (such as CREATE FILE) operations on a database must be serialized. Reissue the statement after the current backup, CHECKALLOC, or file manipulation operation is completed.

    Anyone any idea about this. Please help me. The sp is below i am using

  • September 30, 2008 at 5:29 am

    #878763

    Dunno about anyone else, but I'm not seeing an SP...

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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