Best way to deploy to Prod

• Chinna

  SSCertifiable

  Points: 5408

  More actions

  February 3, 2014 at 8:55 pm

  #282000

  I have a stored Proc "SP_TEST" which also has "GRANT EXECUTE TO USER1" . The username is different from dev to prod so whats the best way to deploy it to prod with out manual intervention ? Is it using proxy user ?

  Thanks,
  Chinna

  Its the Journey which gives you Happiness not the Destination-- Dan Millman