Sorry everyone I have solved the problem myself. I found that when i looked at the table in design view i.e. 'Modify' I found that the nvarchar which...

We have done it! It has worked! Thanks Paul and everyone else that has contributed.

Am really pleased this is my first .net / sql project and although it...

Just had another thought my thirty day trial version must have been enterpriser eddition, although I never did check.

The windows server operating system on that virtual hard disk was certainly...

I have just taken the -g switch out of the Startup Parameter.

I didn't put it in myself so just to clarify that I have done it correctly

I have removed the...

Paul I forgot again.

We are running SQL Standard 9.00.3042.00 SP2.

Paul good point to try. Thanks again for all your help.

I have just moved the dll to C:\ and have tried the following code:

USE [NSG_Data]

GO

EXEC sp_configure 'clr enabled', 1

GO

RECONFIGURE

GO

/******...

Paul in answer to your questions.

The server is 32 bit, it has 4.00GB of physical memory.

Virtual Memory is configered:

C: 512 - 1024MB

D: 6144 - 8192MB

Which I am told is how...

Paul thanks for your questions i shall answer them shortly. Just a quick update we tried increasing the memory available by increasing the -g switch to -g1024 and restarted...

Thanks for your post, I have since posting read this:

http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/ec8d66c9-a065-439f-ac84-346825992b34

It mentions that restarting the service, as we did, isn't sufficient to apply the change to the startup parameter.

I was told...