wht's the differece between sqlserver05 and sqlserver2000
Answers were Sorted based on User's Feedback
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 |
Answer / monal
SQL 2005: Database Snapshot, SNAPSHOT Isolation
Level, .NET, CLR, Online Backup, Online Index Building
| Is This Answer Correct ? | 0 Yes | 0 No |
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 |
What is dknf in normalization form?
What is for xml in sql server?
What is difference between views and tables?
Do you think BCNF is better than 2NF & 3NF? Why?
what is cluster and nin-cluster index?
What is the use of CASCADE CONSTRAINTS?
How to create a Master database in SQL server ?
what is a major difference between sql server 6.5 and 7.0 platform wise? : Sql server database administration
Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you
What is difference between group by and having?
What is difference between views and stored procedures?
What is the difference between having and where clause?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)