Stored Procedures identify Problem

• anup_snwn

  SSC Enthusiast

  Points: 174

  More actions

  December 12, 2008 at 5:54 am

  #132979

  hi friends ,

  i am working in asp.net with sql server2005

  and i am giving my stored procedure script to my clients

  but i dont know that which client which script is missing or script not updated

  so can u tell me that can i give the any type of version or numbering to my stored procedures

  that i can easily identify the my procedure change or missing

  or any other way to solve this problem

  thanx...

• Nicholas Cain

  SSC-Dedicated

  Points: 33009

  More actions

  December 12, 2008 at 8:07 am

  #911662

  You can use versioning on stored procedures by suffixing the procedure with ;n where n is the version.

  Look in Books Online for "CREATE PROCEDURE (Transact-SQL)".

  ---

  
  Shamless self promotion - read my blog http://sirsql.net