Project not opening in Read/Write mode – Project Server 2007

Sometimes it happens that when a user want to open a project schedule from project professional it does not open in write mode. This is because that last time the project was opened it was not checked in properly. There are two ways to overcome this problem: First, do not retrieve all projects from Server, [...]

SQL Server Version

If you need to know the version you are currently running of SQL Server you can easily get it by running the following query. SELECT ‘ SQL Server ‘ + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productversion ‘ )) + ‘ – ‘ + CONVERT ( varchar ( 100 ),SERVERPROPERTY( ‘ productlevel ‘ )) [...]