Forum Replies Created

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

  • RE: ERROR 1204

    Check the autogrowth setting for the Db as well

  • RE: ERROR 1204

    is your code using temp tables ?

  • RE: Deadlocks

    Are you using Temp Tables in your code ?

  • RE: SQL Mail problem - profiles configured correctly

    See Microsoft KB Article 320407 as there are issues with SQLmap70.dll ( can stop XP_sendmail working ) version 8.00.603 is better.

    Update to Service pack 3a for SQL2000...

  • RE: upgrade SQ: 6.5 to 2000

    1. Stop SQL 6.5 Services and copy mdf/ldf files . Rename files if you like

    2.attach files to SQL 2000 using enterprise manager ie highlight databases >all tasks> attach

    3....

  • RE: Performance of a Database Restore

    To improve throughput use LTO 2 Tape Drives directly to the server. Scsii will then become bottleneck.

  • RE: Shrink Log

    Error is due to Design change in SQL2000 ie 7th Column is now LSN not DateTime(SQL7)

    see line... exec ( 'dbcc loginfo' ) select @last_row = @@rowcount in code...

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