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 are the difference between primary key and unique key? : sql server database administration
How to change the name of a database user?
How to integrate the ssrs reports in application?
What are the different types of triggers in SQL SERVER?
What is normalization of database? What are its benefits?
How the authentication mode can be changed?
Write a code to select distinct records without using the DISTINCT keyword.
can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com
Explain the dbcc pintable command when would you use it?
Explain about sql server login?
What is a join in sql?
What is the purpose of the model database?
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)