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.droptable.com
just run 'exec xp_msver' on the instance to get the basic settings.
-oj
"g8r via droptable.com" <u16034@.uwe> wrote in message
news:5dbf66b66bd7d@.uwe...
> 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.droptable.com
|||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 droptable.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...
Tuesday, March 20, 2012
Script out server properties and configurations
Labels:
advance,
compare,
configuraiton,
configurations,
database,
instance,
microsoft,
mysql,
oracle,
properties,
script,
server,
settingsfor,
sql
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment