Maybe I've misunderstood the question. Row versioning in SQL 2005 is
just intrinsic in the product - it's always "on". Features like the new
snapshot isolation levels (which can be on or off), multiple active
result sets, online index creation, and inserted & deleted tables inside
triggers rely on row-versioning technology.
If you want to find out more about row-versioning, Kalen Delaney wrote a
good whitepaper on it last year. It's on TechNet:
*Database Concurrency and Row Level Versioning in SQL Server 2005*
http://www.microsoft.com/technet/prodtechnol/sql/2005/cncrrncy.mspx --
*mike hodgson*
http://sqlnerd.blogspot.com [quoted text, click to view] Jane wrote:
>Is there a way to see if a database has row-level versioning on/off from the
>Management Studio window, or do in need to run a T-SQL statement?
>
There is no on or off switch. It is always on.
--
Mike
http://www.solidqualitylearning.com Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.
[quoted text, click to view] "Jane" <Jane@discussions.microsoft.com> wrote in message
news:8935289E-EA79-40FE-978B-DD9A4F915754@microsoft.com...
> Is there a way to see if a database has row-level versioning on/off from
> the
> Management Studio window, or do in need to run a T-SQL statement?
