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

Where do we generally create INDEX?

1 Answers   Ernst Young, Thomson Reuters,

---

You are doing log shipping due to some reasons it is failing. How you will proceed from there

0 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?

0 Answers  

---

How make remote connection in database?

1 Answers  

---

What is table constraint?

0 Answers  

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

Explain Geography datatype in SQL Server

0 Answers   Infosys,

---

How to create new tables with "create table" statements in ms sql server?

0 Answers  

---

Can primary key be null?

0 Answers  

---