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 is subquery? Explain the properties of a subquery?

0 Answers  

what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

How do you delete duplicate records in sql server?

0 Answers  

Do you know what is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

why would you call update statistics? : Sql server database administration

0 Answers  

What are the system database in sql server 2008?

0 Answers  

HOW TO RENAME A COLUMN NAME

3 Answers  

What is your recommendation for a query running very slow? : sql server database administration

0 Answers  

What are the authentication modes in sql server? How can it be changed?

0 Answers  

What is the difference between Drop and Truncate

20 Answers   GT Nexus, IBM,

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

What are the different authentication modes in sql server? How can it be changed?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories