Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is policy based management (pbm)? : sql server database administration
What is the difference between varchar and varchar types?
To automatically record the time on which the data was modified in a table, which data type should you choose for the column?
Tell me what do we need queues in sql service broker?
How many database files are there in sql server 2000?what are they?
How to drop an existing table?
What is sharding?
What are the properties of the relational tables?
What is open database communication (odbc)?
what's sql server? : Sql server database administration
What are the new features of sql server 2008 r2 reporting service?
How to join two tables in a single query in ms sql server?
Give some Scenario for Non Clusterd index? Can we write system defined functions in side The Function? Wat is the Unique Datatype?
What are transactions in sql?
What are rest-style architecture's?
