Category «SQL Server 2008 R2»

sp_SDS Stored Procedure updated to work with SQL Server 2008 R2

Derek Wade modified Richard Ding’s sp_SDS stored procedure to work with SQL Server 2008 R2. You can run the original stored procedure on SQL Server 2008 R2 however the report would be blank because there is version information in query for SQL Server 2008 R2 and this version information is expected. This version information has …

How to install/enable .Net 3.5 SP1 on Windows Server 2008 R2 for SQL Server 2008 and SQL Server 2008 R2

The .NET Framework 3.5 SP1 (also referred to as .NET Framework 3.5.1) is a prerequisite for SQL Server 2008. SQL Server 2008 Setup for standalone instance will install the .NET Framework 3.5 SP1 if it is not already installed. In Windows Server 2008 R2, the .NET Framework is a feature and installing it is different …