Thanks very much for your suggestions, I will now look at the different options.

Unfortunatelly disk space is at an absolute minimum, and I need to use the free space for other purposes. This is SAN attached storage, and I am awaiting other disks...

There is now regular archiving set up on the database, so it will only populate the around 200GB of the 250Gb allocated, after the shrink.:-)

Anyone have any thought on this?

The error message did not appear in the previous post, it is -

unable to create UPDATE for record with only large data types

It cannot possibly be 'dob' cause the question specifies join_date column.

I have found the solution to this as follows:-

After uninstalling "Microsoft SQL Server Compact 3.5 SP1 Beta Management tools ENU" first and install the "sscesqlwbtools.msi" in the "servers/setup" folder of...

Thanks Colin,

Hope things are going well for you, you probably remember me from one of your previous contracts.

Hello,

My colleague has found this link which appears very useful regarding the permissions problem I have.

http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx

Basically I need to run the decryption code in a UDF with EXECUTE...

Hi Brian,

I tried the suggestions, but I still have the problem.

I basically granted view definition on symmetrical and asymmetrical key, and then revoked control on both.

But the decryption via the...

Thats works perfectly, thanks Michaela for your help.

I didn't know it was possible to change  permissions on a proc in mssqlsystemresource like this, as the stored procedure is not visible...