Thanks for the replies. 

So yes, the database was no longer listed in sysdatabases, the mdf & ldf disappeared & the db was - no shit - not...

perfect, very interesting - didn't realise any of the memory implications - thanks for the reply Jonathan.

So there are workarounds: it works fine if I go through the whole format as HTML business.  Also if I set @attach_query_result_as_file = 1 (instead of zero).  But it's really...

Thank you so much John!  It worked. 🙂

Cheers Scott.  This is probably technically was I was originally after & not something I'm familiar with so thank you.  I'll have a read up and a play.

Steve...

Sue / Jeff, you're both quite right. 

We have no test system & no chance of one so I am trying to make the best of that.  You've...

Because it's not just me that's going to be doing it.

Standard user group need to be audited.  Trigger must fire.
Admin type of user group need to be...

Sue, you are a genius!  And your instructions are super clear!  This has been bugging me for days.  Thank you so much.

🙂

All good points, thanks for helping me think it through.

Ok, thanks for the replies.  I know it's possible, I guess I was wondering if it is adviseable.

Thanks sue. Appreciate the reply but I have given the users full access as sys admin from the home home (& down as inherited). Must be something else.

Do the...

Bugger.  I will get back to the drawing board.  Cheers for the reply.  All this spatial stuff is a brave new world for me atm.

Blimey!  That looks complicated.  Thank you Thomas.  I think that's exactly what I need, just need to get my head around it.  Appreciate your time / response.  Sometimes it's hard...

Also when amending windows permissions for a SQL service account - do I need to restart for the changes to take effect?

Understood and thanks for replying. 

I guess I have two questions.  I'm trying to make it simpler because I waffle!

1 - how do I compare two rows...