Answer / narasimha

1)sqlserver 2000 contain query analyzer and enterprise
manger as a seperate tools but sqlserver 2005 contains a
single management studio(query analyzer + enterprise
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management
studio for dedugging sp's.

4)CLR stored procedures

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 / kumari

1)sqlserver 2000 contain query analyzer and enterprise
manger as a seperate tools but sqlserver 2005 contains a
single management studio(query analyzer + enterprise
manger).

2)sql 2005 contain CLR Integration

3)sql 2005 contain sqlserver business intelegent management
studio for dedugging sp's.

4)CLR stored procedures

5) SQL 2005 integrates very well with Visual Studio and dot
net as well.
6)One of the new features of security is that it can be
applied in a way
you want. Its quite flexible but it can get quite confusing
if you are
not sure of what you want to do. Users and groups can be
controlled
quite extensibly with the new security features.

7) The DTS of SQL 2000 has been replaced with SSIS (Sql
Server Integrated
Services) - Its an advanced version of dts but can do more
than dts. You
can manipulate all your data, within each SQL task and
theres a whole
list to it. Each field or column of data retrieved for the
purpose of
transfer can be manipulated in a variety of ways, and using
just what
you require for the final extract or transfer

What you can do to delete a table without the delete trigger firing?

0 Answers  

---

Let’s say the table in the database is named as TBL_Register. The fields in this table include: 1. User_Name, 2. User_Telephone, 3. Register_Date The field Register_Date stores the current date and time of the registration. Write the SQL statement that inserts the data into the table.

2 Answers   Techno Solutions,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

How to download and install microsoft .net framework version 2.0?

0 Answers  

---

Diffrence between DTS vs SSIS

2 Answers   IBM, Infosys,

---

What are different type of Collation Sensitivity?

0 Answers  

---

What is an sql server agent?

0 Answers  

---

What about UPDATESTATISTICS ?

2 Answers   HCL, Intelligroup,

---

what are different types of raid configurations? : Sql server database administration

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What is Report Server,Report Manager and Report Builder in SSRS 2005?

1 Answers  

---

Is t sql the same as sql server?

0 Answers  

---