That is the Developers Edition

and the scripts are -

--creating table

CREATE TABLE [Emp] (

[EmpID] [int] NOT NULL ,

[EmpName] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,

[salary] [decimal](9, 2) NULL ,

[EmpType] [nvarchar] (10)...

I m working with SQL Server 2000.

An indexed view is any view with a unique clustered index ...

Attaching the query..

Full-Text indexex are used for full-text searching. The search which is not possible with ordinary indexes and search procedures can be done using the full-text searching.

SQL Server full text...

:unsure:This is not an efficient script, it doesn't include tables without clustered indexes(primary key).