Forum Replies Created

Viewing 7 posts - 1 through 7 (of 7 total)

  • RE: Re-Index all tables in Database.

    Any reason I can not use EXEC sp_msForEachTable @COMMAND1= 'DBCC DBREINDEX ( "?")' ?

    After I run SHOWCONTIG they look fine afterwards.

    I backed up and restored to a test server. ...

  • RE: Maintenance Plan is failing

    Ok, same deal. The script will work in SQL2000 or SQL2005.

    However, you should be posting in the SQL2000 forum, not the SQL2005 forum. The advice for that platform...

  • RE: Maintenance Plan is failing

    Ok, so If this folder is not being shared out I do not know of a native way to monitor the data files to see where the problem is occuring...

    However,...

  • RE: SSIS package creation

    Just use the new SSIS import and export wizard, it takes you right through it. Create a new Integation Service Project, then Project>

    Import and Export Wizard.

    If you cant figure...

  • RE: Master database restore on DR site reporting wrong instance name.

    Dave's suggestion is right on. Create it part of a job to change the server name afterwards so it's all automated.

    Another suggestion is instead of copying the master database...

  • RE: Maintenance Plan is failing

    Start>Administrative Tools>Computer Management.

    Action>Connect to another computer.

    Type in Server Name

    click on Shared Folders>Sessions>OpenFiles

    Look for the username that is accessing that file.

  • RE: Maintenance Plan is failing

    Ok, never mind. I looked at your code and I saw what was happening...

    Try this if its not a mission critical system to see if its your backup job...

Viewing 7 posts - 1 through 7 (of 7 total)