Hi Everybody,
I am Vijay.According 2 me the differences are:
1. In SQL Server 2000 the Query Analyzer and Enterprise Manager are seperate,whereas in SQL Server 2005 both were combined as Management...
The list of changes is too long to type so here is a website that has everything you ned to know:http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/
SQL Server 2005 has come up with new BI reporting tools, which is also called as 'Yukon'. This was the only significant reason to bring in the new version of SQL Server 2005 apart from the basic...
A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs. Triggers are stored in and managed by the DBMS.Triggers are used to maintain the referential...