Reporting Database - READ COMMITTED SNAPSHOT

D

David F-H

Project Server 2007 SP2 / SQL Server 2005 SP3

I was wondering if anyone has any advice about applying the "READ COMMITTED
SNAPSHOT" option on the ProjectServer_Reporting SQL Server database ? Are
there any problems with doing this ? I want to ensure integrity between the
reporting tables and a new summary table that will be updated every time a
report runs, and our DBAs have advised this as a solution.

Thanks,
David
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reporting Database - Transaction Level 1
Connecting Project Reporting Database from MS Access 2
Reporting Database - Data Integrity Question 4
Monthly Database Snapshot - Project Server 2007, SQL Server 2005 2
Cube Build Error 0
SP2 Upgrade failed 1
MS SQL Server 2005 Reporting Services Add-n for MS Sharepoint CUub 0
Reporting(Project Published) Failed But Not Blocking Correlation 2

Top