Version is still at 3042

Are there installation instructions I missed?

Thank you for your assistance -

Alan

This is the section on the server engine from the SUMMARY.TXT file:

Product ...

The collate change was unnecessary. Not having to change collation makes testing a large application much simpler.

This worked:

create table test1 (title nvarchar(200) COLLATE greek_ci_as)

INSERT INTO test1 (title)

VALUES (N'FceRI-mediated activity')

select * from test1

The "alter" works for columns already present.

Thank you, but it did not work.

Is there a database-level collation that might be effecting this?

I run the repair_rebuild both to find errors and to correct minor problems, and rebuild indexes, without risk of data loss, accorind to the BOL. At 4 AM Sunday...

Thank you for your help. The restore worked when I freed up enough space. My backup is only a few percent smaller then my database.

Under the covers Cache is a network database - an update of the state-of-the-art 25 to 30 years ago.  It was developed at Massachusetts General Hospital by their Lab of...

I'd like to see results of actual experimentation - actual change in performance, numbers of physical I/Os for different physical configurations.

I made a real mole hill out of a mountain on this one. The tables are created by a select ... into #table so even if no rows...

There is a good formating program for Oracle PL-SQL code sold by QUEST.COM called "Formatter Plus", but it works on only simple T-SQL. I have not found anything worth...

How should a SQL-Server database be copied to an MSDE environment ?? Does MSDE have a restore from SQL-Server capability?

Thanks

I would suggest maintaining the date-time column, and creating a set of computed columns which return the values using the DATEPART function. This will allow you to do date...