Script to search in stored procs select upper(SysObjects.Name),SysC... SysObjects, SysComments where SysObjects.type='P'and (SysObjects.ID = SysComments.ID)and SysComments.Text like '%SearchString%'
I ran across this weird problem while debugging a stored procedure in Sql Server 2000. Here's a sample stored procedure: drop procedure p1gocreate procedure p1as create table #t1( col1 int identity(1,1), col2 datetime, col3 int) select *from #t1 return update #t1set col3 = col2return Ok, notice that I have a return statement after the first select. That is my exit point for now because I am debugging so I am not interested in the section after that. Also notice that the update statement will throw...