How to Parse the Stored Procedure .sql file

See more:

C#

.NET

SQL-Server

Hi,

I have 100 sp which contain lot of update statement. I want to insert one line(Audit Sp Calling) below to that all update statement.

Example

Create Procedure TestSp
Begin

Line 1 ....
Line 2 ...
Line 3 Update Test Set
Line 4 Status='A'
Line 5 Where ID=1
Line 6
Line 7 select * from Test
Line 8 .....
Line 9 ....

Now i want to insert one line in Line 6 "Call SP Sample line"

Line 1 ....
Line 2 ...
Line 3 Update Test Set
Line 4 Status='A'
Line 5 Where ID=1
Line 6 Call SP Sample Line
Line 7
Line 8 select * from Test
Line 9 .....
Line 10 ....


Thanks