Click here to Skip to main content
15,917,176 members

Comments by onetdev (Top 3 by date)

onetdev 25-Jul-16 6:58am View    
savepoint is nothing but save in sqlserver, Take reference from
https://technet.microsoft.com/en-us/library/ms178157(v=sql.105).aspx
onetdev 25-Jul-16 5:41am View    
what is save tran Z, is it savepoint. if it is savepoint then you can roolback till savepoint. or roolback is helpful if you have opened transaction before delete.
or simply deleted with out transaction sqlserver is auto commit as of my knowledge.
onetdev 6-Jun-16 11:55am View    
@OriginalGriff:Thank you for your quick response and suggestions.