I want to be sure that I have enabled RCSI on my SQL Server 2008. Is there a way to display the flags on different features of SQL to tell if they are on or off? I also wasn't sure if running the query to turn the feature on again would hurt anything.
Thanks