sp_execute

• medha-666266

  Newbie

  Points: 5

  More actions

  July 30, 2008 at 2:19 pm

  #124336

  Just wanted to check if sp_Execute opens a connection every time it is executed?

  thanks,

  Medha

  mj

• FreeHansje

  SSChampion

  Points: 11751

  More actions

  July 31, 2008 at 7:29 am

  #851240

  You couild test this yourself:

  - Create a job with 3 steps, each step a sp_execute statement, like: select NAME from master.dbo.sysdatabases

  - Define & start a trace in which you check for number of connections with appropriate informational columns & events

  - Run job

  - Check trace output.

  Let us know, I'm curious!

  Greetz,
  Hans Brouwer