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...

what is advantages in sql 2005 over sql 2000?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data modeling and Reterminal integrity?

2011


If the job running very slow what is the action you do

1942


Give an example of why you would want to denormalize a database

1030


How to get a list of all tables with "sys.tables" view in ms sql server?

1085


What are the disadvantages of using querystrings to send data from one page to another?

1071


Issues related in upgrading SQL Server 2000 to 2005 / 2008

1940


how you can deploy an ssrs report?

185


Tell me about normalization in DBMS.

1061


Find first and last day of current month in sql server

1080


Explain multiserver query

1113


how will add additional conditions in sql?

1170


How global temporary tables are represented and its scope?

1015


Please illustrate physical database architecture? : SQL Server Architecture

1029


how to control the amount of free space in your index pages? : Sql server database administration

1086


Explain transaction server explicit transaction?

974