difference between sql server2000 and sql server2005
Answer / rajkumar
1.SQL Server 2005 has better tool enhancements like SQL
Server Management Studio.
2.Developers can write Native .NET Stored Procedures and
deploy them to SQL Server 2005.
3.It has more Enhancements in the areas of DBA, Developer
Productivity with .NET
For More details..Verify these links..
http://wiki.answers.com/Q/Diff_between_sql_server_2000_and_s
ql_server_2005
http://techinterviewquestion.blogspot.com/2008/06/some-
difference-between-sql-server-2000.html
| Is This Answer Correct ? | 6 Yes | 0 No |
What is normalization and denormalization in sql server?
What is thr feature of change data capture?
Explain system views?
What are sql server procedures?
What are the differences between stored procedure and view in sql server?
What is difference between table aliases and column aliases? Do they affect performance?
What is the difference between temp table and table variable?
Questions regarding Raiseerror?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is a partitioned view?
What is the default value of an integer data type in sql server 2005?
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)