Home Forums SQL Server 2008 T-SQL (SS2K8) is it possible to change an instance server properties with T-SQL ? RE: is it possible to change an instance server properties with T-SQL ?
WolfgangE
SSCertifiable
Points: 6328
More actions
December 31, 2012 at 10:27 am
#1572546
of course you can. Depends on what property or configuration you actually want to change.
Just to name an example, have a look at "sp_configure".
Changing the name of a sqlserver can be done using sp_dropserver and sp_addserver. Just google for it.