any way to set table schema for tables used in sps ?

See more:

SQL

Hii ,

I am using sql server 2012.

Well to optimize the performance of the query what i am doing is i am latering each sql store procedure , and adding set no count on at the begining , ading schema for each table used in my statement and at the end of table i am using with (nolock)..

but this is tedious job as so many sps to alter and they are long too ..

is there any way from which i can acheive this thing in short time ..

pelase suggest //