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

What is the difference between distinct clause and group by clause?

2 Answers   HHH, Value Labs,

What are the options which must be set to allow the usage of optimistic models?

0 Answers  

Can sql servers linked to other servers like oracle?

0 Answers  

What are the OS services that the SQL Server installation adds?

3 Answers  

What do you mean by 'normalization'?

0 Answers   Ernst Young, Thomson Reuters,

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

1 01 101 01010

0 Answers  

What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?

0 Answers  

what is raid? : Sql server database administration

0 Answers  

List the various tools available for performance tuning?

0 Answers  

What is buffer cash in sql server?

0 Answers  

What is service broker?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories