Post reply

Script to Change SQL Server properties

  • February 27, 2005 at 8:04 pm

    #67069

    Hi All,

    Is there anyway of changing SQL SERVER properties by means of a script

     

    thnkx




    My Blog: http://dineshasanka.spaces.live.com/

  • February 27, 2005 at 8:34 pm

    #544339

    What sort of properties are you looking to change?

     

    --------------------
    Colt 45 - the original point and click interface

  • February 27, 2005 at 8:39 pm

    #544340

    If u go to the server settings of the propeties dialog,

    there is some settings calles Server Behavior

    Can we change those from a script

    !




    My Blog: http://dineshasanka.spaces.live.com/

  • February 27, 2005 at 8:45 pm

    #544342

    Those options can be changed using the sp_configure stored procedure. Check Books Online for full syntax and server restart requirements.

     

    --------------------
    Colt 45 - the original point and click interface

  • February 27, 2005 at 8:59 pm

    #544345

    Thankx Philcart

     




    My Blog: http://dineshasanka.spaces.live.com/

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply