Thank-you. Have tested and can use revoke no problem, which will be fine.

Thanks guys. I get what you mean about Deny precedence, but please see this MSDN article...

http://msdn.microsoft.com/en-us/library/cc645930(SQL.100).aspx

Thanks

Think you may have to do this using the master\target option of a job.

Great stuff, thanks everyone!! 🙂

Thanks very much Eddie, yes it is a varbinary column and yes I see what you mean about converting it on insert. It does seem to confirm though that...

Thanks very much for responding to this Adi and your comments. As you can probably tell I am knew to encryption so perhaps am missing something obvious 🙂

Anyway, heres...

Thanks for you comments guys. I'll open a support call with MS as suggested.

Thanks for that Grasshopper. That was exactly what I did but still no joy!

Thanks but thats exactly the procedure I used. As mentioned in the body of my note I did run the Backward Compatibility (BC) msi too, but still no luck?

Did you ever get this working as i have exactly the same problem on a x86 based server. I've also tried other tips like copying 6 DLL files into...

Hi thanks, but my question was whether I can remove it. I appreciate what its for but dont understand the point in removing accounts from sysadmin only to set...

Hi, thanks both for your input. Well tried the proxy solution and that made no difference. I also edited the command line string of the job step to...

So thats the equivilent on 2005 is it. Thats a useful snippet of info to know too !!

Thanks very much for you help

Thats cool, thank-you for that. What threw me was your use of 'HOUR'. What it needs (and I'm sure you meant) was...

SUM(CASE when datepart (Hour,transaction_date_time) = 24 THEN...

I've read this back and haven't made myself too clear.

I've got the sum of each hour working, but what I meant about getting the other 2 'sums' to...