I setup a development server by restoring the system databases from the production server. However, I am now running into a problem with a trigger that is pulling the server name from @@servername. When I select @@servername it returns the production server's name. How can I change @@servername to reflect the development server's name? Both servers are local sql installs. There are no other instances. When I remote into the development server using Management Studio I use what the development server name should be. This name is just not reflected in @@servername.
Can I use the sp_dropserver, sp_addserver? Would doing this have any adverse affects on the databases, jobs, etc?
sp_addserver , local
I really don't want to rebuild this development sql server. That would probably involve contacting the vendor, which would means more money.