I'm not sure the best approach for this task. I have to search a database and find the sname columns in all the tables. Then pass the new value into the stored procedure which will update that reference in the tables. I can find the column with the below query:
WHERE TABLE_CATALOG = 'AdventureWorks2014'
AND COLUMN_NAME LIKE '%address%';
Now that I've found it I want to pass the old value and then the new value:
create proc chngsname
(@keyid int, @srvname nvarchar(120))
update tablenames set name =@srvname where keyid =@keyid
exec chngsname 45325, 'CORRECT_NAME_FOR_SERVER'