| Author |
Script out server properties and configurations
|
|
| g8r via SQLMonster.com 2006-03-24, 8:23 pm |
| Does anyone know how to script out the properties and configuraiton settings
for a 2005 instance to compare with another instance? Thanks in advance if
you do...
--
Message posted via http://www.webservertalk.com
| |
|
| just run 'exec xp_msver' on the instance to get the basic settings.
--
-oj
"g8r via webservertalk.com" <u16034@uwe> wrote in message
news:5dbf66b66bd7d@u
we...
> Does anyone know how to script out the properties and configuraiton
> settings
> for a 2005 instance to compare with another instance? Thanks in advance if
> you do...
>
> --
> Message posted via http://www.webservertalk.com
| |
| Sue Hoegemeier 2006-03-26, 8:23 pm |
| You can execute sp_configure to list all the configuration
settings. Enable show advanced option first. You can find
examples how to do this in books online under sp_configure.
-Sue
On Fri, 24 Mar 2006 19:50:31 GMT, "g8r via webservertalk.com"
<u16034@uwe> wrote:
>Does anyone know how to script out the properties and configuraiton settings
>for a 2005 instance to compare with another instance? Thanks in advance if
>you do...
|
|
|
|