We went to try to install Microsoft SQL Server 2008 R2 onto a clients server (2008 R2 is the version the client has a license for). We discovered that SQL 2008 (not R2) had already been installed. When we went to run SQL Server Manager, we found that the SQL Server directory on the C:\ drive had been deleted. Both SQL Server Manager and SQL Browser will not run because the directory had been deleted. We went to install 2008 R2 - SQL database installed but SQL Server Manager would not install saying that an earlier version had been installed. We went to try to start SQL Browser again, but it did not re-install either and will not run because the file is still missing.
Another problem is that they have SharePoint running on the SQL database that is installed. We thought about re-installing SQL server but how will this affect the instance of SharePoint?
We suggested that they have a separate computer to run SQL Server but "they didn't like the idea."
Any suggestions on how to recover the installation without affecting/destroying their instance of SharePoint?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL).
Depending on business requirements, a single Stored Procedure can return differe…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.