Post reply

Getting Truncated data back

  • September 26, 2011 at 6:11 am

    #1386406

    prakash 67108 (9/26/2011)

    i don't know what exactly the problem is ? actually one of my friend asked me what is the way to retrieve the table if it is crashed out..?

    i don't have any idea about that..so i would like to know how to do that if possible...

    Without more information, no way to say. Your friend needs to explain what he means by crashed.

    Let's put it this way, what he's asked is equivalent to 'My car's faulty, how can it be fixed?' No where near enough information to begin to offer useful advice.

    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

  • September 26, 2011 at 6:21 am

    #1386413

    its like stop operating the database...or broken up..

    Thanks,
    Charmer

  • September 26, 2011 at 6:24 am

    #1386415

    prakash 67108 (9/26/2011)

    its like stop operating the database...or broken up..

    What's the error, the circumstances, what works, what doesn't? What happened when it failed.

    You're still not giving us the info we need to help out.

  • September 26, 2011 at 6:27 am

    #1386417

    sorry buddy....il get the details from him and i would be posting it on the forum for the answer..

    Thanks,
    Charmer

  • September 26, 2011 at 6:29 am

    #1386419

    prakash 67108 (9/26/2011)

    its like stop operating the database...or broken up..

    "My car's like broken, how do I fix it?"

    Is that really an answerable questions?

    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

  • September 26, 2011 at 6:31 am

    #1386421

    GilaMonster (9/26/2011)

    prakash 67108 (9/26/2011)

    its like stop operating the database...or broken up..

    "My car's like broken, how do I fix it?"

    Get your backup car out of the garage and drive that..

    problem solved

  • September 26, 2011 at 6:34 am

    #1386424

    i have a stored procedure which passes the values dynamically....

    this is my destination table...

    JurisID CodeID CodeIDDescr SrcCodeDescr PnxCodeValue IsConverted

    1501 6002 SOU SOU SO 0

    1501 6006 NTR NTR NT 0

    1501 6002 EA EA EA 0

    my need is when my stored procedure inserts some rows, the PnxCodevalue must starts with some default value, say 999...so for the 1st row it starts with 999 and 998 for the 2nd row and 997 for the 3rd row...and so on...when i run the sp again, it must starts with the value 996 automatically and no duplicate values are allowed...how can i do that...?

    Thanks,
    Charmer

  • September 26, 2011 at 6:37 am

    #1386427

    you can set the starting value for an identity column and ask it for descending numbers.

    Next time, please start a new thread for new question.

  • September 26, 2011 at 6:38 am

    #1386428

    yeah i did that...and the problem is solved now...

    Thanks,
    Charmer

  • September 26, 2011 at 6:42 am

    #1386431

    how can i add a new thread?

    Thanks,
    Charmer

  • September 26, 2011 at 6:44 am

    #1386434

    prakash 67108 (9/26/2011)

    how can i add a new thread?

    The same way you start this one. Browse to the correct forum and add topic.

Viewing 11 posts - 16 through 25 (of 25 total)

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