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 use of attribute hierarchy optimized state? : sql server analysis services, ssas

1008


What are the types of joins in sql?

1055


What is a DBMS, query, SQL?

996


What is an example of a foreign key?

927


Which are the new data types introduced in sql server 2008?

843


Benefits of Stored Procedures?

918


How to grant a permission in ms sql server using "grant execute" statements?

1025


How to defragment indexes with alter index ... Reorganize?

1024


Can you import Microsoft Excel data to SSRS?

123


what method you can use to reduce the overhead of Reporting Services data sources?

234


What is a result set object returned by mssql_query()?

1070


Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?

895


What are approximate numeric data types in ms sql server?

1004


what are the types of indexes? : Sql server database administration

1060


What is a field in a table?

983