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 to get a list of columns in a view using the "sp_help" stored procedure?

0 Answers  

What are the advantages of using cte?

0 Answers  

How does recursive cte works in sql server?

0 Answers  

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

Can sql servers linked to other servers?

0 Answers  

from the table display the 2nd highest salary? and also the least 2nd salay?

8 Answers  

explain different types of constraints? : Sql server database administration

0 Answers  

Can you get second highest salary from the table?

0 Answers   QuestPond,

Why are sql functions used?

0 Answers  

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

If you want to send some data from access database to sql server database. What are different component of ssis will you use?

0 Answers  

What are the features of Embedded SQL

0 Answers   HCL,

For more SQL Server Interview Questions Click Here
Categories