Thank this author by sharing:
By Jamie Ingram-729524, 2009/04/22
This was written as a quick versioning control for stored procedures that I was working on.
Usage:
<stored proc code>
IF @@ERROR = 0
BEGIN
EXEC AX_BackupRoutines <proc name>
END
To retieve data
SELECT ObjectText
FROM ObjectHistory
WHERE ObjectName = <proc name>
AND Version = n
where n is a number
As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.
Join us!
Steve Jones Editor, SQLServerCentral.com
