Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2006
    Posts
    19

    Question Unanswered: Please help me on Script

    we are using a data loading tool that periodically changes a database option for several databases in several of the database instances. One of these options is the database Auto-Close option. When this option is enabled, the database will close and generate a very large error log. We already using stored procedure script to monitor all the activity happening. I need to track all the activity happens after this Auto-Close option enables, for this i will have to add some script in my script which monitors daily activity.I am new to Scripts. Please help me, what to write in script.

    Regards,
    Sumit

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Why you're using AUTO_CLOSE option on that database?
    In order to monitor the activity you can schedule server side trace and refer to http://vyaskn.tripod.com/server_side...sql_server.htm link fyi.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Apr 2006
    Posts
    19

    script for auto_close option

    Quote Originally Posted by Satya
    Why you're using AUTO_CLOSE option on that database?
    In order to monitor the activity you can schedule server side trace and refer to http://vyaskn.tripod.com/server_side...sql_server.htm link fyi.
    Hi,
    Thanks for your responce, I donot have option to use Auto_close option or not, I just have to find out how can I add this option to our daily report email script. There are lots of changes occur when this option enable mainly it increase the log file size that i need to include my mail report, I am not very much aware of the scrips. pls find some way so that i can add it in scripts running.

    Regards,
    sumit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •