Assume a database was created using the following script on a server that has all the installation defaults, namely character set “iso_1” and default sortorder id 50, “binary_iso_1”.
> create database xpubs > go > use xpubs > go > create table authors (au_id int, au_lname varchar(255), au_fname varchar(255)) > go > create index au_idx on authors(au_lname, au_fname) > go
Then the data was loaded into the server using a series of inserts and/or updates.
