DIFFERENCE BETWEEN SQL SERVER 2005 and 2008

Answer Posted / dinesh rathod

1, XML datatype is introduced. XML datatype is used. 2, Can not encrypt the entire database.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can move data or databases between servers and databases in sql server?

556


Do comments need to go in a special place in sql server 2005?

504


What is in place upgrade in sql server?

512


How do we synchronize On-Premise SQL server with SQL Azure?

96


What are the system database in sql server 2008?

571






If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

550


how can a database be repaired? : Sql server administration

514


What is the difference between for xml raw and for xml auto?

558


While using a cursor, how can you differentiate between a deleted row and a row that has been inserted with null data values?

547


What is a deadlock and what is a live lock?

567


What is updatable resultset?

508


What is logon trigger?

541


How do database indexes work?

542


What are the different types of normalization?

608


What is dimension table? : sql server analysis services, ssas

556