I had a similar issue, we removed one of the subscription report owners from Active Directory and the subscriptions failed.

I thought a Update of the subscription would do it but...

Hi,

I think I know what you require....I'd probably make the calculations at the source in SQL rather than in the layout(expression editor) of SSRS. It's a bit quicker and easier.

Something...

Hi,

Try logging onto the machine with the LOCAL administrator account and adding a your domain logon to the locally installed sql group. It will take the format of something like...

I think this should help

SELECT SUBSTRING(String,CHARINDEX('<DIR>',String)+1,LEN(String)) AS NewCol,String ,

CHARINDEX('<DIR>',String) AS POSITION,

CASE

WHEN CHARINDEX('<DIR>',String)>0 THEN

SUBSTRING(String,CHARINDEX('<DIR>',String)+5,LEN(String)) --AS NewCol

ELSE

String

END AS RevisedCol

FROM #Test

Regards,

Paul

Hi,

I've used SSIS to write the data to separate sheets.

So you have an Data Flow task with an OLE DB source with your query/queries and then an Excel Destination where...

Hi,

Yes you can use SSIS. I've used a Data flow Task and then an OLE DB Source to extract the data. You'd need to decide whether you

truncate and reload...

Hi,

I had a similar situation when I first arrived at my current company.

A few things to check.

1.Is the public server role a member of the sysadmin role?

2.Running a exec sp_helprotect...

Hi,

Database encryption isn't generally recommended as it will slow your application.

I'd recommend encryption of table columns that contain sensitive data(user details, phone number, email, etc). Anything in the public domain...