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 the difference between a local and a global variable?

5 Answers  

In clustered and non clustered indexes which one is faster while executing a query ?

1 Answers  

What are the dmvs? : sql server database administration

0 Answers  

What are triggers in ms sql server?

0 Answers  

What is the default schema of your login session in ms sql server?

0 Answers  

How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

Can a rule be bound to any column of any data type?

0 Answers  

How to concatenate two strings in SQL Server.

0 Answers   HCL,

What is user-defined function?

0 Answers  

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

What is NOT NULL Constraint in sql server 2012?

0 Answers   CDC,

For more SQL Server Interview Questions Click Here
Categories