Post reply

server_config_script_2005_2008_2008R2

  • May 1, 2014 at 6:10 pm

    #286342

    Comments posted to this topic are about the item server_config_script_2005_2008_2008R2

  • June 17, 2014 at 6:32 pm

    #1722559

    Is this going to work for SQL 2012 please?

  • June 17, 2014 at 6:35 pm

    #1722560

    This is a really cool idea. Some of us may be used to using activity monitor/reports or an enterprise reporting system. Of course sometimes we just want a quick query.

    In the db file info script, starting on line 53, we will have to use

    SELECT mdb.name

    FROM MASTER.dbo.sysdatabases mdb

    inner join sys.databases db

    on mdb.dbid = db.database_id

    where db.state != 6 --OFFLINE

    So that the cursor 'dbname' is not populated with databases that are offline.

    Dallas

  • May 19, 2016 at 6:28 am

    #1880165

    Thanks for the script.

  • May 19, 2016 at 6:57 am

    #1880196

    What is the purpose of this part of the script ?

    -- Enable the OLE automation on the server

    EXEC sp_configure 'Ole Automation Procedures', 1;

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

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