Hi ND

Thanks for sharing this with us. I was always under impression that you can never call a proc from a function, and I was wrong.

For those who want to...

Have you used try catch in ur custome proc? I believe you shouls be able to avoid error from this proc.

may be you can paste code of that proc here,if...

Well, I dont think that shrinking database has anything to do with 'recovery of your classified document'.

Instead you should try to see how it happened in first place and have...

Thanks so much for all the responses...Its so great to see that people try to help even when they feel that they dont have all the required inputs. Although i...

Thanks to all who replied this post. My appologies if it looked so trivial....

Actually it was part of a complex proc and for simplfying I used father daughter exapmple.

I was...

My sincere thanks to both you guys for sparing time to look into it.........

My sincere thanks to both you guys for sparing time to look into it.........

works like magic...ur awesome.........

So All i was looking for here was checksum...

thanks fo rmaking me learn this new function

Creating dynamic query for reuse looks like a good idea. If you are doing it adhoc basis, then what I do is generate CREATE TABLE script along with triggers and...

I really dont know if anyone has figured it out but even after restarting, reloading the option was disabeled. So tried this n that and found that if the trace...