First,we find all tables which contain given column'name from current database.Lastly,we can
modify columns' name in batches by cursor mechanism.Please change @value variable into your value.
The Ultimate Running Requests Reporter
Reports all running requests along with the request's identifying information (SPID, login etc), current resource consumption, query batch text, statement text, and XML query plan.
2010-05-24 (first published: 2009-05-01)
5,296 reads