It you wish to avoid accidental use of DROP table then  use CREATE VIEW with SCHEMABINDING

This will  generate error  when drop statement is executed, so DBA can have a second...

Hi,

Yes, I can do that as a work around, but what I am looking for is some kind of PROPERTY which gives me the DESCRIPTION or NAME of STEP which...

Is this ORDER BY statement works ..... not for me...

ORDER BY (case when SequenceNumber >= @lastSeqNumber then 0 else 1 end ), SequenceNumber

PERFECT !!!!

It was for this particular reason I was looking for the info.

Thanks once again

Deepak

Hi,

EXTRACT FROM BOL for your quick reference;

Each transaction log file is divided logically into smaller segments called virtual log files. Virtual log files are the unit of truncation...