difference between sql server2000 and sql server2005
- 1 Answers
- 4873 Views
- KPMG, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is data source in connection string?
How to download and install sql server 2005 books online?
Do you know exporting and importing utility?
What are the aggregate and scalar functions?
What are statistics?
List out some of the requirements to set up a sql server failover cluster?
What is difference between rollback immediate and with no_wait during alter database?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
What is a result set object returned by mssql_query()?
What is ddl and dml commands?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
Explain what is use of dbcc commands?
What are the acid properties?
Can we use where clause in union?
How do you start single user mode in clustered installations?
