Post reply

You have a SQL Server stored procedure named...

  • February 21, 2015 at 5:21 pm

    #100904

    Comments posted to this topic are about the item You have a SQL Server stored procedure named...

  • February 21, 2015 at 6:16 pm

    #1779130

    Actually, none of the answers are correct. Even if you take the correct action according to the answers provided, it is possible that the proc won't auto run on startup because the "scan for startup procs" server setting must also be enabled. In SQL Server 2000, the default value for scan for startup procs is 0 (do not scan).

    Additionally, the startup procedures must be owned by the database owner, as well.

    That, notwithstanding, the answer considered to be correct is the most correct answer of those given. I just want to make sure that no one still forced to use 2000 thinks that's all there is.

    --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)

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

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