do you have the code in a repository? (svn, sourcesafe, whatever)
if so then you can use grep
Charlie =============================================================== Msg 3903, Level 16, State 1, Line 1736 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Generate the Script of the database and then you can search..
Senthil Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
Generate the Script of the database and then you can search..
Senthil Kumar C ------------------------------------------------------ MCITP - Database Administration SQL SERVER 2008 MCTS - Database Development SQL SERVER 2008
also -- if you make each object go to it's own file the filename will be the name of the object. so using a search tool (or pattern match like grep) will tell you the name of the object.
Charlie =============================================================== Msg 3903, Level 16, State 1, Line 1736 The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
how 2 5nd stored procedures which are used nolock
Posted - 01/24/2012 : 05:25:04
