• Any of the given options are not correct for SQL Server 2005. it is only suitable for SQL server 2008