Section 1

This section demonstrates creating an empty text index on an empty table.

isql -Sase1501sunbox -Usa -P -w2048 Dxml_db1

create table address_tbl

		(
				id numeric(5,0)
				identity, xmlcol text
		)
go
create unique index uidx on address_tbl(id)
go
sp_create_text_index 'textsvr', 'ti_address_tbl',
'address_tbl', "empty ", 'xmlcol'
go
(return status = 0)
quit