Hi,
i wanna know how to use rollback in sql server without actually using transaction...
is there any way i can do that?
thanx in advance
nope,
rollback will work only when transaction has been issued. Or take a daily backup of database so that you can retrieve it with previous days status
rgds
ramu
|||
::i wanna know how to use rollback in sql server without actually using transaction...
What sense would it make? The ability to separately commit/rollback changes is the definition of a transaction. You with is like drinking water without getting in touch with h20.
If you need transactional control, use a transaction. And rolling back changes you did IS transactional control.
|||Hey thanks for ur replies.
me gonna implement transactions!!
thanx again
No comments:
Post a Comment