Post reply

Can''t update SP: when executed in QA, just loops.....

  • February 27, 2006 at 3:55 pm

    #112016

    We want to update a stored proc in our sql 2000 server.  When pasted in QA, the syntax check said "OK" in about 1 second. Next we ran the same "ALTER PROCEDURE" query to update the database. After 5 minutes of running time, in QA, I killed the job.  The database was not updated. How can I analyze this type of problem.

    TIA,

     

    Bill

     

     

     

  • February 28, 2006 at 9:28 am

    #623728

    I'd try it again and in another window execute sp_who to look for blocking. Then maybe check the SQL Server errorlog and the Windows Event logs. As a last resort Profiler.

    RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

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

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