This simple script identifies all objects which have a rollback transaction statement without a requisite begin transaction statement. If a rollback statement is issued without a begin statement, then the code will generate an error. Triggers are not included in the list since they can have a rollback without a begin.
This script can be easily modified to be used for any other code search where something exists in the code but another thing doesn't. With other modifications, it can be used for other purposes, such as finding all tables which are not being acessed in any other piece of code.
I hope this helps!
SP that shows information from a given database
It is used to show information from a database. It shows the creation date, it calculates the time in days, months and hours since its creation and it shows all the users with rights in that database.