OCS 2007 Archiving SQL Queries

These are copied from the ArchivingCDRReporter read me… The following are some user specific SQL query samples that are intended to guide you through extracting relevant reporting user or time range specific information from the Archiving/CDR Database. The general usage queries are already added as part of the tool.

Running your SQL service under a domain account vs local account

Using my previous employers standard SQL build caused some issues installing a new OCS pool. The 2 errors are related to the articles below. Security Account Delegation http://msdn.microsoft.com/en-us/library/aa905162%28SQL.80%29.aspx Shrinking your model DB size. http://support.microsoft.com/default.aspx/kb/307487