if you have no help: Microsoft? SQL Server? 2000 introduces several server improvements and new features:XML SupportFederated Database Servers User-Defined Functions Indexed Views New Data TypesSQL Server 2000 introduces three new data types. bigint is an 8-byte integer type. sql_variant is a type that allows the storage of data values of different data types. table is a type that allows applications to store results temporarily for later use. It is supported for variables, and as the return type for user-defined functions. For more information, see Data Types and Table Structures.INSTEAD OF and AFTER TriggersCascading Referential Integrity ConstraintsCollation EnhancementsFull-Text Search EnhancementsMultiple Instances of SQL ServerIndex EnhancementsFailover Clustering EnhancementsNet-Library Enhancements64-GB Memory SupportDistributed Query EnhancementsUpdatable Distributed Partitioned ViewsKerberos and Security DelegationBackup and Restore EnhancementsScalability Enhancements for Utility OperationsText in Row Data
Microsoft? SQL Server? 2000 introduces several server improvements and new features:XML SupportFederated Database Servers
User-Defined Functions
Indexed Views
New Data TypesSQL Server 2000 introduces three new data types. bigint is an 8-byte integer type. sql_variant is a type that allows the storage of data values of different data types. table is a type that allows applications to store results temporarily for later use. It is supported for variables, and as the return type for user-defined functions. For more information, see Data Types and Table Structures.INSTEAD OF and AFTER TriggersCascading Referential Integrity ConstraintsCollation EnhancementsFull-Text Search EnhancementsMultiple Instances of SQL ServerIndex EnhancementsFailover Clustering EnhancementsNet-Library Enhancements64-GB Memory SupportDistributed Query EnhancementsUpdatable Distributed Partitioned ViewsKerberos and Security DelegationBackup and Restore EnhancementsScalability Enhancements for Utility OperationsText in Row Data