wat is the main diff between sql server 2000and sql server 2005

Answer Posted / gyan ranjan

New Data Types.
Full Text Search
And many new key words

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between inner join and equi join?

500


What are the pros and cons of putting a scalar function in a queries select list or in the where clause?

734


What is a trigger what are the advantages of trigger?

535


What is the difference between delete and truncate statements?

579


How to create a new table in a given schema?

668






Can an automatic recovery be initiated by a user?

570


How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?

1588


How does clustered and non clustered index work?

527


How do I start sql server agent automatically?

510


How to generate create view script on an existing view?

574


How does Report Builder support Analysis Services cubes?

110


What is attribute relationships, why we need it? : sql server analysis services, ssas

510


What is the maximum number of index per table?

573


What does truncate do?

541


Explain the relational database management system (rdbms)?

538