Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is advantages in sql 2005 over sql 2000?

Question Posted / ramkumar

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

How do you find the error, how can you know the number of rows effected by last SQL statement?

2 Answers  

please differentiate between delete and truncate?

0 Answers  

Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?

0 Answers  

How do I debug a stored procedure in sql server?

0 Answers  

How to insert multiple rows with one insert statement in ms sql server?

0 Answers  

How to tune a stored procedure?

6 Answers  

What is the use of MOVE keyword in restore command

3 Answers   IBM,

What is 2nf in normalization?

0 Answers  

Mention the command used to rename the database.

0 Answers  

What is user-defined function?

0 Answers  

What is full outer join in sql server joins?

0 Answers  

What are different types of subquery?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories