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

wht's the differece between sqlserver05 and sqlserver2000

Question Posted / aseem

Answers were Sorted based on User's Feedback



wht's the differece between sqlserver05 and sqlserver2000..

Answer / jerry joseph

.NET Runtime integration
SQL Server 2005 is integrated with .NET Runtime

Email sending capability
You can send emails from SQL Server 2005 which you couldnt
do with SQL Servr 2000

TRY CATCH error handling
In SQL Server 2005 we have TRY CATCH for better error
handling. We had only @@ERROR in SQL Server 2000 which was
very primitive

Is This Answer Correct ?    2 Yes 0 No

wht's the differece between sqlserver05 and sqlserver2000..

Answer / monal

SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building

Is This Answer Correct ?    0 Yes 0 No

wht's the differece between sqlserver05 and sqlserver2000..

Answer / velmurugan,uk

There are many differences interms of
1.Architecture,
2.Services,
3.Performance,
4.Scalability,
5.Design and Deployment application,
6.Tools
and so on...

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More SQL Server Interview Questions

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

0 Answers  

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

How to choose all records from the table?

0 Answers  

How do I start and stop sql server?

0 Answers  

What is database replicaion? What are the different types of replication you can set up in SQL Server?

3 Answers  

What are the types of stored procedures in an sql server?

0 Answers  

Define union, union all, minus, intersect?

0 Answers  

What is the difference Between Sql-server 2000 & 2005

3 Answers   Value Labs, Wipro,

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

0 Answers  

what authentication modes does sql server support? : Sql server database administration

0 Answers  

What is the maximum length of an alert name?

0 Answers  

Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

For more SQL Server Interview Questions Click Here
Categories