Answer / ashis

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.

Answer / gowthami radhakrishnan

sql server 2005 replaces query analyser and enterprise
manager with management studio

Answer / adhi

Database mirriong
database snapshot
CLR integration
DDL Trigger
Schema
we can install up to up 50 instance (in 2000 only 16)
Try& CATCH

Answer / subbu

Newly introduced in Sql server 2005
======================================
DDL trigger (This trigger fired only create new table or
Drop table or Alter table).Created in either Database or
Server.
To Deploy .Net procedures.
CLR Integration.
TRY & CATCH Mehod (For Error Handling).

what is Equity join?

2 Answers   ADP,

---

How to write character string constants or literals in ms sql server?

0 Answers  

---

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers  

---

What is a Linked Server?

1 Answers  

---

Tell me extended events in sql server 2008?

0 Answers  

---

---

Do you know nested transaction?

0 Answers  

---

How to round a numeric value to a specific precision?

0 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

0 Answers  

---

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

What are sql dirty pages?

0 Answers  

---