Will SQL Server maintains the history of Stored Procedure?

• mamidimahesh-127681

  SSC Eights!

  Points: 868

  More actions

  March 9, 2005 at 2:18 am

  #85276

  Hi,

  When I modify a stored procedure, it will overwrite the old one.  Will SQL Server maintains history of a Stored Procedure?  I mean like VSS......

  Thanks,

  Mahesh Babu Mamidi

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  March 9, 2005 at 5:37 am

  #546104

  Short answer is NO.  SQL does NOT maintain history.  That is WHY you have VSS

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net