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

Differnce between sel server 2000 and 2005

Answer Posted / narasimha

1)sqlserver 2000 contain query analyzer and enterprise
manger as a seperate tools but sqlserver 2005 contains a
single management studio(query analyzer + enterprise
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management
studio for dedugging sp's.

4)CLR stored procedures

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What stored by the msdb?

952


What is self join in sql server joins?

961


Explain foreign key in sql server?

973


How to set database to be single_user in ms sql server?

966


How can I create a report based on a query? : sql server management studio

973


What are the limitations/drawbacks or ssrs 2008 r2?

129


Is foreign key unique?

956


What is plan freezing?

909


Mention the differences between substr and charindex in sql server.

983


How to return the top 5 rows from a select query in ms sql server?

1072


Why should we go for stored procedures? Why not direct queries?

1026


What are the properties of primary key?

913


What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

932


Tell me something about security and sql azure?

114


you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration

890