Getting Truncated data back

Question

Getting Truncated data back

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

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

Charmer SSChampion Points: 14903 More actions · Answer 2

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

Thanks,
Charmer

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

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.

Charmer SSChampion Points: 14903 More actions · Answer 4

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

Thanks,
Charmer

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

steveb. SSC-Forever Points: 46733 More actions · Answer 6

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

Charmer SSChampion Points: 14903 More actions · Answer 7

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

this is my destination table...

JurisIDCodeIDCodeIDDescrSrcCodeDescrPnxCodeValueIsConverted

15016002SOUSOUSO 0

15016006NTRNTRNT 0

15016002EAEAEA 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

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 8

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.

Charmer SSChampion Points: 14903 More actions · Answer 9

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

Thanks,
Charmer

Charmer SSChampion Points: 14903 More actions · Answer 10

Charmer

SSChampion

Points: 14903

September 26, 2011 at 6:42 am

#1386431

how can i add a new thread?

Thanks,
Charmer

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 11

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.