Knowledgebase : How To > SQL Server
After SQL Fails Over to New Node Reports No Longer Work In ProjectDox ISSUE: After SQL Fails Over to New Node Reports No Longer Work In ProjectDox. When a fail-over occurs to another SQL Server node, the Report Server database gets a new encryption key ...
DATABASE ERD & DATA DICTIONARY FOR PROJECTDOX 8.2X PROJECTDOX VERSION 8.2x and above. RESOURCES Please refer to the attached documents for the ProjectDox ERD and Data Dictionary. Revised 02-18-2015
DESCRIPTION  SQL SERVER PRODUCT TYPE RTM (GOLD, NO SP) SP1 SP2 SP3 SP4 SQL SERVER 2014 codename HekatonSQL14 12.00.2000.8 SQL SERVER 2012 codename Denali 11.00.2100.60 11.00.3000 [http://www.microsoft.com/en-us/download/details.aspx?...
DESCRIPTION ProjectDox and its associated features require the use of a SQL Server database, which stores all of the data captured by its usage. Throughout the course of day-to-day operations, data is written to and removed from the database constantly, ...
SOLUTION TUNING THE PROJECTDOX DATABASE USING SQL PROFILER, AND TUNING ADVISER NOTE: The interface of the tools may vary with the version of SQL Server you use. Please consult Microsoft's web site or other documentation for additional information. IM...
TO INSTALL SQL SERVER 2008 REPORTING SERVICES * Insert the Microsoft SQL Server 2008 product DVD into the DVD Drive, and run Setup.exe to open the _SQL Server Installation Center_. * In the _SQL Server Installation Center_ window, click INSTALLATION f...
DESCRIPTION Reporting metrics queries for ProjectDox SQL Database SOLUTION AVERAGE PROJECT SIZE selectAVG(MB)from ( SELECT p.Name AS Project, (SUM(f.Filesize)/ 1024)AS MB FROM Projects p JOIN Files f ON p.ProjectID = f.ProjectID GROUPBY...
When modifying the SSRS reports, make sure, before checking them in, that they export correctly in PDF. Some of the reports are not easily printed on 8.5x11 sheet of paper, make sure they all export into one page width in PDF. This means, no extra blank p...
DESCRIPTION What is an "orphan project"? It is the result of a project OWNER being deleted therefore, when you attempt to add a project, it fails and you probably don't see all the projects on your list that you should. SOLUTION Run the first script t...
ALL SQL SERVER ADO.NET CONNECTION STRING PROPERTIES This table shows all connection string properties for the ADO.NET SqlConnection object. Most of the properties are also used in ADO. Using this table will give you a better understanding of the options...
SQL Server Service Account On some occasions where the SQL Server Service Account has been modified after the initial installation to use a different account for starting up the SQL Services, users will experience slowness and poor performance within the...