Contents
What is the difference between SQL 2005 and 2008?
There are some differences between both….Difference between Sql server 2005 and 2008.
| Sr No | SQL Server 2005 | SQL Server 2008 |
|---|---|---|
| 1 | XML datatype is introduced. | XML datatype is used. |
| 2 | Can not encrypt the entire database. | Can encrypt the entire database introduced in 2008. |
| 3 | Datetime is used for both date and time. | Date and time are seperately used for date and time |
What is the difference between SQL Server 2008 and 2008r2?
SQL Server 2008 R2 has more visual features than the SQL Server 2008. As well as SQL Server 2008 R2 supports for mainly data analysis, data presenting and deal with databases which is located in several physical locations. It’s not a total new product.
How to check a database’s compatibility level in SQL Server?
In SQL Server, you can use T-SQL to check the compatibility level of a database. All you need to do is query sys.databases to find the compatibility level for the database in question. Here’s an example: SELECT compatibility_level FROM sys.databases WHERE name = ‘WideWorldImporters’; Result:
Is the SQL Server 2008 R2 compatible with Windows?
SQL Server 2008 and SQL Server 2008 R2 are not supported in Minimal Server Interface mode or Server Core mode. For more information about the installation options that are available when you install Windows Server 2012, see Windows Server Installation Options.
Can you use SQL Server 2005 in Windows 8?
Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8.
Do you need Service Pack 3 for SQL Server 2008?
For SQL Server 2008 R2, you have to install Service Pack 3 (SP3) or a later version. Please also check known setup issues when you install SQL Server 2008 R2 and SQL Server 2008 on a computer that is running Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8.