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? : Sql server database administration
How many full-text indexes can a table have?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
Tell me what is use of except clause? How it differs from not in clause?
How many types of database relationship in sql server?
What is a fill factor?
Does partitioning improve performance sql server?
can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?
What is difference between view and materialized view?
In join, which clause in not used?
What are the requirements on sql server network connections?
is there more the two primary key in a single table?
26 Answers Eforce, Systematix,
Oracle (3253)
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)