How to change the server name in all SQL views, stored procedures and functions?

Question

SQL

When developing on MS SQL 2000, the full path to the tables, [server name].[database].[table] was specified in views, stored procedures and functions. Now I am raising a copy of the Databases for testing, and from several, and each is connected to each other. But since server name other requests do not work.
How to change the server name in all SQL views, stored procedures and functions?
By hand is the last option.

Answer 1

I would try to upload procedures and functions to a file via the context menu of the database -> Tasks->Generate Scripts..., and in the file, change what you need by mass replacement. And then roll the resulting script to your test base.