• Okay, being a newbie to the adminstration side of SQL Server, I have to ask!

    Given that BOL says the following:

    sp_configure 'show advanced options', 1;

    GO

    RECONFIGURE;

    GO

    sp_configure 'clr enabled', 1;

    GO

    RECONFIGURE;

    GO

    How do you determine that only the last 4 lines are necessary (as the answer to the question implies). What are the first 4 lines doing (okay, the "GO" isn't doing anything...)? BOL doesn't specify, it just gives you this code and then talks about what "sp_configure 'clr enabled', 1" does.


    Here there be dragons...,

    Steph Brown