how to rename System Center VMM server

I took the liberty of renaming my System Center VMM server today.. Didn’t think too much about it first.. I just got tired of typing WinVMM2012R2.. so I shortened it to VMM.

Well.. after a couple of reboots.. and renaming the Server in SQL Server.. I still wasn’t able to get in.

So then I started looking for .CONFIG files that might have a servername or something that needed to be changed. Well.. that didn’t work either.. .

So now I’m stuck looking through a database for a simple string replacement. Simple string replacement, anywhere in a database.. Oh yeah, I’m a database guy.. this’ll be easy!

I’ve used this method for years and years and years in order to find the data that I’m *REALLY* looking for inside of SQL Server tables. I get tired of writing the same scripts week in and week out.. so I try to share them on my blog..

Hope it helps someone, somewhere.. on this great big internet.
Obviously, you’ll need to replace the string WINVMM2012R2 with the string that you’re REALLY looking for 🙂

http://accessadp.com/2014/03/28/how-to-search-through-all-varcharnvarchar-or-text-fields-for-a-string/

This entry was posted in SQL Server and tagged . Bookmark the permalink.