Good one!! 🙂

bcoz it is its behavior that every time we execute TRUNCATE command it will reset the identity value..

easy one for Wednesday 🙂

revision of basics........

:-):-P

really nice question 😀

good discussion :-P:w00t:

thanks Hugo for pointing out that link thing 😛

good question

+3 🙂

we always learn new things from SqlServer central :-):-)

:-):-)

good question Lokesh...

It makes me remind of our last discussion for identity itself... 😛

+1 today also 🙂

its already discussed 😛

I agree with demanfox if it is mentioned in the doc then its the limitation of sp_rename not a bug.

🙂

right...

I learned a lot from Hugo's explanation in discussion 🙂

good explanation Hugo...