what is advantages in sql 2005 over sql 2000?

Answers were Sorted based on User's Feedback



what is advantages in sql 2005 over sql 2000?..

Answer / ashis

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.

Is This Answer Correct ?    8 Yes 0 No

what is advantages in sql 2005 over sql 2000?..

Answer / gowthami radhakrishnan

sql server 2005 replaces query analyser and enterprise
manager with management studio

Is This Answer Correct ?    5 Yes 2 No

what is advantages in sql 2005 over sql 2000?..

Answer / adhi

Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH

Is This Answer Correct ?    3 Yes 1 No

what is advantages in sql 2005 over sql 2000?..

Answer / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

Is This Answer Correct ?    2 Yes 2 No

Post New Answer

More SQL Server Interview Questions

What is policy based management (pbm)? : sql server database administration

0 Answers  


What are the different types of collation sensitivity in sql server?

0 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


Advantages and disadvantages of stored procedures.

2 Answers   HCL,


How you can minimize the deadlock situation?

0 Answers  






1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do

0 Answers   CSC, IBM,


can you any body tell me which service pack is installed in the sql server?

3 Answers  


What is a cursor in SQL Server 2000 and their types?

8 Answers  


Explain how to integrate the ssrs reports in application?

0 Answers  


How many triggers you can have on a table?

0 Answers  


What is clustered index

0 Answers  


What is sql server agent and what are the two modes of authentication in sql server?

0 Answers  


Categories