Post reply

I/O error in sqlserver2000

  • November 27, 2008 at 5:09 am

    #196231

    Hai,

    I was trying to read data in a table in sqlserver 2000 ,

    select * from tablename .

    it has given error msg like

    i/o error 87 (parameter is invalid)

    can you suggest the solution for this problem .give the description for this problem

  • November 27, 2008 at 5:32 am

    #904259

    Any errors in the SQL error log?

    Is this the first time that you've seen an IO error?

    When you have a couple hours where the server won't be heavily used, please run the following. If it returns any errors post them here.

    DBCC CHECKDB (< Database Name > ) WITH NO_INFOMSGS, ALL_ERRORMSGS

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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