create stored procedure taking long time why

• kbhanu15

  SSCarpal Tunnel

  Points: 4493

  More actions

  December 8, 2014 at 6:13 am

  #301743

  hi all,

  just create procedure taking long time in ssms more than 2 minutes.

  can any one please give advise what are the things to be check.

• JKSQL

  SSCrazy Eights

  Points: 8323

  More actions

  December 9, 2014 at 2:20 pm

  #1763654

  You would need to post the stored procedure or give us more information to help you. Performance can be lots of things