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...