Post reply

Script for integrity chk and Opti job

  • January 20, 2006 at 4:34 am

    #111305

    http://support.microsoft.com/?kbid=902388 is my issue and i cant install sp4 as my appli: vendor wont accept sp4.

    I have excluded that database from Maintanence plan and planing to run script as job .

    .any one got script for Integrity check and Optimization job ? Please help

    -Rajiv

  • January 23, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • January 23, 2006 at 11:26 am

    #616505

    Is there any specific reason that why you can't go with workaround?

    Equivalent of  Integrity check is DBCC CHECKDB

    Equivalent of Optimization job is DBCC DBREINDEX

  • January 23, 2006 at 2:57 pm

    #616542

    From Original post

    " i cant install sp4 as my appli: vendor wont accept sp4"

    From

    <http://support.microsoft.com/?kbid=902388&gt;

    "The -SupportComputedColumn parameter is a new feature that was introduced in SQL Server 2000 Service Pack 4 (SP4). Therefore, this workaround requires that you have SQL Server 2000 SP4 installed"

    Rajiv, check the script library here http://www.sqlservercentral.com/Scripts/ there are many maintenance scripts to be found. Pick one that best suits your needs.

     

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

  • January 24, 2006 at 5:12 am

    #616622

    My mistake. I apologize.

  • January 24, 2006 at 7:00 am

    #616650

    The apology isn't necessary, but I'll accept it anyway

     

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

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

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