SQL Server 2008 does not install DMO by default. Is there a function or script I can use from the command prompt to check remote servers to see if DMO has already been installed? We were using a registry key check but thought that might not be the best option. Any advice is appreciated!
I'm assuming you mean SMO (DMO was replaced by SMO in SQL 2005).
You can do this as a quick and dirty test within Powershell:
If SMO is registered it'll come back with some info on where it found the SMO dll and what version it is.
You could also use this VBS script if you don't want to do it in Powershell:
If it returns a runtime error