After lots of thinking and considering the comments above, I decided to change the sql statements into dynamic sql. I converted most of it but then there are procedures that...

Another factor to create view is if you want to expose only few columns of the table to other external application.

You can also create a trigger on syscomments table for update/insert/delete to send a email , that way you would be notified if anyone tries to change something in the...

Just on a second thouhgt, i was thinking to have all procedures in central database and all developers would work on that, any changes to the procedures and that proc would...

Thanks. The above was just a sample, but my actual procedures are very lenthy, uses temp tables and cursors. I am just trying to avoid to make dynamic sql and...