How to compare two stored procedures

Please kindly ask your question in a better way it was an ambiguity to me ,
you want to compare the result set ?

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hi Saratvaddilli,

I dont want to compare the result set. I want to compare different version of stored procedure.
My stored procedure contains four thousand lines of codes. Some changes were made in my stored procedure by others. I want to identify the changes made in new version. Tell any easy method to compare.

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hi Kirthiga
we had an approach
using sys.objects we can get the last modified date and changes done to it
Once try this

SELECT name, create_date, modify_date,type_desc

FROM sys.objects

WHERE type = 'P'

AND name = 'usp_yourSPname' ORDER BY 1 DESC

Thanks and Regards
V.SaratChand
Show difficulties that how difficult you are

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

SELECT name

FROM sys.objects

WHERE type = 'P'

AND DATEDIFF(D,modify_date, GETDATE()) < 7

Above one can be used to check recently modified stored procedure. If stored procedure was created but never modified afterwards modified date and create date for that stored procedure are same. Cahnge 7 to any other day value. That List All Stored Procedure Modified in Last N Days.

Thanks & Regards

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

I dont want the details of modified date.
My question is how to find the changes made in the code. I want to compare the lines of codes of two procedures.

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Then Go through following link
http://www.codeproject.com/Articles/75026/SQL-Server-Stored-Procedures-Comparer

Thanks & Regards

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

hi Kirthiga,
we can compare codes in node++.Try this

Thanks & Regards
Hari

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hi,

User redgate tool for do this.
http://www.red-gate.com/

Best Regards,
kamprasad

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Use VSS to compare the code.


--Prathap

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

use Beyond Compare tool.

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

Hello Check this link

http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=210



http://usefulhowto.blogspot.in/2008/05/sql-server-stored-procedure-compare.html

Regard's
Raj.Trivedi
"Sharing is Caring"
Please mark as answer if your Query is resolved

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator

you can save your stored procedure as a txt file or sql file then compare the two files using WINMERGE.

http://winmerge.org/

Kirthiga, if this helps please login to Mark As Answer. | Alert Moderator