If I added a schema, could I restrict sysadmins to that?

Ok thanks. I'll give encryption a crack... The problem is this is HR data and therefore even administrators should not see the information.

Hi,

I've solved this.... i used this as an example

with xmlnamespaces('http://ww.w3.org/TR/html4/' as h)

select getDate() as '@timestamp',

( select name as '@name', xtype as 'data/@xtype'

from sysobjects

...

Nothing has changed to the SP they are using the standard one.

Nop still don't understand, perhaps I'm having a blonde day!

The output shows....

TCPTSQLSQL

COMWTSV06DATA_LOADDATA_LOAD

DATA_LOAD being the local user login....

Listen don't worry, it's working for me I was just trying to help...

Hmmm still don't understand....

I am on a Citrix server, connecting to SQL Server remotely using a local SQLSERVER user.

My NT account has NO permissions to the SQLSERVER box, I can't...

Hi Steve,

The domain stuff was done by the infrastructure team.... So don't know whether they did what you suggested with that.

With regards to SSMS I connected directly to the server...

I dont understand why we don't get the error 'files requires an integrated client login.'

We can use a local login to send an email with an attachment!

Pete

Also is the D: drive a mapped drive? if so try using the UNC path instead. Also have you checked that the SQL Server service login has permission to look...

Hi Hmmmmm Did you run the test mail when logged in using your rpp account?

Also did you try running the send mail command from SSMS (also using the rpp...

That is very weird behaviour....

Mind you I never understand why there is a requirement to shrink databases anyway. To my mind you should size the database correctly in the first...

In our mail profile we use anonymous authentication... Do you use that?

Hi,

I don't think this is the problem, as I have just run the same command in my environment....

msdb..SP_SEND_DBMAIL

@RECIPIENTS = 'XXX@XXXXXX.com',

@PROFILE_NAME ='MAIL',

@SUBJECT = 'TEST',

@BODY='TEST',

@BODY_FORMAT = 'HTML',

@file_attachments = 'C:\WWW.sql'

I used a...

Thanks Dave, however I've given up with using SSAS it seems that it doesn't really perform well when there is a medium/large amount of data to crunch. I've gone back...

Hi,

Well just in case someone else is having the same issue.... I used the following.... on the desktop

control keymgr.dll

Added the server name and my login/password

then removed it....

Then all worked.... Very...